Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 19th 05, 11:26 AM
Alexandra
 
Posts: n/a
Default linking selected data between Excell sheets

Hi,
I have 1 Excel file, 2 Sheets.
Sheet A contains names, addresses, zip, etc and a column that has a value
("X").
Now I need to link some of the data that contains that "X" into sheet B.
... if there's an "X", then some of the info of that line should be found in
sheet B.

Q: how do I link only marked entries?
Q: how do I link only specific cells?

Thanx,
Alex.

  #2   Report Post  
Old May 19th 05, 11:52 AM
paul
 
Posts: n/a
Default

my way
I would introduce another column in sheet a that will show the data you want
when the value X is present and link that column back into sheet b
--
paul
remove nospam for email addy!



"Alexandra" wrote:

Hi,
I have 1 Excel file, 2 Sheets.
Sheet A contains names, addresses, zip, etc and a column that has a value
("X").
Now I need to link some of the data that contains that "X" into sheet B.
.. if there's an "X", then some of the info of that line should be found in
sheet B.

Q: how do I link only marked entries?
Q: how do I link only specific cells?

Thanx,
Alex.

  #3   Report Post  
Old May 19th 05, 11:57 AM
Alexandra
 
Posts: n/a
Default

Will not work, cause the selected data will then be connected to Map Point.
Only marked "X" entries will be used in the Map Point presentation, for
which I will need then the fields address, name, zip, etc.

a.

"paul" wrote:

my way
I would introduce another column in sheet a that will show the data you want
when the value X is present and link that column back into sheet b
--
paul
remove nospam for email addy!



"Alexandra" wrote:

Hi,
I have 1 Excel file, 2 Sheets.
Sheet A contains names, addresses, zip, etc and a column that has a value
("X").
Now I need to link some of the data that contains that "X" into sheet B.
.. if there's an "X", then some of the info of that line should be found in
sheet B.

Q: how do I link only marked entries?
Q: how do I link only specific cells?

Thanx,
Alex.

  #4   Report Post  
Old May 19th 05, 12:05 PM
paul
 
Posts: n/a
Default

sorry i assumed(always dangerous) that it was only a table of data
--
paul
remove nospam for email addy!



"Alexandra" wrote:

Will not work, cause the selected data will then be connected to Map Point.
Only marked "X" entries will be used in the Map Point presentation, for
which I will need then the fields address, name, zip, etc.

a.

"paul" wrote:

my way
I would introduce another column in sheet a that will show the data you want
when the value X is present and link that column back into sheet b
--
paul
remove nospam for email addy!



"Alexandra" wrote:

Hi,
I have 1 Excel file, 2 Sheets.
Sheet A contains names, addresses, zip, etc and a column that has a value
("X").
Now I need to link some of the data that contains that "X" into sheet B.
.. if there's an "X", then some of the info of that line should be found in
sheet B.

Q: how do I link only marked entries?
Q: how do I link only specific cells?

Thanx,
Alex.



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
Linking References from Multiple Sheets to One Summary Sheet Kim Setting up and Configuration of Excel 3 May 5th 05 04:56 PM
Summary of data from 20 sheets Allan Skyner Excel Discussion (Misc queries) 7 February 1st 05 04:13 PM
Multiple sheets selected twa14 Excel Discussion (Misc queries) 2 December 21st 04 11:15 AM
Linking 2 Excel Sheets, Anticipating Lines. Matthew Excel Worksheet Functions 1 December 17th 04 01:55 PM
Linking sheets to a summary sheet in workbook gambinijr Excel Discussion (Misc queries) 4 December 16th 04 08:13 PM


All times are GMT +1. The time now is 10:08 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017