How to take Screenshot of a month data present in excel

Help
,
1

I have excel data which is grouped based on months, I want a saperate screenshot for every month data and paste it in saperate sheet. Also the records may increase in future for any month . Can anyone help me in developing code for taking screenshot of the particular area of excel(Which covers the complete records of a month). thank you

3

image
image424×695 8.57 KB
, please find the sample data in the attached image.

4

filter the date column by individual month then use take screenshot

5

i need only one month data in the screenshot but in the second screenshot iam getting the first month data as well.

6

The original data can be filtered…

  1. Read the whole data
  2. Apply filter on the data such as November, December, and etc.
  3. Paste the data in a different sheets and use that data as per requirement

Hope this helps!!!

1 Like
7

Yes , but my date column will be in “dd/mm/yyyy” . Thats what making a challenge here iam unable to filter the column as the dates of nov would be from “01-11-2020” “30-11-2020”

8

Pardon for the delay in response!!!

You can filter the DT using the filter like “-11-” for November month
, “-01-” for January.