matchup macro formula

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

Please Login or Register  to view this content.

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