Is there a way in MS Excel 2003 where I can print from one sheet (as template) many sheets with different data

Question

Here is my situation; In an Excel Workbook, I have a worksheet (named: ws1) with information as a table, with the first row as field names (ie: Brand, Model, Serial Number etc) and in the same workbook I have another worksheet (named: ws2) as template, like a form with information about my company, logo, etc and some cells I need to fill them with the information in the other worksheet, but I need only one row from the table per each printed sheet from my template.

In other works a want to print each row from [ws1] but using [ws2] as a template, I don't want to create a worksheet per each row or typing again the same data. Is a lot of work!

Is that posible or I am out of my mind?

Answer 1

its very possible. theres a couple of ways to do this.

from what you describe, i would use vlookup

since you only want 1 template, then you would have to let excel know which line you want to see from ws1. so you will always have to input the 1 keyword (or #) in a specific cell. then the vlookup formulas will look at your input call and pull data from ws1 to fill in the blanks.

a real quick test would be to type a serial number in ws2. then do a quick vlookup formula that looks at the serial number and ill automatically pull up the brand. once you get that working, the rest is easy.

if the serial numbers are long, then add an extra column in ws1 and give it an easy number for each row and use that as your input.

Answer 2

use formulas in ws2 wich use data from ws1.
have a look here
http://blogs.msdn.com/excel/archive/2005/10/28/486604.aspx