I am on the last leg of my project after this it is just working out a
few more save option.

This portion is pure hell. I need a code that I can insert that will
allow me to do the following.

What I need to do is get the information that is found in 'B10' and
'B11' of the 'CGS' worksheet to copy over to the client worksheets and
then get all of the information that each client has on there row
copied over to there worksheet.

example:
view from CGS
---------------------------------Date (B10)-----------Date
(C10).............
---------------------------------Income (B11)--------Expense
(C11).......
Smith, James (client)-------1,500 (B12)----------1,800
(C12)............
Johnson, Mark (client)------1450 (B13)----------1321
(C13).............


I would like for it to display as follows in (client worksheet)

Smith, James (worksheet)
Date (A12)-------Income (B12)----------------1500 (C12).........
Date (A13)-------Expense (B13)--------------1800 (C13)..........

Johnson,Mark (worksheet)
Date (A12)-------Income (B12)----------------1450 (C12).........
Date (A13)-------Expense (B13)--------------1321 (C13)..........


--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=469773