LinkBack URL
About LinkBacks
I have a task to consolidate all figures into one column.
I need to create a Macro to move negative values in column C ( any column as I select) and paste the same value to left empty cell.
Thanks
Please Login or Register to view this content.
VBA to move a cell to next blank cell
I have a task to consolidate all figures into one column.
I need to create a Macro to move negative values in column C ( any column as I select) and paste the same value to left empty cell.
ThanksPlease Login or Register to view this content.
Last edited by Leith Ross; 12-18-2012 at 01:20 PM. Reason: Added Code tags to preserve formatting
Hello Dusun,
Welcome to the Forum!
If the negative value were in column "D", would it be moved to column "C" or column "B"?
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!)
I only need to manage two columns of figures. Sometimes the set of figures may appears in column D and E instead of B and C. In that case I need to move the -ve figures in E to D. I need a macro that allows me to select any column as I wish in the active worksheet and move the cell values to next blank column one left. Hope that is clear.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks