Hi ,
I am trying simple macro.
I have sheet1 with column 1,2, & 3.
Sheet2 is identical.
There is a command button on sheet1.
If I select in sheet1 ( A) column any row and press command button then selected row is deleted from sheet1.
Pasted to sheet2 in next available row.
And sheet1 rows shift up.
Any suggestions and help please.
Kind regards
It is an event code and will be fired-on by changing the rows in column A
Try this .............
For detail see the attached sheet.
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Hi AB33 & Sktneer,
Both solutions are fantastic.
Very well done.
Really appriciate your help.
Thanks again
Kind regards
Glad to help you. Thanks for the feedback.
Hello sktneer,
That is brilliant (and simple!) and works really well for a similar problem I had. Just another question:-
I have a Totals row at around row 100 and of course this moves up also as rows further up are deleted. Can this Totals row be made static so it stays in row 100?
Kind regards,
vcoolio.
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks