Hi Team,
I'm looking for some help in copying some data from one sheet to another based on the condition of dates - I've attached an example worksheet
Basically what I'm looking to do is take the date value in Sheet2 - B3, search through Sheet1 - Column B until there is a match. When there is a match copy the values on the same line in Columns E&F into the relevant cells in Sheet 2.
Basically copy the Prices in USD and GBP from sheet 1 to sheet 2 where the dates line up!
Sorry if my explanation is either long-winded or just rubbish!!
Thanks in advance,
- Jon
Bookmarks