Macro to Loop Function throughout selected cells

Hi there,

This is my first time posting up on this site, I am very new to Macros and appreciate it if anyone could help me out with my situation.

Objective - Repeat my function for the following other rows

Function in hand:

Please Login or Register  to view this content.

Attached is an example of what it is I'm trying to do, as of now the function only works with the first row and once again I would like it to work for the rest. I need to repeat this for my original excel file which has 1000 rows.

Help.xlsm

Anyone and everyones help is greatly appreciated!

Alvinz

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

Thanks Arlette,

Will take note for future reference. Do you have any idea on my situation?

Thanks,

Alvin

Hi Blobbles,
I'm trying to remove errors made from users.
Without my current code, if changes where made to the drop down list in column B, no changes would be made to the drop down list in column A.
With the code, I am trying to ensure that if changes were made to column B, it will automatically take you two the corresponding drop down list in column A.

I would like this to work for all the following rows.
I hope I made my situation more clear, I'm struggling to explain as it is. haha.
I will try the code you have provided.

Thank you!

Hey Blobbles,
Thanks for all that. I understand what you're saying but unfortunately my manager is after something else.
If you have a look at my attached sheet, I have two dropdown list.
Users are not required to enter anything, only select from the lists provided.
For example:
1. Users will select "Meat" from the dropdown menu in Col B.
2. After that they will select the type of meat "Lamb" from dropdown menu in Col A.
3. If someone was to go back to the first row and select "Veg" in Col B, it will still appear as "Lamb" in Col A.
4. Hence the reason for the current code.

If you know how to apply that code to the rest of the required rows it would be most helpful.
I agree it is complicated and can be troublesome but I have to try to get it the way they want it.

Thanks. =)

Hey Blobbes,

Is there any reason why I can't download or see the attached file? :S
Thanks!