Hey again,
I have a calendar-type .xls going on where I use the calendar templates for each month with added worksheets for all the notes/orders data and a helper worksheet on the side to make things smoother. Its operated by a userform which draws data from the data worksheet from any given date.
Now what I would like to do is to get a button which would get the order data for each date (just the shipment location and name of the company/person) from another .xls-file where I have the orders neatly organized in rows with plenty of information of each one (organized in columns).
The problem is that MATCH/INDEX or VLOOKUP only return the first value encountered. A lot of dates have multiple shipments going off. How do I work around this? My mind is toying around with WHILE loops but I don't know enough about VBA programming to figure out how to ignore already returned results the second time around.
Bookmarks