M845_Buhasa_Sep’23_Timesheets.pdf_TimeSheet10.xlsx (9.1 KB)
I want to do Following
Read the data from Simple Fields sheet and write it into Output Excel
Read the data from EntryTimes Sheet of the same excel and split, transpose the data the write the data from J column of the output.
Append the next data below the complete data…
Will u plz help with the code…
Output looks like
Output.xlsx (10.9 KB)
Ajay_Mishra
(Ajay Mahendra Mishra)
April 10, 2024, 6:13pm
2
Hey @Omkar_Shete_CTR Provide a expected output file!
Regards,
Ajay Mishra
Given…
Output.xlsx (10.9 KB)
1 Like
Hello Ajay,
I have one input excel file and i have also share the expected output file… In the output file we need to append the data from Various input excel files… If Possible also try with VB Script…
1 Like
Ajay_Mishra
(Ajay Mahendra Mishra)
April 10, 2024, 6:49pm
5
Hey @Omkar_Shete_CTR
Please answer below mentioned question!
All the input Excel files will be in same folder?
Sheet names will be same for each files?
Each file will only contains 1 employee detail and a timing sheet?
Regards,
Ajay Mishra
All the input Excel files will be in same folder? YES
Sheet names will be same for each files? YES
Each file will only contains 1 employee detail and a timing sheet? YES
1 Like
Hi Ajay,
If you have a solution then plz tell…
Ajay_Mishra
(Ajay Mahendra Mishra)
April 11, 2024, 5:50am
8
Sure! @Omkar_Shete_CTR
I was busy with some work, I’m working on your query!
Sharing your solution soon!
Regards,
Ajay Mishra
Please take your time and if possible add the solution till today night…
@Anil_G and @Vinit_Mhatre If you r working on this please/?
@Yoichi Plz tell the solution…
Hi @Omkar_Shete_CTR ,
Find Attached Workflow as per your requirement, hope it helps you
Omkar Shete.zip (18.3 KB)
Regards,
Vinit Mhatre
1 Like
Thank you so much @Vinit_Mhatre .
But there is one issue… Since our company have protected view on Excel, We have to write data once… So plz modify the code and do all the tanspose part in datatable itself at the end only write the datatable to excel… Please make the changes and send the code … That will be the most helpful for me…
I am getting output without Header
PMC services for Buhasa Portfolio (PXB) Projects
Swaminathan Rajendran
Instrument & Control Engineer
9
WO # 500011022
Sep-23
ADNOC-GP-500011022-KBR-MMR-013-Rev.0
UAE SITE BASED
table
Date
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Day
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Normal
1
1
W
1
1
1
1
1
1
W
1
1
1
1
1
1
W
1
1
1
1
1
1
W
1
1
1
1
PH
1
PMC services for Buhasa Portfolio (PXB) Projects
Mohammad Amir Khan
HSE Engineer
9
WO # 500011022
Sep-23
ADNOC-GP-500011022-KBR-MMR-015-Rey.0
UAE SITE BASED
table
Date
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Day
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Normal
1
1
W
1
1
1
1
1
1
W
1
1
1
1
1
1
W
1
1
1
1
1
1
W
1
1
1
1
PH
1
PMC services for Buhasa Portfolio (PXB) Projects
Raveendra Kulkarni
HSE Engineer
9
WO # 500011022
Sep-23
ADNOC-GP-500011022-KBR-M M R-014-Rev.0
UAE SITE BASED
table
Date
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Day
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Normal
1
1
W
1
1
1
1
1
1
W
1
1
1
1
1
1
W
1
1
1
1
1
1
W
1
1
1
1
PH
1
PMC services for Buhasa Portfolio (PXB) Projects
Srinivas Ambadi
Senior Engineer-Piping
6
WO # 500011022
Sep-23
ADNOC-GP-500011022-KBR-MMR-011-Rev.0
UAE SITE BASED
table
Date
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Day
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Normal
1
1
W
1
1
1
1
1
1
W
1
1
1
1
1
1
W
1
1
1
1
1
1
W
1
1
1
1
PH
1
Ajay_Mishra
(Ajay Mahendra Mishra)
April 11, 2024, 6:43pm
15
Hey Great Work! @Vinit_Mhatre
You worked hard for the Solution! but it will be better if you just put one more post and explain each and every step how you achieved the solution.
It will be better for us to understand the logic!
I’m happy you got the solution @Omkar_Shete_CTR
Thanks,
Ajay Mishra
1 Like
Hi @Omkar_Shete_CTR ,
@Ajay_Mishra Thank you, noted will do this from next time
Could you share me your current output excel file and also expected output excel file?
Regards,
Vinit Mhatre
@Vinit_Mhatre I have generated Final_ Output file
Now i want the data in Expected_Output… I want to remove date and days rows from each person and also match the header and write the output… Plz help @Vinit_Mhatre Vinit
Expected_Output1.xlsx (11.8 KB)
Final_Output.xlsx (21.6 KB)
Input File:
M845_Buhasa_Oct’23_Timesheets.pdf_TimeSheet1.xlsx (12.1 KB)
system
(system)
Closed
April 15, 2024, 3:37am
18
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.