Need help on VBA code

V

Venkatesh1414

New Member
Joined
May 25, 2022
Messages
7
Office Version
  1. 365
Platform
  1. Windows
i had 5 different users workbook (Each workbook contains 2 sheets, sheet1(CU), Sheet 2(Source)) in documents folder.
Sheet1 (CU) consist of 5 columns which are Date, Start time, End time, User Name and Remarks starting from column A to E.

And i had 1 consolidated Workbook with 2 sheets(Sheet1(CU), sheet 2(Source)).

I am trying to get the data from 5 different users workbook Sheet1(CU), to Consolidate workbook Sheet1(CU) one below to another basing on Date criteria(E.g., from 01/01/2023 to 01/15/2023), but it no works to me.

Can anyone help me on this.

sincerely thanks,
Nani.
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
You must log in or register to reply here.

Similar threads

S
  • Solved
Hyperlink point to specific cell in another sheet
Replies
2
Views
127
Schturman
S
F
  • Question Question
Multiple workbooks with multiple sheets in each
Replies
1
Views
309
alansidman
A
T
  • Question Question
Printing to PDF use VBA - Was working but now different sheets are different widths
Replies
1
Views
205
Tanquen
T
I
  • Question Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
929
Insurance Dave
I
K
  • Question Question
VBA codes to replace all cells containing a certain value
Replies
2
Views
415
Snakehips
Snakehips

Forum statistics

Threads
1,223,891
Messages
6,175,229
Members
452,621
Latest member
Laura_PinksBTHFT

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