Need code for macro to pull all data from column heading matching drop-down

**cpfenninger** · 05-02-2013, 01:59 PM

I have a spreadsheet where I want to specify a month & year (via a drop-down) and pull in all project/phase/mgr/amount data from any cell in the column matching that drop-down that has a value. The data sheet will be constantly changing, so a macro will work better than a pivot or vlookup. I am fairly new to macros & can't make this one work....can anyone help with some code or how to record this? Sample sheet attached. Thanks!

**tehneXus** · 05-02-2013, 02:33 PM

Hi,

try this:Billing Plan workbook - Sample.xlsm

Regards

**cpfenninger** · 05-02-2013, 02:35 PM

WOW - this is fantastic! How can I view the code you used to understand it better?
THANK YOU!!!!

**tehneXus** · 05-02-2013, 02:45 PM

Hi,

enable the Developer Ribbon: File -> Options -> Customize Ribbon -> Check the checkbox on the right
go to the developer tab and click the 1st button called "Visual Vasic" to open the VBA project window.
On the left side in the Project explorer you'll find excel objects listed, i.e each worksheet + one for the workbook and in this case a standard module which contains the code.
The function in the standard module is called from the "Worksheet_Change" event in the appropriate worksheet module with the selected month value and returns an array of data which is written to the sheet.

Regards