kelly mort
Well-known Member
- Joined
- Apr 10, 2017
- Messages
- 2,169
- Office Version
- 2016
- Platform
- Windows
From the image below, I want to achieve any of the filtered data at the right depending on which month I reference.
I am thinking of copying all data for 1s under the column C (month)
Then I delete all date rows (from col A) from the copied data.
After that, I will also delete all DAILY TOTALS rows (Under col A) from the copied data.
Once I am done with the above deletions, my copied data should contain just the items or products.
My next move would be to remove duplicates so that no item appears more than once in the copied data.
From here, using a sumif function against the range the data was copied from used get me result.
But my issue here is that I don't know how to start writing the script to point me to the right direction.
Can someone please help me out? I have tried all what I can but I can't seem to figure out the way out yet.
Ps: I want the output to be on a different sheet.
Thanks in advance.
I am thinking of copying all data for 1s under the column C (month)
Then I delete all date rows (from col A) from the copied data.
After that, I will also delete all DAILY TOTALS rows (Under col A) from the copied data.
Once I am done with the above deletions, my copied data should contain just the items or products.
My next move would be to remove duplicates so that no item appears more than once in the copied data.
From here, using a sumif function against the range the data was copied from used get me result.
But my issue here is that I don't know how to start writing the script to point me to the right direction.
Can someone please help me out? I have tried all what I can but I can't seem to figure out the way out yet.
Ps: I want the output to be on a different sheet.
Thanks in advance.