Re: Pulling various data from different spreadsheets

Hi All,

Happy New Year!

I need to create a timesheet document that has a master document and then subsequent weekly timesheet spreads added to it.

Every Job has a code and total hours for that week next to it. I need the master document to take the code and add it if it doesn't already exist and then go on to find that code in any future spreads and tally the hours. Is this possible?

Thanks

MattLondon studio hours_Template.xlsx

Hi Mattcass87,
Yes, it can be done. Can you post any example in the excel file you send (e.g. put some name, jobs, and some weeks)?
However, I suggest instead of making multiple sheets, you can merge it into one sheet with the Week in the first column. that will be much easier/lighter way to control the file over time

Thanks tranhaithang.

Please find updated example attached.

Thanks

Mattexample3.xlsx

Hi Mattcass,
First, I'm still struggling with how to create a formula for unique list from across sheet (it works for one sheets, but couldnt make it through multi sheet).
So a work around is to copy all jobs from across sheet and use function 'remove duplication' in Data tab; then pasted it into the Master hours.

Second, after you get that, when you include new sheet, include new sheet name in column K of Masterhout; hit F2 in cell D4 to extend formula to cover the new sheet name

That's the way you do if you consist on multisheet approach

However, I do make another version with only one sheet; see in example 4. you can lay down data week after week then it's done easier in sheet Master hours

Consider the second approach, easier for you to handle over time

If it solved your issues, please tick add reputation to me

Regards,
Thang Tran