Good afternoon,
I have a spreadsheet that I use for Forecasting. Columns include:
customer(text), item(text), item desc(text), current stock(number), unit
sales by past months (number), and unit forecast by future month(formulas). I
filter by item to subtotal unit sales by month and forecast while seeing all
customers who buy that item. so far so good.
Here's my problem: once the data is filtered, under the subtotals, I want to
see existing purchase orders and their ETA dates for that same filtered item.
This ordering data comes from another worksheet. How can I isolate the
filtered item(text) to create a vlookup? Every time I change the filter, the
cell rows that are shown change...
Can this be done?
Thank you very much,
Hugues