G
greegan
Sheet 1 has the data
consisting of a code, account,distribution center, sub total, total (columns
A-D, respectively)
In the pivot table we have it using sum to find totals of similar
distribution centers. The account number is repetitive in the data sheet so
it does not appear in the PT
I need to do the same with each row, which is:
if column C is <> 0 when rounded to 2 decimal places OR if column D is <>
0 when rounded to 2 decimal places, then copy the row to a temporary
array(is this possible)
Once all rows are checked, copy temp array to a specific worksheet.
I am told this is the place to find answers like this. Can this be done?
I have tried doing this on my own and have been unsuccessful to this point.
If someone pulls this off, would you mind helping me understand how you got
to said macro? I want to learn how to do this.
Thank you,
- g
consisting of a code, account,distribution center, sub total, total (columns
A-D, respectively)
In the pivot table we have it using sum to find totals of similar
distribution centers. The account number is repetitive in the data sheet so
it does not appear in the PT
I need to do the same with each row, which is:
if column C is <> 0 when rounded to 2 decimal places OR if column D is <>
0 when rounded to 2 decimal places, then copy the row to a temporary
array(is this possible)
Once all rows are checked, copy temp array to a specific worksheet.
I am told this is the place to find answers like this. Can this be done?
I have tried doing this on my own and have been unsuccessful to this point.
If someone pulls this off, would you mind helping me understand how you got
to said macro? I want to learn how to do this.
Thank you,
- g