Hi Everyone,

Looking for a solution to an idea I have had about a macro on one of my worksheets.

In total I have 5 work sheets; 3 source sheets, 1 dashboard sheet and a Master data sheet. The 3 source sheets are just dumps of information from other sources, the Master sheet pulls all the relevant data from the 3 source sheets and the dashboard uses the data found on the master sheet and makes it look pretty for the managers. Data on the master sheet runs down columns per day, and is just sums and averages of what the different people have achieved over the course of that day.

At the top of the master sheet, I have frozen some cells and placed in a "Previous" day area, which is where the dashboard graphs and charts pull their information from.

What I would like, is for a Macro (or a function/formula if possible) to take the current date in Cell B3 and search down Column B for a match of that date and when found to copy everything from C*Matched row* to Y*Matched row* and paste it to C3 to Y3. Cell B3 contains a =Today()-1 formula so that yesterday's date is always displayed.

Thanks in advance.

I have done some light reading on Hlookup, Match and the index functions but I am unsure of how I would proceed or even begin using them.