Find
Hi,
Listbox in a form that is filled by a combobox example:
User chooses "Oranges" from the cbobox and the listbox is filled
Invoice Number
2
5
7
8
27
Lets say the user then multi selects invoice#5,7,28 I would like to hit the
enter button and it go back to the back database worksheet that all of this
is being pulled from SEARCH column "b" for those invoice numbers and then
place a "paid" in column "d" for the matching invoice numbers Example
Worksheet "ProduceData" Range "Database"
B C D
Invoices
1
2
3
4
5 Paid
6
7 Paid
8
. . .
.. . .
28 Paid
Any help please! I am so lost on figuring this out. Thank you.
--
Though daily learning, I LOVE EXCEL!
Jennifer
|