Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking References from Multiple Sheets to One Summary Sheet | Setting up and Configuration of Excel | |||
Summary of data from 20 sheets | Excel Discussion (Misc queries) | |||
Multiple sheets selected | Excel Discussion (Misc queries) | |||
Linking 2 Excel Sheets, Anticipating Lines. | Excel Worksheet Functions | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) |