Excel data

  • Thread starter Thread starter aware
  • Start date Start date
A

aware

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??
 
Hi aware
Is it possible for you to use "IF" formulas in the other worksheets, like as:
=IF('MASTER'!B5="DC",'MASTER'!D24,"")
 
Thanks VernonIver,

I thoght of maybe Nesting some IF functions but couldn't figure out the
proper syntax.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop returns only one value, does not loop & an assignment to columnhow-to problem. 26
Data update 1
Need help using data from multiple worksheets to create a Summary 3
Import data from 1 cell on 1 worksheet to othr cell(s) in another 1
How can I export data from one worksheet to another? 2
Autosort in Excel 2
merging and mailing multiple worksheets 1
Excel Chart - Too many data points in Series? 1

Back
Top