| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto filling cells across mutliple sheets
 Hi, I am creating a customer database in a Excel 2000 pro workbook. It comprises of multiple worksheets each containing a different companies details (branc hes, phone numbers, etc). I have ensured that in all sheets column A is a nu meric field and that each row has a unique number in this column (unique acr oss all sheets). Where I have got "stuck" is that I want to create a additional worksheet in which I can manually designate a number in a cell (column A) and excel will automatical ly fill the remaining cells in that row from whichever sheet the number corr esponds. Help please..... -- Alec H ------------------------------------------------------------------------ Alec H's Profile: http://www.excelforum.com/member.php...o&userid=31042 View this thread: http://www.excelforum.com/showthread...hreadid=507154 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically filling in cells based on another cell's content | Excel Worksheet Functions | |||
| auto color blank cells ,best solution | Excel Discussion (Misc queries) | |||
| auto filling columns from rows | Excel Discussion (Misc queries) | |||
| Auto Skipping and protected cells | Excel Discussion (Misc queries) | |||
| count cells over multiple sheets | Excel Worksheet Functions | |||
Threaded Mode
