Same Worksheet, want to transfer information from one tab to anoth
 

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.

Same Worksheet, want to transfer information from one tab to anoth
 

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.

Same Worksheet, want to transfer information from one tab toanoth
 

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 -