using combox boxes to make a report sheet.

[raum]

ok, I have multiple criteria, "Plant" Column C and "Month" Column B.

I created a page called "REPORT" that has header rows, and contact inforformation that gets pulled from the "INDEX" sheet via lookup, based on linked cells that refer to comboboxes. I can do all that myself.

Here'e the tricky part, though.

As I mentioned above, the report has two combo boxes on it. You select the Plant in combobox1, and the Month in combobox2.

Then...

Private Sub ComboBox2_Change()

This is display the records from my third sheet called "TRANSACTIONS" where column C = combobox1.Selection and Column B = combobox2.Selection.

The general steps to the process are:

Dim rngAllTransactions As Range
Dim rngRightMonth As Range
Dim rngMonthlyPlant As Range

rngAllTransactions = All Rows on worksheet “Transactions” where column B is not blank.

rngRightMonth = Rows in rngAllTransactions where column B = combobox1.Value

rngMonthlyPlant = Rows in rngRightMonth where column C = combobox2.Value

Then, I want to

Copy cells D:L for rngMonthlyPlant to Worksheet “Report”, starting at D30.

can anyone help me with this? I am struggling with this in Excel when it is a natural function of Access to find a recordset, because the ues of Acces is restricted in our company, and I don't know enough VBA to compensate. but I am learning! (and reading three books)

------

NOTE: I can concatenate the two fields and create a custom filter, but it won't work to find values across worksheets, nor will it print the rows to the REPORT worksheet. I also got a function based solution from another forum and implemented it, but the minute I gave it to the accountants, they managed to hose it up and requested it in vba.

and I hate to be a bother, but I swear I looked. it would help if I could properly word my requests, and refine my searches.

Thanks, for all your help.
Charlie

 

[raum]

ok, I found some help, and for those who may look for this by search...

Chapter 11 : VBA and Macros for Microsoft Excel was a big help in getting the syntax right for the procedures in my Macro.

ISBN: 0-7897-3129-0
QUE Publishing

(obviously, its a Mr. Excel book.)