Excel Magic - Any Pros?

[Alpha-9]

Hi

I'm trying to make our work rota better.
I want to be able to do a few things to save a lot of time:

Return all cells that are highlighted yellow; these are manually entered 'vacant' slots, the name needs to stay in so we can see who's shift it originally was. It would need to return the column heading (the shift location and timings) and the row heading (the date)

Create a weekly schedule, an automated from the day its ran for 7 days (so 8 days Sunday-Sunday for example), copies in all the shifts from the different areas and timings in a readable easy to look at way. Maybe recording a macro will work but I'm not confident...

Something that looks across multiple sheets within the workbook and returns the names (column headings) of that date (defined by the row) and returns the cell of a specific type (text)

Make the workbook know what day it is today, so it borders or highlights the row of today's date on the rota (its a 4 month rota) but without ruining the colors of the slots

Hmm

Thinking about the template for the schedule, I could make it return the column easy enough, but it's the choosing the row cell that's today's day that baffles me hmmmmm
____________________
Fzr-600 1999

[lihp]

How much are you offering?

[Alpha-9]

Zilcho

I got somewhere with it

=VLOOKUP(B27,B4:F12,MATCH(C26,B3:F3,0),TRUE)

Oh baby
____________________
Fzr-600 1999

[Monkeypony]

You'll want to replace the 'true' with 'false'
____________________
Current bike - 2018 H2-SX, 2004 SV1000s, 2016 Aprilia RSV4 RF, 2017 Sherco SERF 300, 2003 Suzuki DRZ400 (stolen - AY53 JUU)

[Alpha-9]

[Ichy]

Function BGCol(MRow As Integer, MCol As Integer) As Long
BGCol = Cells(MRow, MCol).Interior.ColorIndex
End Function

VBA must be the easiest way to achieve what you want.
____________________
https://www.metacafe.com/watch/1972097/how_to_behave_on_a_forum/

[Pigeon]

[kawakid]

Post the spreadsheet.

I can have a quick look and give you a rough idea of how much time would be needed.
____________________
I've a twin and a 4.