transfering data from one book to another, uptating automatically, combining data

[aaacccc]

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!

 

[MUKESHY12390]

hey.. it's seems we can do what u trying... but little confused about sheets and it's Tab

two seperate files in excel

1st one is :- individual sales of each employee
Question : it has any Tab .?

2nd one is :sales of the company (includes all employees)
this sheet has Tab like..(jan, Feb, Mar ......Dec)

And Don't worry about below part
for example if the entry date is between 5/01/2013 and 5/31/2013 then it goes automatically to the may tab.

 

[aaacccc]

yes MUKESHY12390, the first file has many tabs, one for each employee contining information about their individual sells

the other file has the overall sells of the company and also has several tabs, one for each month. each month has all the information for all sells made by all employes during that month

 

[MUKESHY12390]

Click ME transfering data

 

[aaacccc]

thank you mukeshy12390, for your help, I am trying to figure out what you have sent me, how do you make the code run though?

 

[aaacccc]

so this is what the columns for each month tab looks like

Date

employee

product

serial number

client

company

sales amount

<tbody>
</tbody>

and for each employee: Date employee product serial number client company sales amount 5/18/2013 MrB 5/20/2013 MrB 5/25/2013 MrB 5/25/2013 MrB 5/26/2013 MrB 6/26/2013 MrB 6/29/2013 MrB 7/18/2013 MrB 7/18/2013 MrB 7/18/2013 MrB 7/18/2013 MrB 7/18/2013 MrB 7/18/2013 MrB 7/18/2013 MrB 7/20/2013 MrB 6/20/3012 MrB <colgroup><col><col><col><col><col><col><col></colgroup><tbody> </tbody>

<colgroup><col span="8"></colgroup><tbody>
</tbody>

I want all the rows from MrB's sheet that belong to the month of may (5/#/2013) to copy into the May tab for the whole company

 

[aaacccc]

I really do not know how to run it, and I do not understand how codes work, so both books have the same code? where f i run the code from?

 

[MUKESHY12390]

hey aaacccc , I am trying to tell you ,same thing what you asking.


Your words .... "I want all the rows from MrB's sheet that belong to the month of may (5/#/2013) to copy into the May tab for the whole company"

Download File : Company_workbook.xlsm (38.4 KB)
Employees_sheet.xlsx (16.0 KB)

What you need to do Just Change One Line in CVR Marco i.e path (Employees sheet Path )
CVR() Marco available in Company_workbook.xlsm.

Company_workbook.xlsm sheet has two Macros
1)test
2)CVR

You Need to run only CVR Macros...

Click Here ....transfering data