Dear Sir,
As per your advice, I tried fixing the problem and I am glad to tell you that I found the mistake but I don’t know how to fix it.
Up to Apartment 3 separate sheet macro is selecting all the data but in Apartment 4 sheet, while pressing f8 I came to know that macro select the range but it’s not dragging down that range up to last row to select all the data.
However, i can select manually to select all the data and then keep on pressing f8 it will fix but that’s, not a smart way I think.
I have attached 2 pictures .
- 1 for apartment 4 before macro drag down the range but it’s not
- And 2nd after macro drag down to only 1 row.
I will really appreciate your response, I hope there is a way to fix this.
Thanks and have a very nice day to you Sir.
Eng. Aurangzeb Khan