Hi Team,
I need a urgent help with macro. I have attached a sample excel file here.
- I have two sheets "Mapping" and URLs
- These two sheets may have multiple rows. I guess, while creating a macro, it should count till end of rows.
- In sheet "Mapping", I need to copy content in "A2" and find it in Sheet "URLs" column "H" and replace the with the value of "B2" - (Mapping sheet)
- This need to repeat till all items completes in "Mapping" sheet.
I hope it is clear, if not I can clarify further.
I need a urgent help with macro. I have attached a sample excel file here.
- I have two sheets "Mapping" and URLs
- These two sheets may have multiple rows. I guess, while creating a macro, it should count till end of rows.
- In sheet "Mapping", I need to copy content in "A2" and find it in Sheet "URLs" column "H" and replace the with the value of "B2" - (Mapping sheet)
- This need to repeat till all items completes in "Mapping" sheet.
I hope it is clear, if not I can clarify further.