Can anyone please help me with Excel. I have 7 spreadsheets (1 per day of week)I also have another main sheet which I want to display data from just one of the days sheets but the selection of the day sheet data to display to be dependent upon the date or day entered into the title of my main sheet. Sounds a bit long winded but basically if I enter Monday on my main sheet I want to display the relevant data from cells on the Monday's sheet.
I presume VBA is required but haven't used it for many years and only then using guidance from a book for some minor stuff.
I presume VBA is required but haven't used it for many years and only then using guidance from a book for some minor stuff.