Hello!
I am working on a program to create a time sheet for my company. I need to take the values from one excel sheet and compare it to the other formatted sheet, to create a time sheet. If the “Position ID” in both sheets match then I need to write the employees hours into a specific column in the formatted sheet. Could someone please advise in the steps for this? Thank you.
Hi,
Can you share specific input and expected output? It’s no problem if dummy data.
Regards,
Multiple Employee ID and total hours for the week on sheet 1.
Multiple (same as sheet 1 in different order) Employee ID’s and names on sheet 2.
If Employee ID matches Employee ID on sheet 2 then bot should write Employee’s hours in specific cell on sheet 2.
The bot needs to match the employee ID and then write the hours by the employee’s name and ID number on sheet 2.
Sheet 1 -
Sarah, #27272838 , 8.0 total hours
Samuel, #53636377, 7.5 total hours
Sheet 2 -
#53636377, _______ hours
#27272838, _______ hours
I need the bot to identify the ID number and know to write the hours associated. Thank you so much for your help!
Hi!
Unfortunately, I am having issues with the bot actually writing the hours in the column. The code will run with no errors but the “Hours” column on the timesheet completed is still left blank. Can you possibly think of any error I could be making? Thank you so much for your help.
HI,
Can you share your input as screenshot or file, if possible?
Regards,
I am unable to due to confidential info.
The bot I believe is running correctly, however, it is just not printing the hours in which column I need them.
I got it to work! Thank you so much for your help!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale
Anil_G
ppr
shyamala_shyamu
Josh_James
m-takeda1
Shahabaz
harshika.10732998
sharazkm32