VBA N00b -- Need Help

KSLaborRelations

New Member
Joined
Jan 2, 2021
Messages
4
Office Version
  1. 365
Platform
  1. Windows
Hello,

Hopefully I have come to the right location to obtain some excel assistance. I am completely new to VBA and macros. I have tried, without success, to establish a macro. I am trying to setup a macro that runs by looking at each row under column "I" to see if the date listed in the cell is older or past the current date of the macro being ran. If the date is past the current I want the macro to copy the entire row, paste it into a different sheet (same workbook) and then delete the row from the active worksheet.

My workbook is titled "Recall Database.xlsm" and it has 2 sheets. The first sheet where we keep the active data is titled "Active" and the sheet where I want the macro to paste too is titled "Purged". The title of the macro will be "RecallPurge"

Below is the top portion of the Active sheet, row 1 is headers. I want the macro, when ran, to look only look at the date listed in column "I" in all rows. Only this date, not others. If the date that is listed in the column I of that row is older or past the current date of when the macro is being ran, then I want the macro to copy the row, paste the row in the sheet titled "Purged" and then delete the row from the "Active" sheet.

Capture.PNG


Below is an example of a row (row 217) that would be copied, pasted into "Purged" and then removed/deleted from "Active"

Capture2.PNG


Can anyone assist me? I truly appreciate anyone taking the time to read this and will be forever grateful if anyone can assist me.
 

Attachments

  • Capture1.PNG
    Capture1.PNG
    26.5 KB · Views: 5

vcoolio

Well-known Member
Joined
Jun 29, 2014
Messages
1,037
You're welcome KSLR. I've been having trouble for quite some time receiving notifications from this forum so I've come back a little late but it appears that Michael sorted out the password issue for you.

Thanks Michael!

Cheerio,
vcoolio.
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

Michael M

Well-known Member
Joined
Oct 27, 2005
Messages
19,766
Office Version
  1. 2016
  2. 2013
  3. 2007
Platform
  1. Windows
You're welcome KSLR. I've been having trouble for quite some time receiving notifications from this forum so I've come back a little late but it appears that Michael sorted out the password issue for you.

Thanks Michael!

Cheerio,
vcoolio.
Glad we could help..🖒🖒
 

Watch MrExcel Video

Forum statistics

Threads
1,123,198
Messages
5,600,280
Members
414,374
Latest member
akbir

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