Hi
I have a spread sheet with data in column D (reference) and column E (quantity).
These changes regularly.
I would like a macro that will populate the quantity column into a second spreadsheet that has a corresponding reference number. This has column G as reference and column H as quantity. Please see attached spreadsheet as it perhaps explain my problem better and it shows the expected results.
Could you please let me know how to achieve this with a macro?
Thanks
Hossein
Bookmarks