Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Datasheet with drop down
I am working in Excel 2007 and I was wondering if it is possible to put a
datasheet on sheet 1 to pull a part of the data I have entered on sheet 2 based on a pull down box. Sheet 1 is a Dashboard Sheet 2 is the Data Coumns A thru AF, Rows 4 thru 350 I want to insert a Combo Box in sheet 1 where I can choose Listings, Pendings, Closed and a datasheet would populate with data from data sheet 2 from columns A, B, D, E, and G . The datasheet would have to be able to change size according to the number of rows to populate. I was also wondering if it is possible to have 2 criteria to populate the datasheet, 1 would be for the Listings, Pendings, and Closed and the other would choose a month Jan, Feb, Mar, etc. based on a date in column N for listings, column Q for Pending and column S for Closed. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get number of all rows in every datasheet together? | Excel Discussion (Misc queries) | |||
How to automate datasheet stuffing? | Excel Worksheet Functions | |||
Population org char from a datasheet | Excel Discussion (Misc queries) | |||
Text box linked to datasheet | Charts and Charting in Excel | |||
Where is the viewing datasheet button? | Charts and Charting in Excel |