EXCEL HELP?

[philbobag]

Hi eveyone,

so im stuck, basically what i want to be able to do is when i change the month in the top left hand corner, all the cells in the table change, so each month i can see the different data entries,

i have managed to do this with the dates so when i change the month/year the dates down the left hand side all change but im stuck on how to also change the entire table so i can see different data entries.

 

[SanjayGMusafir]

The way you have hidden all the information how shall we know what exactly you want in those columns?

 

[philbobag]

The way you have hidden all the information how shall we know what exactly you want in those columns?

its irrelevant that's the reason its not visible, the blank cells next to the dates are the ones that eventually are going to be full of data, that's what i am wanting to change

 

[SanjayGMusafir]

got some clarity. Now the question is - the data you want to be in those columns would be somewhere else in the excel sheet/workbook and you want to pull pull that data here as per the month above or date of the row. Right?

 

[philbobag]

well the idea i had was like the image below, so every time i changed the month the data would change relating to what i had added that month?

Does that make sense?

so im in September below, if i went back a month to august the data would all change relating to what i had added that month?

thats what im wanting to achieve

 

[SanjayGMusafir]

so every time i changed the month the data would change relating to what i had added that month

Honestly what you are PROBABLY trying to is create an input format and
What you want is that Excel should store that data and retrieve it as per the month (input) you give in a cell say A1

What you need to understand is - the feature you want to use is used to retrieve an already save data in a particular format or what is called data Analysis.

Retrieving the way you want is not possible unless you have some database at the back to process.

Hope I'm able to make the point clear.