Good evening everyone.
I'm new here, so please assume I know nothing about VBA. I haven't used it in about 6 years am very rusty and I am having a really big trouble with this problem. Here is my data set before the copy and paste
I need a macro that will work its way through the dates to the end. Copying data from column H & I if its >1 and pasting it into column B. However, if for one specific date, like the 1Oct19 there is data in both columns H and I then I would like that pasted into two rows in column B. If the data is only in one column then only one date row is required for the data to be pasted in.
Another issue is that all data that is copied from Column H must be turned into a negative, Ie. the 23 will become -23 and so on, so that I can use the SUM function to get a running total. (no VBA required here)
Therefore, at the end of the exercise, I hope to have this (The red formatting in Columns B and C, represent negative values)
I hope that is a clear enough explanation of my issue. I really do hope for some help as I have been working on this all day and haven't got anywhere.
Thank you in advance for your assistance
Bluepinky
I'm new here, so please assume I know nothing about VBA. I haven't used it in about 6 years am very rusty and I am having a really big trouble with this problem. Here is my data set before the copy and paste
I need a macro that will work its way through the dates to the end. Copying data from column H & I if its >1 and pasting it into column B. However, if for one specific date, like the 1Oct19 there is data in both columns H and I then I would like that pasted into two rows in column B. If the data is only in one column then only one date row is required for the data to be pasted in.
Another issue is that all data that is copied from Column H must be turned into a negative, Ie. the 23 will become -23 and so on, so that I can use the SUM function to get a running total. (no VBA required here)
Therefore, at the end of the exercise, I hope to have this (The red formatting in Columns B and C, represent negative values)
I hope that is a clear enough explanation of my issue. I really do hope for some help as I have been working on this all day and haven't got anywhere.
Thank you in advance for your assistance
Bluepinky