Each cell clicked changes other cells' data

[Noxqss38242]

I have 12 months of data. Each month obviously data changes.
I want to click on cell Q2 and other cells P4:AB5 pull data stored on another tab for January numbers.
Click on R2, S2, T2, etc.. and the same cells P4:AB5 pull data stored on that other tab for February, March, April numbers, etc...

Any solution would be great!

 

[Larry Haydn]

Do you have anything in Q2,R2,S2,T2?
Or are they just empty cells?

To run a macro to pull data, you could do something like this:

1. In Cell Q2, enter the word JAN, in cell P2 enter the work FEB... etc for all the months.

2. Create a macro to pull data from specific tab and paste it to the desired location
Give each macro a meaningful name, such as GetJanData, GetFebData, etc

3. Insert a hyperlink in cell Q2, and link it to the macro GetJanData
Do the same for the other cells.

 

[Noxqss38242]

Found a solution without using macros. Just had to alter some data on the source so I could apply vlookup and fill from there. Thanks though!

 

[Larry Haydn]

Sometimes, simple solutions are the best.