filter multiple columns base on cell date value

A

asyamonique

Well-known Member
Joined
Jan 29, 2008
Messages
1,280
Office Version
  1. 2013
Platform
  1. Windows
Hello,
I have datas all the way down on worksheet1 column A:G as given info below.
ColumnA has Dates,
ColumnB has Names,
ColumnC has Time In
ColumnD has Time Out
ColumnE has Time In2
ColumnF has Time Out2
ColumnG has Total Hours

Is it possible filter those datas from A5 and all the way down for one week only base on two cells text on worksheet2 with a vba code?
Cell B1 I will enter date
Cell B2 I will enter Names
When I click the button I want from A5 to all the way down one week data will load which including B1 dates,
Many Thanks


Date:14-Feb-2022
Name and Surname:Name and Surname
DateName and SurnameTime InTime OutTime In 2Time Out 2Tot.hrs.
14-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
14-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
14-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
15-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
16-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
16-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
16-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
16-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
16-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
17-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
17-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
17-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
17-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
17-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
17-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
18-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
18-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
18-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
18-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
18-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
18-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
18-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
18-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
19-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
19-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
19-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
19-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
20-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
20-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
20-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
20-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
20-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
20-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
Sort by date Sort by votes
asyamonique said:
Hello,
I have datas all the way down on worksheet1 column A:G as given info below.
ColumnA has Dates,
ColumnB has Names,
ColumnC has Time In
ColumnD has Time Out
ColumnE has Time In2
ColumnF has Time Out2
ColumnG has Total Hours

Is it possible filter those datas from A5 and all the way down for one week only base on two cells text on worksheet2 with a vba code?
Cell B1 I will enter date
Cell B2 I will enter Names
When I click the button I want from A5 to all the way down one week data will load which including B1 dates,
Many Thanks


Date:14-Feb-2022
Name and Surname:Name and Surname
DateName and SurnameTime InTime OutTime In 2Time Out 2Tot.hrs.
14-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
14-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
14-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
15-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
16-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
16-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
16-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
16-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
16-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
17-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
17-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
17-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
17-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
17-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
17-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
18-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
18-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
18-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
18-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
18-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
18-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
18-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
18-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
19-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
19-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
19-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
19-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
20-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
20-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
20-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
20-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
20-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
20-Feb-2022NamesTime InTime OutTime In 2Time Out 2Tot.hrs.
Click to expand...
bump
 
Upvote 0
Lots of data that helpers dont have time to re-type into worksheet.
Try to upload a mini sheet, using XL2BB tool
www.mrexcel.com

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 www.mrexcel.com
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Solved
Formula sum if for tot time calculation.
Replies
6
Views
251
Dave Patton
D
M
  • Solved
VBA Copy & Paste Values onto itself based on Criteria
Replies
4
Views
236
mst3kr
M
B
  • Question
countifs and remove data completed
2
Replies
10
Views
386
MuchToLearn
M
E
  • Solved
Pivot Table Sorting Dates Out of Order
Replies
3
Views
743
awoohaw
awoohaw
JenniferMurphy
  • Solved
How to count events in a calendar year?
2
Replies
14
Views
327
JenniferMurphy
JenniferMurphy

Forum statistics

Threads
1,214,989
Messages
6,122,622
Members
449,093
Latest member
catterz66

Share this page

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
Back
Top