Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting Data back and forth between Sheets
I have loaded a customer data base with name, number, and email addy in three
separate columns on one page. On another page, is my weekly planning sheet. How can I type a name on my weekly planning sheet (also located on the customer page) in column A and have Excel automatically bring forward the corresponding phone number (column B) and the email (column C) from the other sheet? Also, is it possible that when I type the result of my converstation in Column D, that it can aoutomatically be transfered to another page, where the data can be continuously added instead of being rewritten over the specified cell. Thank you very much for the help. Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting Data for .Txt Files By Unique Field Data | Excel Discussion (Misc queries) | |||
Sheets Tabs moved to Right Side of Page. How to get back to Left ? | Excel Worksheet Functions | |||
Extracting cell information from various sheets to a master list | Excel Discussion (Misc queries) | |||
sheets back to formulas | Excel Discussion (Misc queries) | |||
how do I tell excell 2003 to print sheets back to front? | Excel Discussion (Misc queries) |