View Single Post
 
Old 08-19-2019, 08:27 AM
Cendrinne's Avatar
Cendrinne Cendrinne is offline Windows 10 Office 2013
Competent Performer
 
Join Date: Aug 2019
Location: Montreal Quebec Canada
Posts: 200
Cendrinne is on a distinguished road
Default Hummmm didn't work, but maybe my instruction where not clear....

GMayor,


What it did, it went to the last columns and in each cell that had the value ''$'' in it, moved completely the whole cell including the ''$'' to it's Right empty cell. And ignore all other columns.


In my test table (I only used tables of numbers, No text), I have 5 columns of numbers, and every columns has it's empty column besides, to enable to: Cut (the selected value, ...) ''$'', Move 1 Cell unit to the Right, and Paste (the selected value,...) ''$'', Loop to the end.


I just wish my macro I did, would do it all at once, versus, find and replace 1 value at the time.


I wish I could give an example of the test table. How can I insert without having to put a URL link?


Anyway, thanks and if you could think of something... I would be so grateful


I'll try the Guessed suggestion.

Last edited by Cendrinne; 08-19-2019 at 08:54 AM. Reason: Tried to be clearer in my answer to GMayor
Reply With Quote