Self - populating date specific data to another sheet each day.

[Ladyjet86]

I've hit abrick wall in a spreadsheet that I am working on.

I am trying to get 1 spread sheet to read the data from a column from another sheet in the same workbook (in which the column heading is the dates of the whole month).

I need it to pull new data every day as the date changes.

The data is to stay the same and in the same order just re-populate to the next columns data each day on the other sheet.

Any and all help is most appreciated. (not sure how to upload images)

 

[wigi]

Hello

This is the usual INDEX(MATCH( ) ) type of solution:
MATCH to find the correct column, INDEX to retrieve the data.
Or you could go for an easier solution using HLOOKUP.