Sequential "If" Statements

[labelm]

I'm a bit stuck on some VBA code.

Sheet "Key" lists the elements that must be copied from "City1" into "Sheet1"

So far I have a macro that searches "City1" sheet for the first element in "Key" and returns that row into Sheet1.

I need the macro to repeat this process for the remaining elements in "Key" (there are 15 total)...any help would be much appreciated!

Here is the code I am using:

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[labelm]

Sincerest apologies, I will be sure to adhere to the rules in the future!

[stnkynts]

I think this is what you are wanting to do. It is a little hard to tell without an example workbook:

Please Login or Register  to view this content.

[labelm]

Hi, thank you! I have attached a copy of the worksheet, let me know if it is helpful.

[AB33]

Stnkynts' code works too. I will leave for Stnkynts to adjust his/her own code.

[labelm]

Thank you all both for the help - this is exactly what I was looking for!