Select range based on dates (collumns) and names (rows)

[louvaek]

Hi All,


I'm looking for a vba code to do following in the example sheet I attached:

- Inputbox to select the start date (col)
- Inputbox to select the end date (col)
- Inputbox to select the driver (row)

Nothing explains it better than an example from the worksheet:
I'd like to get following range selected: G9:I9.
This has to happen based on the input the user gives:
start date = 03/01/2020
end date = 07/01/2020
name = driver2

I hope I explained it well

[PCI]

See how next code can help

Please Login or Register  to view this content.

[louvaek]

That is brilliant, works like a charm !!!

Tyvm PCI !!!