On creating a loop

**joelhuang** · 11-21-2009, 02:18 AM

Dear All,

Firstly, thanks for this wonderful forum!

I am trying to create a macro that would perform the following in a loop, and would appreciate any help!

1) Copy a cell
2) Ctrl+ Pg Up to another sheet
3) Ctrl + F
4) Delete
5) Ctrl + V to paste info
6) Space + Shift to select the entire row
7) Delete
8) Go back to previous cell
9) Move downwards by one cell
10) Loop back to Step 1)

Currently, once I run the macro, it would always paste the info that was copied during the recording, even if I do a "delete" of the text in the 'find' dialog.

Is there a way to ensure it does a paste of text selected in Step 1), instead of finding the same info?

Also, how do I cause it to loop until it has reached the end of the list (or any other methods to cause it to stop, eg. ctrl + Break) ?

Current code:

Please Login or Register  to view this content.

Many thanks!

**davesexcel** · 11-21-2009, 02:40 AM

There should be an easier way to do this, is it possible for you to attach a sample workbook showing the original layout, then how you want the end result to be.

**joelhuang** · 11-21-2009, 03:11 AM

Hi, I have posted an example sheet

The "Original" contains some info that I would like to delete, if it is also found in the second worksheet; that is, the macro is to copy from the second sheet, and attempt to find it from "Original", and once found, it will delete that row.
Hope this clarifies

**davesexcel** · 11-21-2009, 10:59 AM

Try this , it would work for your example

Please Login or Register  to view this content.

**joelhuang** · 11-22-2009, 04:52 AM

Originally Posted by davesexcel

There should be an easier way to do this

u reminded me, a vlookup and deleting those that are a match; that would make things perfect and it is easier. sometimes, we look for the solution without thinking if this is the best solution.

you've solved my problem totally, thanks! :D