Could you please guide me how to populate the rows in the sheet (Report) from different sheet (Datas) based on the selection made in Report Sheet. For example if you select city 'Pune', the rows related to Pune City in 'Datas' sheet should be populated in Report Sheet below the Selection.
Could anyone tell me how to do it in excel 2007?
Regards
Ahamed
Last edited by omdkhaleel; 12-04-2010 at 07:12 AM.
What version of excel are you using?
find-data-and-copy-to-new-location
One way:
In sheet Datas add Filter into the first row and filter out by: city, month or whatever you need.
You can also filter by few columns.
Second way:
Look at the example (with aditional column)
I am using Excel 2007Originally Posted by davesexcel
Please modify your profile to indicate that.
Give this a go,
Make your selection then run the code, you can assign the code to a button, or you can use the worksheet change event to call the code whenever you change C5
Please Login or Register to view this content.
Last edited by davesexcel; 12-04-2010 at 07:41 AM.
Make the selection from the drop down menu and the information will show up, I un-merged the cell(C5:D5), as merged cells can be a pain.
Right click the sheet tab and select view code to see the worksheet code
It is saved as an Excel Macro enabled workbook
Why not use a PivotTable?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
That was my first answer... To just put Filter there.. And it's best way
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks