Venkatesh1414
New Member
- Joined
- May 25, 2022
- Messages
- 7
- Office Version
- 365
- Platform
- 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.
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.
