Hello,
Please I need to find ALL empty cells in the G column and move the data from B to F to C to F.
HTML Code:
![]()
Please Login or Register to view this content.
Hello,
Please I need to find ALL empty cells in the G column and move the data from B to F to C to F.
HTML Code:
![]()
Please Login or Register to view this content.
Last edited by devcon; 06-29-2011 at 11:21 PM.
Hello devcon,
Here is a variation of your macro. Please note that Column "A" is not moved with other cells and row 1 is assumed to contain column headings.
![]()
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thank you very much for your help.
Have a nice day.
Devcon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks