I come here to ask for help with a search in several tabs in Excel. The excel file attached has several tabs. From Tab Ano2019 to Ano2030 What I intend is:
In the Monthly Tab, in cell A2 and in cell A3 dates will be placed, in A2 I put (example, 01-03-2023 ) which is the first day of the intended month, and in A3 I put the end of the intended month, (example , 31-03-2023 ) and the VBA code should fetch the information from Tabs, Year2019, Year2020, Year2021, Year2022, Year2023, Year2024, Year2025 to Tab Year2030.
The data must go to the Monthly Tab from cell B7 to J41, and must have the name of the Tab, the person's No., the person's name, the services, the Shifts, the Date to be enjoyed and the Period of the day to be enjoyed , referring to the month I chose from all the people who took it in that same month and in order of date (in ascending order).
I already put a month as an example to see what I intend.
When I say that it is to put the beginning of the month in A2 and the end of the month in A3, it can also be in cell A2 if I put March 2023 and the VBA code does the same function, or another function that does what I want, what what matters is that the final result is the same as that found in the Monthly Tab. I also intend that, as soon as the first date is placed in the Monthly Tab in cell A2, the entire area from B7 to J41 should be cleared. I hope I explained it well. Thanks in advance.