| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel data
I want to be able to fill out a master wrksheet and have it populate other
specific wrksheets based on the data entry for Location. Example: I have 4 wrksheets, 1 Master, 1 DC, 1 Baltimore, 1 NoVa When someone enters a location on the Master sheet I want it to auto-populate the appropriate other worksheet. Any thoughts?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel data
Hi aware
Is it possible for you to use "IF" formulas in the other worksheets, like as: =IF('MASTER'!B5="DC",'MASTER'!D24,"") "aware" wrote: I want to be able to fill out a master wrksheet and have it populate other specific wrksheets based on the data entry for Location. Example: I have 4 wrksheets, 1 Master, 1 DC, 1 Baltimore, 1 NoVa When someone enters a location on the Master sheet I want it to auto-populate the appropriate other worksheet. Any thoughts?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel data
Thanks VernonIver,
I thoght of maybe Nesting some IF functions but couldn't figure out the proper syntax. "VernonIver" wrote: Hi aware Is it possible for you to use "IF" formulas in the other worksheets, like as: =IF('MASTER'!B5="DC",'MASTER'!D24,"") "aware" wrote: I want to be able to fill out a master wrksheet and have it populate other specific wrksheets based on the data entry for Location. Example: I have 4 wrksheets, 1 Master, 1 DC, 1 Baltimore, 1 NoVa When someone enters a location on the Master sheet I want it to auto-populate the appropriate other worksheet. Any thoughts?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
| Import external data, data includes Excel function | Excel Worksheet Functions | |||
| Email (LDAP) data download into a single Excel cell - data separat | Excel Worksheet Functions | |||
| excel 2007, how to select a data point and cycle through data points | Charts and Charting in Excel | |||
| I want to convert word column data to excel row data to sort addre | Excel Discussion (Misc queries) | |||
Linear Mode
