matchup macro formula

[monteiro1969]

hi, a while ago someone on this forum was kind enough to create a macro that has helped me a lot in my work (im enclosing the sheet with that macro) the idea was to match up the data from column D with the data from column B and move the data from column D to column C accordingly, that was great for a while, however now i need to kind of upgrade that macro, the idea is exactly the same however i now need the data from columns E F G H I J to follow the data from column D as shown in file formula.xls, i hope this is clear but if not please do let me know and ill try to explain better, many thanks in advance and i hope im not being to chicky in asking for help with this macro again.

regards

jorge monteiro

[Bob Phillips]

Please Login or Register  to view this content.

[monteiro1969]

Hi Bob,

thank you so much, i have tried it however it doesnt seam to be working 100% part of the data does appear to have moved correctly however the bottom half didnt work and it deleted the data from the first column, just a note on the data, it will be always different amount of rows, it can be 20 rows as it can be 200.

thanks again

jorge