I have two seperate files in excel and I need to keep both. One contains sheets that records the individual sales of each employee for all the time working in the company, the other one includes all the sales of the company (includes all employees) for each month, it has a tab for each month.
What I want to do is find a way that I will only have to input this information only once and it will update the other book automatically. Is this possible since it is in different excel books?
the common entries would be the date and the name of the employee, so maybe each time that a certain employee appears in the company book it will update each employees tab. I also do not know how to make sure that it will go to the specific month tab given the date. for example if the entry date is between 5/01/2013 and 5/31/2013 then it goes automatically to the may tab.
I do not know which would be easier to enter the data in the employees sheet and then have the company's overall sales sheet update automatically or the other way around.
any help, or links to other sources will be appreciated, thanks!
What I want to do is find a way that I will only have to input this information only once and it will update the other book automatically. Is this possible since it is in different excel books?
the common entries would be the date and the name of the employee, so maybe each time that a certain employee appears in the company book it will update each employees tab. I also do not know how to make sure that it will go to the specific month tab given the date. for example if the entry date is between 5/01/2013 and 5/31/2013 then it goes automatically to the may tab.
I do not know which would be easier to enter the data in the employees sheet and then have the company's overall sales sheet update automatically or the other way around.
any help, or links to other sources will be appreciated, thanks!