I require a macro, which will copy rows (highlighted in green) in worksheet named LIVE VWAP (Rows 35 and 36), and paste into worksheet named Master Data. This should be done by looking up the date in worksheet LIVE VWAP (Cell A35) and pasting it into the rows of the same date (highlighted in red in row 42 in this example). Worksheet Master Data(2) shows the end results (highlighted in yellow in rows 42&43)
I have tried using Vlookups but cant seem to make it work.
Bookmarks