Programmatically transfer data from master sheet to sub sheets with conditions

I love the solution….you are really an expert. Can you advise me any book for macros, which is easy to understand.

Hi Ashish, Is it possible to use Vlookup to match 2 colums in 1 sheet with 2 column in other sheet to get desired result.
Regards,
Manoj Singh

Hello, I have an excel file where I need to move data from one sheet to another. I have tried to adjust a workbook I found on your site but have not had any luck with it. Basically here is my issue.
In my Master sheet there are 7 columns:
A = ID
B = Type
C = Code
D = AMT (just a number with several decimal places)
E = AMTType (Money being Given back or Deducted) should contain -90 in cell
F = Check
G = Cost Center
I will populate the id number of an employee and upon typing it in the Cost Center will generate automatically… the rest of the data will be populated manually, but what I would like is to have a macro send the data to the sheets based on the cost center my issue is that the cost center will be like this (Saturn Company Inc) and the tab will only say Saturn or Flex Internal Inc and the tab will say FII… another thing is that it has to leave the data that is already in each tab … It should leave it as historical and only populate the new entries on each tab and delete the data from the master sheet once its is completely sorted out to each tab…

Hello Ashish thanks for the response… I get the following error when I update the Bridge sheet: “Unable to get the Match property of the WorksheetFunction class” and it highlights the following line: filter_criteria = Application.WorksheetFunction.Index(Worksheets(“Bridge”).Range(“A1:B” & bridge_rows), Application.WorksheetFunction.Match(Worksheets(n).Name, Worksheets(“Bridge”).Range(“B1:B” & bridge_rows), 0), 1) when I hover over the line it points to the “US_Semimonthly – STEL2> Stellar Salary Paygroup” Company Name in the Bridge sheet… Attached is the file…

http://1drv.ms/1mofD0K

Thank You

Hello Ashish to issues happen when I made those changes… data will not transfer from the Master sheet to the Saturn and Stellar sheets and it still clears the contents of Columns A:D when it should only clear A & D…

Hello Ashish,

I have a few issues concerning the file. I have 5 different Pay groups in the file. If I have a total of 8 employee belonging to 2 different pay groups, all tabs will populate with the same data as in my Master sheet with all 8 employees when ONLY the 2 Pay Group Tabs should be populated
New CSV files will be created for the 5 Pay Groups, when only 2 Files should be created.
I would also like to add is for the data in the master to be transferred to the historical tab before the master sheet is emptied. So if I run the report this week and only have 4 employees in the master those four should be put in the Historical and then every time I run it for the new employees to be added to the historical tab below the previous employees so we can keep a historical of employees there.

Hello. I am having trouble with the spreadsheet. When I click on a cell the formula shows: {=IF(ISERROR(INDEX(‘Main List’!$A$1:$F$45,SMALL(IF(‘Main List’!$F$1:$F$45=MID(CELL(“filename”,Q3),FIND(“]”,CELL(“filename”,Q3))+1,256),ROW(INDIRECT(“$1:$”&COUNTA(‘Main List’!$F$1:$F$45)))),ROW(3:3)),MATCH(C$1,’Main List’!$A$1:$F$1,0))),””,INDEX(‘Main List’!$A$1:$F$45,SMALL(IF(‘Main List’!$F$1:$F$45=MID(CELL(“filename”,Q3),FIND(“]”,CELL(“filename”,Q3))+1,256),ROW(INDIRECT(“$1:$”&COUNTA(‘Main List’!$F$1:$F$45)))),ROW(3:3)),MATCH(C$1,’Main List’!$A$1:$F$1,0)))}

but when I click into the formula, the {} disappears from the end and if I hit enter the values changes. Is there a step I am missing to make the formula run correctly?

dear sir;

I am from maintenance dept. there is 150 machine & history card of each machine need to maintain life long

I want such code/Formula that split my common data sheet(History Card) into respective machine (i.e. work sheet create for each machine) & same auto update when enter data in History Card sheet