Help me with this please: I need a macro to find first blank cell in a column cut the value from left adjacent column and paste in that first blank cell and continue routine until last blank cell and stop
Thanks
Help me with this please: I need a macro to find first blank cell in a column cut the value from left adjacent column and paste in that first blank cell and continue routine until last blank cell and stop
Thanks
Last edited by willykin; 04-01-2010 at 08:07 AM.
Please attach a workbook rather than a picture.
Hi willykin,
Here is an amateur attempt to do what you are looking for. The macro was modified from previous net posts and I am sure more experienced members can provide you with more assistance. Unitl then, this should perform the task you are looking for.
Best wishes,Please Login or Register to view this content.
Abousetta
This is an old thread but I wanted to update the response.
Here is a better approach:
abousettaPlease Login or Register to view this content.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks