I have a spreadsheet where the data gets imported from a productivity database report. Some days the information comes across in alignment and other days the report columns are out of alignment. I already have a macro that aligns the data on days where the report comes across out of alignment. I am now trying to have a macro created to do the following...
* Set the range as ("D3:D") and the last used row in Column C
* For each cell in Column D that is not blank...
1) Copy the value in cell B of that same row and paste the data into cell A of that same row.
2) Copy the value in cell D of that same row and paste the data into cell B of that same row.
* Once that loop is complete, I want to clear the contents in Column D
Example below.
Thank you
* Set the range as ("D3:D") and the last used row in Column C
* For each cell in Column D that is not blank...
1) Copy the value in cell B of that same row and paste the data into cell A of that same row.
2) Copy the value in cell D of that same row and paste the data into cell B of that same row.
* Once that loop is complete, I want to clear the contents in Column D
Example below.
Thank you