Macro to loop through a column

[excel77]

Please everyone,

I seriously need help on this!!!

I need a macro to loop through a column 'A' in the 'raw' worksheet and pick out each tag and paste it in the tag column 'A' of the 'done' worksheet.

For each tag, there are certain attributes such as BAO, SAO, HHALIM, HAL, in adjacent columns. Their values are in the cell next to them. In the 'done' worksheet they are all arranged out .

As the macro loops through the column A, for each tag pasted, it should pick out these attributes and pastes their values in under these attributes in the 'done' worksheet.

the workbook is attached.

Thank you very much for your help.

Excel

[Marcol]

I have looked at your sample workbook and I cannot see what you are trying to do.

Could you add a little more to the "done" sheet to help me understand your problem?

eg I cannot find DALOPT in "tags" sheet

[excel77]

Thanks,

I have transffered some data to the 'done' worksheet, and this is what the outcome of the final macro execution should be.

the 'tags' worksheet is not exhuastive for now, the data are more, thats why DALOPT is not there for now.

attached is the updated workbook

[JBeaucaire]

This should get you started, you can expand the search sections to include the sections which weren't represented in your data. I marked the columns already included in the code somewhere in dark green.

Please Login or Register  to view this content.

Just click the button on the "done" sheet.

[excel77]

Thanks, that really works.

Thanks very much.

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.