MTD Data tab

[Melody J]

Hi, I have a spreadsheet in which I post daily data for up to 50 employees. I have a Macro that combines the data from 2 tabs into 1 sheet and creates a copy of it. I save that copy with the day. I want to create a MTD sheet that will sum up all of the fields from the daily tabs that are created. The problem I am having is that all formulas want the names of the tabs ahead of time but mine are created as I post the daily numbers. Is this something that can be done with a Macro or would it be better to manually do it?

Thank you,

 

[alansidman]

Suggest you keep all files relating to a particular month in one sub folder. Load the files from the one folder into Power Query and append them to make one file. Then pivot the data and have it sum the needed fields by date.

https://www.youtube.com/watch?v=a7E29H5ZUmE

 

[Melody J]

Suggest you keep all files relating to a particular month in one sub folder. Load the files from the one folder into Power Query and append them to make one file. Then pivot the data and have it sum the needed fields by date.

https://www.youtube.com/watch?v=a7E29H5ZUmE

I tried to do this and it does work but is not very easy to do with the amount of fields I have. I was hoping there was VBA or something that would sum the numbers from each individual tab when the daily tabs are created.

Thank you

 

[alansidman]

Without seeing your data (or sample) and your expected results (manually mocked up) it is difficult to even suggest any VBA.