Hi,
In column A on Sheet 1 I have some different measurepoints. Beside each one I have the value of the measurement. I need help to a macro that can find the first "P1" in column A and then copy the value from the cell in column B and paste it into column A on sheet 2. After that it have to find the next "P1" and then do the same thing. I can have up to 50000 of "P1".
In the attach dokument you can see what result I'm looking for. I have showed it with the "P2".
Thank in advance
Alring
Last edited by Alring; 08-22-2013 at 04:46 AM.
Try:
Please Login or Register to view this content.
Hi millz
Thank you for the help. It works perfect.
Hi Alring, yes it works fine in the test workbook, but I just spotted a mistake myself. This should fix it.
add this:
above here:Please Login or Register to view this content.
so it looks like this:Please Login or Register to view this content.
Please Login or Register to view this content.
Hi millz
It stills works perfect. I can't even see the different in the result with the change.
If it's working fine, no worries. You can edit your thread and mark it as solved. Anyway, if 'rowsskipped = 0' line wasn't there, the macro will sort of fail if you have more than 100 blank rows inbetween your data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks