Find a relative value in a table
fabem38
Posted messages
4
Status
Membre
-
eriiic Posted messages 24581 Registration date Status Contributeur Last intervention -
eriiic Posted messages 24581 Registration date Status Contributeur Last intervention -
Hello,
I have two pages
On "PAGE 1," A15 is an entry where I enter a date (format "dd/mm/yy")
I would like to create a macro (by clicking on a userform for example and it doesn’t matter...) that takes me to "PAGE 2" on the cell that contains the date knowing that "PAGE 2" is a reservation schedule for a chalet.
What is the code for this search?
Thank you very much in advance.
PS: my skills in VBA are very rudimentary...
I have two pages
On "PAGE 1," A15 is an entry where I enter a date (format "dd/mm/yy")
I would like to create a macro (by clicking on a userform for example and it doesn’t matter...) that takes me to "PAGE 2" on the cell that contains the date knowing that "PAGE 2" is a reservation schedule for a chalet.
What is the code for this search?
Thank you very much in advance.
PS: my skills in VBA are very rudimentary...
5 réponses
Hello via55,
In column A starting from A3 to A38: Monday, Tuesday, etc...
In column B starting from B5 to B35: 1,2,3,4,... etc
In C1:D1: "JANUARY"
In C2: "COTTAGE"
In D2: "CHALET"
In column E starting from E8 to E35: 1,2,3,4,... etc
In F1:G1: "FEBRUARY"
In F2: "COTTAGE"
In G2: "CHALET"
And so on, repeating the format for each month.
The difficulty lies initially in defining the search range based on A15 of page 1, then precisely locating the cell corresponding to the sought date.
There you go.
In column A starting from A3 to A38: Monday, Tuesday, etc...
In column B starting from B5 to B35: 1,2,3,4,... etc
In C1:D1: "JANUARY"
In C2: "COTTAGE"
In D2: "CHALET"
In column E starting from E8 to E35: 1,2,3,4,... etc
In F1:G1: "FEBRUARY"
In F2: "COTTAGE"
In G2: "CHALET"
And so on, repeating the format for each month.
The difficulty lies initially in defining the search range based on A15 of page 1, then precisely locating the cell corresponding to the sought date.
There you go.
What if you uploaded your file (reduced and anonymized)?
cjoint.com and paste the provided link here.
eric