I have the workings of a macro which has worked for some parts of the code. But when I try to look at "Sheet2" to find a source of data using "ActiveCell" I wear egg on my face. Can any one help me.
The attached file shows my workings at this time.
I would like to run the the macro and select a range of cells in sheet2 then look at sheet1 and copy some of the columns of data back to sheet2. Then repeat the process until all the selection has been completed or an empty cell or can not find data occurence where the message Box appears revealing problem.