Hi I'm currently using excel files and pivot table to perform budgeting at my company.
I receive many files from different departments and compile them in one worksheet. Problem is that when i get a new file replacing data is cumbersome. I think it would be easier to import the files to access and then combine back into excel.
Any thoughts on how to accomplish would be appreciated.