AnsweredAssumed Answered

Merging recurring imported excel spreadsheets

Question asked by SeattleSquirrel on May 17, 2016
Latest reply on Aug 8, 2016 by beverly

Hi,

 

Here's what I have currently: Each employee has a personal excel timesheet that lives in my OneDrive. I've not to date found a good option for auto-merge of these timesheets (I'm on a Mac and excel is a bit more limited). I create summary pivot tables from everyone's timesheets to get dept status overview. Right now I wait until end of month, then copy every person's time entries into a master sheet, and then generate the summary. I would like this info to be up to date daily but it would require a lot more work on my part - and time is not of abundance.

 

Here's what I would like to do: I want to set up filemaker to do recurring imports of this data (click of a button!) which it does beautifully. However, it imports each person's timesheet into its own table. Thus I still don't have one location where the data is merged/consolidated. Is there a way for me to create a merged table that continues to be dynamic when I import new data?

 

Grateful for help!!

Outcomes