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
filter the date column by individual month then use take screenshot
i need only one month data in the screenshot but in the second screenshot iam getting the first month data as well.
The original data can be filtered…
- Read the whole data
- Apply filter on the data such as November, December, and etc.
- Paste the data in a different sheets and use that data as per requirement
Hope this helps!!!
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”
Pardon for the delay in response!!!
You can filter the DT using the filter like “-11-” for November month
, “-01-” for January.