Jyotirmaya
Board Regular
- Joined
- Dec 2, 2015
- Messages
- 204
- Office Version
- 2019
- Platform
- Windows
I have two sheets, "Raw Data" other one "SH"
I want a VBA code that if in the Raw Data sheet AH column there will be some value then the following of Raw Data sheet will be copied to SH sheet. Means the Row will be copied. For example if there will be some value in AH3 of Raw Data then
B3 of Raw Data to C to SH Sheet
C3 of Raw Data to A to SH Sheet
D3of Raw Data to B to SH Sheet
M3 of Raw Data to D to SH Sheet
S3 of Raw Data to E to SH Sheet
Y3 of Raw Data to F to SH Sheet
Z3+AA3 of Raw Data to J to SH Sheet
AB3 of Raw Data to K to SH Sheet
AC3 of Raw Data to L to SH Sheet
AD3+AE3+AF3 of Raw Data to N to SH Sheet
AH3 of Raw Data to O to SH Sheet
Raw Data sheet starts from 3rd row onward & in SH sheet the data should be start copying from Row 4. I need to enter more than 2000 entries in the Raw Data sheet, but I want to copy the only rows where in the AH column of Raw Data sheet will have any value then only it will be copied in SH sheet row 4 onward.
I want a VBA code that if in the Raw Data sheet AH column there will be some value then the following of Raw Data sheet will be copied to SH sheet. Means the Row will be copied. For example if there will be some value in AH3 of Raw Data then
B3 of Raw Data to C to SH Sheet
C3 of Raw Data to A to SH Sheet
D3of Raw Data to B to SH Sheet
M3 of Raw Data to D to SH Sheet
S3 of Raw Data to E to SH Sheet
Y3 of Raw Data to F to SH Sheet
Z3+AA3 of Raw Data to J to SH Sheet
AB3 of Raw Data to K to SH Sheet
AC3 of Raw Data to L to SH Sheet
AD3+AE3+AF3 of Raw Data to N to SH Sheet
AH3 of Raw Data to O to SH Sheet
Raw Data sheet starts from 3rd row onward & in SH sheet the data should be start copying from Row 4. I need to enter more than 2000 entries in the Raw Data sheet, but I want to copy the only rows where in the AH column of Raw Data sheet will have any value then only it will be copied in SH sheet row 4 onward.
Last edited:
