Hi all,
Sorry to cover something that has probably been done multiple times and is probably quite basic, I have searched long and hard but when I search anything to do with dropdown lists, I get results of how to create them.
So... looking at the Sample attached, for this sample all data in cells are fixed numbers and references.
In the original file, all data in cells sheet2!H6:L22, sheet2!N6:R22, sheet2!T6:X22, etc, will be auto collated from other worksheets so that all 17 reports for all 5 samples are collated to one sheet. Sheet2 is setup to be the 'helper sheet'.
I am looking for a formula for sheet1!J4:N20 that when month in sheet1!M2 is selected it matches the month in sheet2 row 4 and returns the correct range of cells from sheet2?
So when...
sheet1!M2 = February it returns sheet2!H6:L22
sheet1!M2 = March it returns sheet2!N6:R22
sheet1!M2 = April it returns sheet2!T6:X22 ...etc
I'm open to achieving this by formula or VBA, I was only looking for a formula based answer in case I use this via the web version of Excel.
TIA
Bookmarks