Hello
Is there code/macro (I obviously have no idea about this) that would look at a datasheet by row and find the last cell in each row that has data in it and copy/paste that cell's data into column A.
For example if my data was something like the following image,
Initially, column A would be blank and then and if I ran such a magical macro, then it would look at each row starting with row 1 and paste the contents of E1 into the first column (A1)
Then it would look at the second row and paste the contents of G2 into cell A2.
Then it would look at the third row and paste the contents of C3 into cell A3
etc.....
You guys are amazing and I am hoping that you can help.
Thanks in advance!
Debbie
Is there code/macro (I obviously have no idea about this) that would look at a datasheet by row and find the last cell in each row that has data in it and copy/paste that cell's data into column A.
For example if my data was something like the following image,
Initially, column A would be blank and then and if I ran such a magical macro, then it would look at each row starting with row 1 and paste the contents of E1 into the first column (A1)
Then it would look at the second row and paste the contents of G2 into cell A2.
Then it would look at the third row and paste the contents of C3 into cell A3
etc.....
You guys are amazing and I am hoping that you can help.
Thanks in advance!
Debbie