| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I'm not the most articulate when it comes to spreadsheets... pleasehelp! (Trying to figure out how to auto fill a cell based on drop-down inputfrom another cell using a master sheet)
I am attempting to create a spreadsheet to organize projects and I'd like to auto fill "column D" based on a drop down input from "column B". Basically I input the customer name (column B) and I'd like to see the address of the customer auto filled (column D).
I have a second spreadsheet which I suppose is called the "master sheet" where I input all customer names and addresses so that I can auto fill on the other sheet. I am willing to share the spreadsheet to expedite any answers I receive. Please help! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I'm not the most articulate when it comes to spreadsheets... please help! (Trying to figure out how to auto fill a cell based on drop-down input from another cell using a master sheet)
I am attempting to create a spreadsheet to organize projects and I'd like to
auto fill "column D" based on a drop down input from "column B". Basically I input the customer name (column B) and I'd like to see the address of the customer auto filled (column D). I have a second spreadsheet which I suppose is called the "master sheet" where I input all customer names and addresses so that I can auto fill on the other sheet. I am willing to share the spreadsheet to expedite any answers I receive. Please help! Have a look here... http://www.contextures.com/xlDataVal02.html -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto Fill Cell Based on Data in a different cell | Excel Discussion (Misc queries) | |||
| Auto fill cell based upon another cell value | Excel Discussion (Misc queries) | |||
| Auto fill drop down stops at second cell | Excel Discussion (Misc queries) | |||
| auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
| Auto-fill cell based on adjacent cell information.. | Excel Worksheet Functions | |||
Hybrid Mode
