Am I going about making this automated table the right way?

LemurTruffle

New Member
Joined
Dec 16, 2016
Messages
3
Hey guys! I'm steadily learning just how much I don't know about excel.

So I'm working on making a master template for my company's landscape schedules. I'll have one sheet with an aggregate of the data that will populate tables ("Tree List", "Shrub List", and "Groundcover List" in the simplified example shown) on different sheets. I'd like for the user to be able to navigate to the table they need and then:

  1. Click in a Plant Name cell and then have the drop down display only entries that are of a type corresponding to the table (only entries with type "Tree" show up in the Tree List drop down, etc).
  2. Have the data corresponding to the selected Plant Name entry populate the rest of the row

My logic so far for tackling these steps:
  1. Data Validation: Since the list of options will be constantly in flux (we could add a Tree5, or remove Shrub3 at any point), I don't just want to use a cell range for the data validation drop down. I want to ensure that anything that's got "Tree" listed as its Type will show up as an option on the Tree List table, and so forth. Is matching the way to go here?
  2. Hopefully a simple VLOOKUP.



I'm not asking specifically how to make these things happen yet (although feel free to address that of course!). I mainly want to make sure that I'm going down the right path from a big-picture perspective before I dive in.

Also, these might end up being excel tables (since I've been told here before that they can dynamically add a row after the last entry) if that makes a difference.

Thanks for any help!

1)
1_zpsx6fqg2np.png


2)

2_zpsdhk4x7l4.jpg
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,215,459
Messages
6,124,947
Members
449,198
Latest member
MhammadishaqKhan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top