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
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
