I am new to the forum. Please update me if I am unaware if my doubts are against the forum rules while trying to solve my query.
I have these 2 working sheets. Except cell D1 on Sheet Gross and cell A1 in Sheet Extract, the sheet is protected and hidden. I select the date in cell A1 Sheet Extract with a formula, to get the month from Sheet Gross I want to work. When I run the code, the code runs from cells from A1 to AE61. I want the code to select only the cells which have value in the first row and not blank. I need your expert advice to change the code. I want the code to select A1 till the end where the dates end. Different months have different number of days like 28, 29 , 30 and 31.