Copy All Data For A Given Month Onto Another Sheet

[kelly mort]

Looking at the sheet below :

I want to copy all the data for January to a different sheet.
Let us say the sheet containing the data is Sheet1 and I want the result on Sheet2.

The month selection will come from a combobox selection where the months appear in the combobox as:
JAN
FEB
MAR
APR
MAY
JUN
etc.
So when I select say JAN from the combobox, then I want to copy all the data for JAN onto Sheet2.
And when I select FEB for example too, I want to copy all records for FEB onto Sheet2

 

[ranman256]

For computers, this a terrible way to store data. Tho it looks good for humans, data analysis (or transfer) is not possible in this layout.
At least, not without a lot of programming.

Now if all data in the worksheet only contains the 1 month, then you can just copy the tab.

 

[kelly mort]

For computers, this a terrible way to store data. Tho it looks good for humans, data analysis (or transfer) is not possible in this layout.
At least, not without a lot of programming.

Now if all data in the worksheet only contains the 1 month, then you can just copy the tab.

Okay thanks for the heads up.

Then I have to alter my layout and come again.

 

[kelly mort]

Hello @ranman256,

After several considerations, I decided to maintain my data layout but added a helping column which I think could help get what I want to achieve.

Altering the layout could give me more headaches than what I am facing at the moment.

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?

Ps: I want the output to be on a different sheet.

Thanks in advance.