Superfly3372
New Member
- Joined
- Jun 20, 2006
- Messages
- 34
I have a SALES workbook linked to cells in another RESULT workbook. The SALES result workbook format will always stay the same, but the RESULT workbook may need rows added/deleted. When I do this the linked cells info in the SALES workbook stay linked to the original cell in RESULT instead of changing if a row is added/deleted in RESULT.
So right now:
"SALES" COLUMN A ROW 1 is linked to "RESULT" COLUMN B ROW 36.
If I insert a row in "RESULT" and now the info that needs to be reflected in SALES COLUMN A ROW 1 is in COLUMN B ROW 37. How can I have the link in SALES to now reflect "RESULTS" COLUMN B ROW 37?????
So right now:
"SALES" COLUMN A ROW 1 is linked to "RESULT" COLUMN B ROW 36.
If I insert a row in "RESULT" and now the info that needs to be reflected in SALES COLUMN A ROW 1 is in COLUMN B ROW 37. How can I have the link in SALES to now reflect "RESULTS" COLUMN B ROW 37?????