Transfering info from main worksheet to multiple worksheets

J

jeffrey

i have a worksheet that looks kind of like this
hammonton NJ 08000 James 1/1/2008
rockford CA 32574 John 1/15/2008
washington DC 22602 Jenn 4/5/2008
princton NJ 08000 James 5/9/2008

I want to be able to setup worksheets after this main sheet for each person.
I want each sheet to automatically fill in the whole line without any gaps
in the lines and without having to go into each worksheet and say take this
line.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to transfer info from one worksheet to another 0
Multiple VLOOKUP in an IF statement 2
Totalling sequential worksheets 1
Excel Workbook with Multiple worksheets 2
combining data from multiple worksheets into one 6
Multiple worksheets 1
Copying Cell from Multiple Worksheets to a Summary Worksheet 4
Compare 2 worksheets all 6 columns in each worksheet 7

Top