Hello all,

I have an excel database spreadsheet that has many columns, two of which
interest me. €œNumber€� and €œSystem€�. What I want to do is go down each row
starting at say column 4 and extract the data from two columns, say column A
and B from row 4. Then put that extracted data into certain cells in another
sheet or even another file. (sheet will be simpler but file would be more
convenient ). And then save the document as a separate file so we can print
it. Then go to row 5 and so on. If the rows column A is blank then there
should not be a new sheet/file created.

Basically Im trying to make an automated form filling system so I dont
have to copy and paste 1000+ entries. What I need/am trying to do is to go
down a list and extract and put the data for each row in that list into
another file and save it according (or put into another sheet and save the
workbook?) How to start this€¦ I dont know completely yet.

Does anyone know how to do this? Or even if visual basic is needed? I know
how to link cells to each other but I think I need to go beyond that here.

Example Database (Columns A-C€¦ and Rows 4 to 6)
A B C €¦
4 X X X
5 Y Y Y
6 Z Z Z
..
..

Example form where the extracted first two columns per row will go:

Number __items go here (from row 4 column A)__
System __items go here (from row 4 column B)__

Then another sheet or file for row 5 column A and B, etc.

Any help would be greatly appreciated!

Thanks,
Lobo