View Single Post
  #3   Report Post  
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.