find function and relative reference

[griffobiffo]

Hi

I'm trying to do a macro, to select data in A1, find that value in another sheet, and use relative reference to copy relevant data to paste back in row A in original sheet, and then move onto A2 etc. I know how to write someting that will move down A until the data runs out, but I'm struggling on the contents of A1 remaining in the code - see below, 10125.

I need the code to select the contents of whatever the active cell is, not this fixed value.

Please Login or Register  to view this content.

Any ideas?

[griffobiffo]

Thought I'd clarify what I'm actually doing.

This is a report that is produced for the printer, and so the format is very unfriendly for data extraction. The doc is opened in Excel with dividers placed at relevant points, in "copy P150 here"

My idea was to take column A, copy to another sheet, sort, find the first non-numerical character and delete all those. Then, return to A1, copy the value there, and using relative reference, copy and paste the relevant data.

Then group by RFM and paste the transactions into the applicable RFM.

However, I'm stuck on the find function, as it is embedding the first value into the code, instead of whatever that active cell happens to be.

Thanks

[davesexcel]

Hi

I'm trying to do a macro, to select data in A1, find that value in another sheet, and use relative reference to copy relevant data to paste back in row A in original sheet, and then move onto A2 etc. I know how to write someting that will move down A until the data runs out, but I'm struggling on the contents of A1 remaining in the code - see below, 10125.

I need the code to select the contents of whatever the active cell is, not this fixed value.

Please Login or Register  to view this content.

Any ideas?

here is an example of looping through a string in A1:A50, this example loops through a cell and changes numeric to ""

Please Login or Register  to view this content.