In the summary sheet, when the month in the dropdown (A1) is changed, data would change also (from sched sheet). Lookup hopefully including how data is formatted.
Thank you.
In the summary sheet, when the month in the dropdown (A1) is changed, data would change also (from sched sheet). Lookup hopefully including how data is formatted.
Thank you.
Last edited by mia12; 10-01-2019 at 01:23 PM.
In B2, copied across and down:
=INDEX(INDEX(Sched!B:B,MATCH($A$1,Sched!$A:$A,0)+1):INDEX(Sched!B:B,MATCH($A$1,Sched!$A:$A,0)+18),ROWS($1:1),)&""
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Is there a way that it would also return how the cell is formatted, specifically with cell color?
you MIGHT be able to do it if you had applied the formatting as a result of a conditional formatting RULE. However, it seems to have been applied manually. To transfer that, you'd need VBA (if it's possible, but I'm sure it would be)... and I can't do VBA.
oh alright, thanks
Suggestion: open a new thread in VBA section, asking for formatting to be pasted over... If VBA is allowed...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks