Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding row in two sheets which are linked
I have seen this question asked in the past but have not found an answer
which actually works. I have two workbooks (Sales Sheet) and (Sales Compensation). Sales Sheet can be viewed by all employess in the Sales team but Sales Compensation is merely for corporate use. When I add a row with a new sales contract in Sales Sheet, I need it to also add a row to Sales Compensation sheet. I have both workbooks open when I update the rows but need to find a way to add a row to both sheets. By the way, the computations below each sheet are different so I can't just reformat all the cells to link to the new row since I then have to move all the formulas and redo the summations. Help?!! Thanks Don-- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Row in Linked Data | Links and Linking in Excel | |||
Linked sheets | Excel Discussion (Misc queries) | |||
linked values in other sheets | Excel Discussion (Misc queries) | |||
Adding rows in linked spreadsheets | Excel Discussion (Misc queries) | |||
linked sheets | Excel Discussion (Misc queries) |