Ask Experts Questions for FREE Help !
Ask
    hyun7447's Avatar
    hyun7447 Posts: 2, Reputation: 1
    New Member
     
    #1

    Sep 11, 2010, 11:26 AM
    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.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    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.

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

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to inetrchange 2 separate phone lines with 2 separate jacks? [ 1 Answers ]

I have 2 separate jacks for 2 lines, Line 1 is Primary and Line 2 is the second line. I want to make Line 2 as my Primary meaning switch those 2 lines, how can I do that?

How to wire 3 separate lights to 3 separate switches in series circuit [ 1 Answers ]

I am running wire from the circuit panel to the ceiling in the kitchen, then to a switch, back to the kitchen ceiling light. I am using the same circuit to the same thing for the dining room light with a switch, and a light on my deck also with its own switch. The switch in the dining room and the...

How to retrive all related data from different sheets according to the user's input? [ 10 Answers ]

Hi there, I want to connect two different excel sheet in the manner as follows: Consider I'm using sheet1 with fields like prod_id & prod_name with their data (1,2,3,4,5) and (a,b,c,d,e) respectively. Now if I enter the prod_id as 3 in sheet2, then I need all the other fields related to...


View more questions Search