Okay, I know this has been posted before, and answered elsewhere, however nothing I try seems to work for me. I can do this extraordinarily easily in Access, but am working in Excel so am in to different territory now.
I have a userform with 2 list boxes - one contains a list of transaction IDs (stored as 'Check'), the second needs to give a list of items that are in that transaction when the 'check number' is clicked on the first listbox.
I have a 'Data' spreadsheet that contains a continuous list of items, prices and the transaction ID associated with them - I therefore have 3 columns (Product, Price and ID) - the first listbox is generated from the 'DataCheck' sheet, selecting the check numbers (sheet contains a list of check numbers and totals)
So - Listbox1 's OnChange event needs to update Listbox2 's data to show filtered data based on the selection made, and this needs to be 3 columns of data (Product, Price and Check).
All code I have tried seems to pull over only one column (which is no use as I need at least 2), or starts pulling the wrong information, or sometimes doesn't even filter at all.
I have tried using auto filter, and that is not really much use as I cannot filter the actual Data Sheet itself because of dynamic updating that can occur to it.....
I have managed to code everything I need, but this has really stumped me!
I am excel 2003 currently, and have tried most of the options found here - additem doesn't seem to work in the right way, neither does auto filter...
Help please as i cannot find an answer to this anywhere.
Bookmarks