Delete Rows of Data in Given Date Range

[Nathan95]

Hey All I have created a userform where users need to input Start Date (tbstartdate), End Date (tbenddate) and employer number (tbPnumber), based on this user form I want the code to be able to remove/Delete all the rows of data from the table that is located in sheet "Mark Leave" that falls between the date range and matches the employer number that was inputted in the user form. The Employer number gets inputted in Column B and Date gets inputted in Column D in the "Mark Leave" sheet.

Any help will be greatly appreciated

 

[Nathan95]

Bump

 

[bebo021999]

Could you attach a screenshot/image or a mini sheet via XL2BB?

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

 

[Nathan95]

Please find attached

 

[bebo021999]

So much data so we can not input manually. Could you try again with XL2BB?

 

[Nathan95]

So much data so we can not input manually. Could you try again with XL2BB?

Hey I tried but for some reason it wouldnt let me upload a snapshot of the file.

 

[bebo021999]

You can try google drive. Delete all sensitive data.

 

[Nathan95]

You can try google drive. Delete all sensitive data.

Copy of Sick Leave Tracker V3.xlsm

Monthly Summary P Number,Name,Skill Sets,Working Days,Home Team,Jul,Jul,Jul,Jul,Jul,Jul,Jul,Jul,Jul 01-Jul,02-Jul,03-Jul,04-Jul,05-Jul,06-Jul,07-Jul,08-Jul,09-Jul Fri,Sat,Sun,Mon,Tue,Wed,Thu,Fri,Sat MKBS Payments Leave Capacity Hours,60,60,60,60,60,60,60,60,60 Manual Capacity Numbers Adjustment...

docs.google.com

 

[bebo021999]

I want the code to be able to remove/Delete all the rows of data from the table that is located in sheet "Mark Leave" that falls between the date range and matches the employer number that was inputted in the user form. The Employer number gets inputted in Column B and Date gets inputted in Column D in the "Mark Leave" sheet.

Any help will be greatly appreciated

In attachment, there nothing in sheet "Mark Leave"

 

[Nathan95]

In attachment, there nothing in sheet "Mark Leave"

Sorry can you please try this link

Copy of Sick Leave Tracker V3.xlsm

Monthly Summary P Number,Name,Skill Sets,Working Days,Home Team,Jul,Jul,Jul,Jul,Jul,Jul,Jul,Jul,Jul 01-Jul,02-Jul,03-Jul,04-Jul,05-Jul,06-Jul,07-Jul,08-Jul,09-Jul Fri,Sat,Sun,Mon,Tue,Wed,Thu,Fri,Sat MKBS Payments Leave Capacity Hours,60,60,60,60,60,60,60,60,60 Manual Capacity Numbers Adjustment...

docs.google.com