CODEWITHSUNDEEP
excel
Sam.Palf
Sam.Palf

Reputation: 39

EXCEL: Pull data from one sheet and display on another sheet depending on today()

I have a series of duplicate sheets inside an excel document called SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY and SATURDAY, with a master sheet called 'Dashboard', on the dashboard I want to display information from the weekdays depending on what date/day of the week it is.

can anyone help? I've got close with IF(OR but not quite there, not sure if I'm going about it the correct way, any help much appreciated!

Thanks,

Sam.

Upvotes: 0

Views: 626

Answers (1)

Victor Larsson
Victor Larsson

Reputation: 20

Hi ok so what you need to do is to is like this. (and I do agree with the other person that you should have all data in one tab reallY= Create a sheet called admin in admin a1->B5 write

A  B
2  Monday
3  Tuesday
4  Wednesday
5  Thursday
6  Friday
7  Saturday
1  Sunday

In any other cell - lets say D1 in that sheet please write 

=vlookup((weekday(today());a2:b8,2,false)

Now go to your "Dashboard tab"

in Cell L1 (or what cell you want to have the data in) you just write

=indirect(admin!D1&"!L1")

Upvotes: 0

Related Questions