Hi,
I have a (Book 1) contain 2 sheets all the data in the sheet1 copied to sheet2 . when i delete a cell data from sheet1 it will be deleting from sheet2 automatically.
the problem is I need the data below the empty cell to shift up. the last cell need to be empty.
Example Attached.
Anyone can assist please
Sorry, I just don't understand what you're trying to achieve.
You have two red columns on sheet 2 and it's not clear what you expect to happen with column D. For instance do you expect the current D2 to 'wrap round' when column C is moved up and fill what will be a new empty C21?
Can you clarify and show us a before an after situation.
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.
Hi Richard ,
Thank you for you reply.
If you look to cell C4 in sheet2 it empty because I delete the data in sheet1 cell B14. That good.
What I need is to shift the data in sheet2 (C4) up . to full the empty cell which is (C3). And the empty cell will be the last cell in D which is (D21).
Thanks
Attachments updated
Hi,
In C2 of sheet 2 enter
OFFSET('after Sheet1'!$B$1,ROW()+10,0)
In D2 enter
OFFSET('after Sheet1'!$B$1,ROW()+30,0)
Copy both of these down to row 21
Regards
Obviously change 'after Sheet1' to whatever sheet name is applicable.
Hi,
It is not working for me.
can you please do it in the Attached file.
PLease note: I need the shift to work whenever i delete cell data from sheet1
Thx
Hi,
See attached.
Hi Richard ,
Thanks you for your reply, BUT this not shifting the data up in sheets2 if i delete cell data from sheet1
Regards
It is reporting the values you indicated if you delete the row on sheet 1.
Regards
Dear Richard,
I have create a new sheet for more explanation, I think my previous explanation was not clear.
thanks for assistance
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks