Information automatically updated

justahumbleassistant - Aug 11, 2016 at 02:02 PM
 Blocked Profile - Aug 11, 2016 at 04:52 PM

So I am creating a file for my boss on excel 2016 that I want to automatically update information from one table to the other without me having to re put it in. On one workbook, I have all of the agent sales for the year separated out by month and transactions within that month. I want to have another workbook of just numbers that takes the sales from those certain months to automatically add up after filling it in on the other workbook.
I can't seem to get a formula or link workbooks together to do it the way I want. Any help?

1 response

Blocked Profile
Aug 11, 2016 at 04:52 PM
Are you gonna tell your boss that we provided the answer?

Post some code, and we can help. We cannot provide you a turn key solution. You have left too many variables out. Post a pic of the sheet that you have started so we have an idea of what the sheet structure is.