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??

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??

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??