Akashwani
Well-known Member
- Joined
- Mar 14, 2009
- Messages
- 2,911
Good day MrExcelers!
I have been given a Workbook to "tidy up", it's been a long time and I'm seriously struggling, so here I am!
I have a Worksheet that I CANNOT alter the layout of and that is making it difficult to find a suitable VBA code to copy the key data from the Active sheet to a "DataHistory" sheet.
The criteria will be in Column AE (Rows 3-31) in the form of a number.
The Cells I want to copy will be in these Columns and in the following order...
AE, A, F, H, J, K, L, M, O, Q, S, U, W, Y, Z, AA, AC, AD
The Cells that meet the required Criteria need to be copied to the next empty row on Sheet "DataHistory"
Example...
If AE3, AE6, AE20, AE31 have a number in, then the relevant cells on those rows need to be copied to the next empty Row on Sheet "DataHistory". So, the Data from Row3 would be copied to the next empty Row, from Row6 to the next empty Row and so on.
I hope that is clear, but I have some doubts!
Thank you for looking at this and I await some positive replies.
Ak
I have been given a Workbook to "tidy up", it's been a long time and I'm seriously struggling, so here I am!
I have a Worksheet that I CANNOT alter the layout of and that is making it difficult to find a suitable VBA code to copy the key data from the Active sheet to a "DataHistory" sheet.
The criteria will be in Column AE (Rows 3-31) in the form of a number.
The Cells I want to copy will be in these Columns and in the following order...
AE, A, F, H, J, K, L, M, O, Q, S, U, W, Y, Z, AA, AC, AD
The Cells that meet the required Criteria need to be copied to the next empty row on Sheet "DataHistory"
Example...
If AE3, AE6, AE20, AE31 have a number in, then the relevant cells on those rows need to be copied to the next empty Row on Sheet "DataHistory". So, the Data from Row3 would be copied to the next empty Row, from Row6 to the next empty Row and so on.
I hope that is clear, but I have some doubts!
Thank you for looking at this and I await some positive replies.
Ak