Hello. I have 3 line items in the first tab. In the second tab I have formulas that say "=Sheet1!A1" etc. When I add a row in the first sheet, I would like it to update in the second but it doesn't. How can I do this? Additionally, I would like the formatting to stay the same in the second sheet, so if a row changes position the formatting will still be there. Is this possible? I've added a worksheet with more info.
You just need to copy your formula in Sheet2 down more rows. I would suggest this formula:
Formula:
Please Login or Register to view this content.
Otherwise if the corresponding row in Sheet1 is blank, your formula will show a 0.
Formatting will not change on Sheet2 no matter what happens on Sheet1.
(This works for adding new rows at the end of Sheet1. If you want to insert or delete rows, then you need a different approach.)
Yeah, I need to insert and delete rows. And there is no way to have the format move with the rows (not even a macro)? What if I have the formatting in sheet 1(somehow transferred to sheet 2)? Thanks.
To be able to delete and insert rows you would use
Formula:Please Login or Register to view this content.
Using that, row 2 of Sheet2 will always show whatever is in row 2 of Sheet1.
I misunderstood your point about formatting. To keep the formatting associated with the data being referenced requires one of two things. Can you explain how you decide what formatting to use?
- If your formatting is based on rules about the data then it can be done with conditional formatting
- If your formatting is arbitrary based on whatever the user wants to do with no particular rules, then it requires macros
- Edit: If you formatting is supposed to copy whatever is in Sheet1 then it requires macros.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks