Duplicating rows across sheets

  • Thread starter Thread starter oberon.black
  • Start date Start date
O

oberon.black

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)..........
 
You must log in or register to reply here.

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

Format linked workbook cells (updated) 2
PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE, 1
Macro paste values help 5
Real-time sorting 11
Stripe out duplicate data 5
wrong reference after dragging down a formula 1
Data Entry - Write to next cell 3
reference is wrong 1

Back
Top