Hi
I have worked out what I need to do, but really dont know how to do it.
In sheet 1 I have a ID number in Col A, I need a macro to pick up the ID number and run a vlookup in sheet 2 for the ID number (col A) and then pass the value in col D to a sting and then continue down the sheet for X rows concantenating all the values from col D (with the correct ID in col A) to the string. Once finished it would paste the string into sheet1 Col B and then pick up the next value in sheet 1 Col A and do the same until it reaches the bottom.
I know I am asking a lot, especially as I have no code to show where I am coming from but I cant find anything in google and I can record a macro and edit....
Thanks
Bookmarks