| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Duplicating rows across sheets
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Duplicating rows across sheets
please take a look at thi -- oberon.blac ----------------------------------------------------------------------- oberon.black's Profile: http://www.excelforum.com/member.php...fo&userid=2673 View this thread: http://www.excelforum.com/showthread.php?threadid=46977 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Duplicating rows across sheets
just have aloo -- oberon.blac ----------------------------------------------------------------------- oberon.black's Profile: http://www.excelforum.com/member.php...fo&userid=2673 View this thread: http://www.excelforum.com/showthread.php?threadid=46977 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Duplicating rows across sheets
help please -- 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| duplicating rows | Excel Discussion (Misc queries) | |||
| Formula for Duplicating Rows!! | Excel Discussion (Misc queries) | |||
| Stop from duplicating entries on multiptle sheets | Excel Discussion (Misc queries) | |||
| Sheets duplicating | Excel Worksheet Functions | |||
| Duplicating Rows | Excel Programming | |||
![oberon.black[_93_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
