 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Links / March 2005Drop down defining content of a range of cells
Excel 2003 I want to allow users to choose a month via a validation box and see data relevant to that month. Other worksheets/workbooks contain the data to be shown - mostly in ranges of cells. I know I could do it cell by cell with nested IF statements, but this is incredibly tedious. Is there an easy way to do this? Hi not sure of what you're after here say on sheet 1 you have your drop down box - and user Fred choose March do you want all of march's information copied from the various workbooks / worksheets into sheet 1 for him to view or do you want each workbook /worksheet he opens / views only display March's values either way i'm not sure "easy" is a word i'ld use to describe this. would another approach be to build a pivot table with the relavent information and then he can filter on that to see the data he's interested in - check out http://www.contextures.com/xlPivot08.html for information on pivot tables from multiple consolidation ranges to see if this is a feasible option. Cheers JulieD > Excel 2003 > I want to allow users to choose a month via a validation box and see data [quoted text clipped - 3 lines] > > Is there an easy way to do this? Julie it's the first option you mention - if I tried getting people to use pivot tables they'd never go near it!!! I know that this is probably a database function, but it would make my life easier if I could do it in Excel! Can you think of any way it could be done? Thanks Phil > Hi > [quoted text clipped - 22 lines] > > > > Is there an easy way to do this? Hi Phil how many worksheets / workbooks are we talking about here ... how can you know what is "march's" data ... most things are possible but maybe not practical :) Cheers JulieD > Julie > it's the first option you mention - if I tried getting people to use pivot [quoted text clipped - 42 lines] >> > >> > Is there an easy way to do this? It's actually reporting sales and revenue data from a couple of workbooks: in those workbooks, data is put under the appropriate month. I want to create a summary sheet of key data in another workbook which takes selected ranges of cells from the other workbooks. What I'm having to do at the moment is to create 12 summary sheets, each with formulae in every cell, referring to the data I need. Most of the data I want to bring in is in contiguous cells (mostly columns rather than rows). What I'd like to achieve is a single summary sheet with a drop down containing the month. When a particular month is selected, the data appropriate to that month is brought in. Any help most gratefully received!!!! Phil > Hi Phil > [quoted text clipped - 51 lines] > >> > > >> > Is there an easy way to do this? Hi Phil although it won't give you all the functionality you want - if the workbooks have a similar structure Data / Consolidation might be a way to go ... check it out and let me know what you think Cheers JulieD > It's actually reporting sales and revenue data from a couple of workbooks: > in [quoted text clipped - 78 lines] >> >> > >> >> > Is there an easy way to do this? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.