For transferring data values from one sheet to another I'm thinking that VBA
would be your best bet.

I don't understand the part about "empty rows if the number does not pertain the
that worksheet"

Based on the number in column F, that row would be copied to the pertinent
worksheet to the next available row below the last copied row.

I will try to work something up but can take a while.

In the meantime see how Ron de Bruin copies data using VBA.

http://www.rondebruin.nl/copy1.htm

Could be you can adapt one of his routines.


Gord Dibben MS Excel MVP


On Thu, 28 Sep 2006 12:18:01 -0700, McMillanY45
wrote:

Can I try to set up what I want the spreadsheet to do? There will be
worksheets numbered 1-5. I will enter all information on worksheet one. There
will be a column(F) that will specify worksheets 2-5 per row on worksheet 1.
According to what numberis entered in column(F) on worksheet one, I need for
all of the information on that row to transfer to that specific spreadsheet.

Example:
Worksheet 1
A B C D E F G
9 28 loan clothes 3 $20.00

Worksheet 3
A B C D E F G
9 28 loan clothes 3 $20.00

Because of Column F and the number 3 all of the information on that row went
to worksheet #3.

I have tried out a thousand IF functions, but nothing seems to work. I have
figured out how to get them to the specific sheets but the are empty rows if
the number does not pretain to that worksheet. I need to be able to skip a
row if it doesn't pretain to the worksheet. Let me know what you think.