Any excel 2003/VBa expert?
I'm starting to make some macros on Excel at work, so this will be a very easy question: I would like to copy a cell (B6) that is on Sheet1 and copy it into Column A in Sheet2 and repeat this as long as there is data in colum E in Sheet2.
That means that if E31 is not empty in Sheet2, then copy Sheet1.B6. Same with E32, etc, and stop the copy at the first cell that is empty in columE.Sheet2.
I hope this is understandable. I apologize for not pasting the code I already set up, but I did this at work, and I'm home now.