wfsteadman
New Member
- Joined
- Dec 28, 2016
- Messages
- 15
Greetings folks,
I saw a solution somewhere but I can't find it. I have a column that can be a dynamic length and in the column there could be blank cells
so for example:
Cells A1:A10 could have contents
Cell A11 could be emptry
Cell A12:A15 could have contents
Cell A16:A18 could be empty
Cells A:19:A100 could have contents so I am trying to get it to select cell A101 if that makes sense.
The objective is that I will copy some ranges from different worksheets and will have them pasted into another worksheet (say sheet 9) one after the other. So Sheet 1 I might copy A1;A100 (Keeping the blanks cells that are in the column from example above) then Sheet 2 Copy A1:A150 so on the sheet where they copy to, the contents from sheet 1 will be pasted starting at cell A1 on sheet9 which would mean when sheet 2 is pasted it would start at cell A101 on sheet9 etc....
Any assistance would be appreciated.
Thanks
Wally
I saw a solution somewhere but I can't find it. I have a column that can be a dynamic length and in the column there could be blank cells
so for example:
Cells A1:A10 could have contents
Cell A11 could be emptry
Cell A12:A15 could have contents
Cell A16:A18 could be empty
Cells A:19:A100 could have contents so I am trying to get it to select cell A101 if that makes sense.
The objective is that I will copy some ranges from different worksheets and will have them pasted into another worksheet (say sheet 9) one after the other. So Sheet 1 I might copy A1;A100 (Keeping the blanks cells that are in the column from example above) then Sheet 2 Copy A1:A150 so on the sheet where they copy to, the contents from sheet 1 will be pasted starting at cell A1 on sheet9 which would mean when sheet 2 is pasted it would start at cell A101 on sheet9 etc....
Any assistance would be appreciated.
Thanks
Wally
Last edited: