View Single Post
 
Old 01-14-2020, 01:42 AM
Nurul Nurul is offline Windows 8 Office 2010
Novice
 
Join Date: Jan 2020
Location: Singapore
Posts: 1
Nurul is on a distinguished road
Default How do i link a data from different sheet on a summary page automatically

Hi all,

I am trying to tabulate a report of my colleagues spending hours on completing a task on a daily basis.
With different accounts for different colleague on daily basis, how do i make it easy for the summary to capture the report without having to link it manually.

i tried index and match, but cant seem to have it auto.

thank you in advance
Attached Files
File Type: xlsx January 2020.xlsx (46.5 KB, 9 views)
Reply With Quote