OK - You Excel Whizzes... I need your assistance.
I have 2 separate Worksheets within 1 file.
Worksheet 1 has raw data with 3 cells.
Worksheet 2 has this same data as these 3 cells in Worksheet 1 (via links)
Worksheet 1 is updated daily with different data in these same 3 cells.
I want Worksheet 2 to retain the previous 3 cells of data (from yesterday) and include today's new data of 3 cells in a new set of cells.
I want Worksheet to retain all daily data as time goes by.
How do I achieve this task?