I have a Workbook containing 2 worksheets. Sheet 1 feeds into sheet 2, which is the consolidated view. I know how to link the sheets but how can I make it so adding a new row in the middle of the already existing data in sheet 1 will show up in sheet 2 (in the right place). When i do this right now the cells do not get added in sheet 2 but when i click on cell 9 for example although it is still physically in row 9 the cell info shows cell 10.
Can anyone help? thank you in advance
Last edited by valle4782; 12-15-2011 at 03:11 PM.
This appeared to work =OFFSET(Sheet1!$A$1,ROW()-1,COLUMN()-1)
Now can anyone tell me how to integrate my IF function here. I currently have a working if function of,
=IF(Sheet1!A1=0,"",Sheet1!A1)
can anyone help?
Hi,
Can you upload the workbook so that we can see the request in context. Add a few notes and examples of a before and after situation.
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks