Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,560
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,560
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default 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 -


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Transfer information Aggie G Setting up and Configuration of Excel 15 April 26th 07 03:43 PM
How do I set up formula to copy format from one worksheet to anoth Sky New Users to Excel 1 November 21st 06 02:20 PM
how do I transfer information from one sheet to another? Dan B. Excel Discussion (Misc queries) 2 April 14th 06 01:33 PM
Is it possible to copy a header/footer from one worksheet to anoth DLC Excel Discussion (Misc queries) 1 September 28th 05 02:01 PM
transfer information from one worksheet to another using a butto. langus480 Excel Worksheet Functions 1 September 16th 05 07:28 PM


All times are GMT +1. The time now is 10:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"