Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Separate sheets by input (https://www.askmehelpdesk.com/showthread.php?t=506703)

  • Sep 11, 2010, 11:26 AM
    hyun7447
    Separate sheets by input
    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.
  • Sep 12, 2010, 03:17 PM
    JBeaucaire

    '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

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

    • All times are GMT -7. The time now is 03:20 AM.