copy values based on last month dates in a separate excel.

doctorneel

New Member
Joined
Sep 29, 2021
Messages
1
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2013
Hello Experts, I need some help.
I have an excel named INPUT , where tab TEST column A contains all date values for all dates of last 5 years until the current date and corresponding values in column D.
I have another excel named OUTPUT where in column A already the date values until last end of month dates are present and in column B corresponding values of INPUT excel column D values. when I run the program on first week of next month, it will append the dates and corresponding values of the last month( i.e. if I run the code on 05/10, it will copy only 01/09 to 30/09 date and values). Could you please help with a sample code.
INPUT Example:
1632928628512.png


OUTPUT BEFORE RUN

1632928962345.png

OUTPUT AFTER RUN suppose on 05/10
1632929134211.png
 

Attachments

  • 1632929075542.png
    1632929075542.png
    65.9 KB · Views: 3

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,386
Messages
5,769,788
Members
425,570
Latest member
sfoshay11

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top