Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Its a little difficult to explain but I am trying to take information from 1
tab and have it appear in another tab after it is typed in. The first tab has 4 lists on it and each is a different zone. I want to be able to transfer that information into a consolidated list that has all the zones on them. Looks like this. tab 1(Red) WO# Reel# AVG STD Length Zone This tab has 4 of these sets to separate the information into the 4 zones. Tab 2(AllRed) Looks exactly the same but only one set and I would like to take the information in the first tab from all 4 zones and put them into one list. I apologize that this is vague but this is the best way to describe it. Basically I want to be able to type the information once and have it transfer over to the ALL list instead of copy and pasting it. Thank you for time. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Can anyone help me? Experts? If im vague im sorry but this is the best i
could write up. If this even possible any advice would help. "David" wrote: Its a little difficult to explain but I am trying to take information from 1 tab and have it appear in another tab after it is typed in. The first tab has 4 lists on it and each is a different zone. I want to be able to transfer that information into a consolidated list that has all the zones on them. Looks like this. tab 1(Red) WO# Reel# AVG STD Length Zone This tab has 4 of these sets to separate the information into the 4 zones. Tab 2(AllRed) Looks exactly the same but only one set and I would like to take the information in the first tab from all 4 zones and put them into one list. I apologize that this is vague but this is the best way to describe it. Basically I want to be able to type the information once and have it transfer over to the ALL list instead of copy and pasting it. Thank you for time. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Your description is vague, and that probably accounts for the lack of
responses - please try to be more fulsome in your descriptions, and then if people can make sense of what you write they'll be better able to advise you. Pete On Jan 29, 7:24*pm, David wrote: Can anyone help me? *Experts? *If im vague im sorry but this is the best i could write up. *If this even possible any advice would help. "David" wrote: Its a little difficult to explain but I am trying to take information from 1 tab and have it appear in another tab after it is typed in. The first tab has 4 lists on it and each is a different zone. *I want to be able to transfer that information into a consolidated list that has all the zones on them. Looks like this. tab 1(Red) WO# * * * *Reel# * * *AVG * * * * STD * * * *Length * * * Zone This tab has 4 of these sets to separate the information into the 4 zones. Tab 2(AllRed) Looks exactly the same but only one set and I would like to take the information in the first tab from all 4 zones and put them into one list.. *I apologize that this is vague but this is the best way to describe it. * Basically I want to be able to type the information once and have it transfer over to the ALL list instead of copy and pasting it. *Thank you for time.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Transfer information | Setting up and Configuration of Excel | |||
How do I set up formula to copy format from one worksheet to anoth | New Users to Excel | |||
how do I transfer information from one sheet to another? | Excel Discussion (Misc queries) | |||
Is it possible to copy a header/footer from one worksheet to anoth | Excel Discussion (Misc queries) | |||
transfer information from one worksheet to another using a butto. | Excel Worksheet Functions |