| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding Contents of a Specific Cell (Address) out of 1000's of Add
I have a spreadsheet with 1000's of addresses, I am specifically looking for
one address to connect to another spreadsheet. How can I minimize time searching/finding "one" specific cell? How can I connect two spreadsheets? -- JOE :) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding Contents of a Specific Cell (Address) out of 1000's of Add
You could probably use the vlookup formula, but you have provided so little
detail about the structure of your spreadsheets. Tom "JOE" wrote: I have a spreadsheet with 1000's of addresses, I am specifically looking for one address to connect to another spreadsheet. How can I minimize time searching/finding "one" specific cell? How can I connect two spreadsheets? -- JOE :) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding Contents of a Specific Cell (Address) out of 1000's of Add
Possibly use VLOOKUP
"JOE" wrote: I have a spreadsheet with 1000's of addresses, I am specifically looking for one address to connect to another spreadsheet. How can I minimize time searching/finding "one" specific cell? How can I connect two spreadsheets? -- JOE :) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Finding Contents of a Specific Cell (Address) out of 1000's of Add
Hi,
1. Sort the addresses that will make your search much faster 2. or select the addresses and choose Data, Filter, AutoFilter and pick the address from the sorted list or unique addresses. 3. You can connect to sheets in 1000's of ways it all depends on what you want to do. Once you've found it what do you want to do with it? If this helps, please click the Yes button Cheers, Shane Devenshire "JOE" wrote: I have a spreadsheet with 1000's of addresses, I am specifically looking for one address to connect to another spreadsheet. How can I minimize time searching/finding "one" specific cell? How can I connect two spreadsheets? -- JOE :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert a specific address from a list if the contents of cell A1=x | Excel Worksheet Functions | |||
| Finding the Address of a Cell | Excel Worksheet Functions | |||
| Finding row # of last cell containing contents | Excel Worksheet Functions | |||
| Insert Cell Contents in middle of web address | Excel Discussion (Misc queries) | |||
| How do I use cell contents as an address in a formula | Excel Worksheet Functions | |||
Hybrid Mode
