Log in

View Full Version : Separate sheets by input


hyun7447
Sep 11, 2010, 11:26 AM
I have a base data on sheet1 when I put in the data(item) on each row on sheet1 I need separate by destination (mexico=sheet2,china=sheet3, domestic=sheet4)on sheet2 ,sheet3 .sheet4 use same form and sheet5 ,sheet6,7... show only by different item name (not by destination) use same form... when I fill up sheet1 auto fill up separately each sheet 2,3,4,. and when I fill up sheet2,3,4.. Auto fill up sheet1 in excel... I need help please... English is my second language so I am not that good with it.

JBeaucaire
Sep 12, 2010, 03:17 PM
'SHEET1 TO MANY SHEETS
I have a macro that may be "ready to use" for parsing rows of data from one sheet to many sheets named for the same values.

Sheet1 to Many Sheets (https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/parse-functions/sheet1-to-sheets)

It not only can parse the rows, it can create the sheets if they are missing.