Hi,
I have a query about creating a macro to move certain figures from one column to another.
Look down column F and G for negative value. If a negative value is found then I would like this to be moved into the opposite column as a positive and removed from the first column.
So, for example. If F6 was -100 then I would like G6 to be 100 and F6 to be made blank.
I would need this macro to run from Row 4 to the bottom of the data, which, I have declared a variable as lastrow.
Any ideas on this guys?
Thanks
Bookmarks