Hello,
I am tasked by my organization to generate financial reports. The reports are generated as Daily, monthly, quarterly and yearly.
I want to know how do I make data synchronize across different files (all saved in C/User/Documents). Not one file with multiple sheets, but multiple files syncing with the Daily financial report.
For example, assume that I have completed financial report for 10 days starting from today, then the other monthly data file must synchronize the sum of the total amount in its own cells from the daily financial reports, and subsequently the quarterly from monthly and yearly from quarterly.
I can currently open multiple sheets in the same file, but that is really increasing the size of the file thus increasing loading times and being rejected by my organization. I simply cannot have all the months open in different sheets for the financial year 2023-24.
I would also like this to work with tempelates, so I do not have to make new sheets from scratch for each financial year, I can then just change dates.
Thank You.