Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reflecting info between an excel file and a word one or two excel file. | Excel Worksheet Functions | |||
Reflecting info between an excel file and a word one or two excel file. | Links and Linking in Excel | |||
Reflecting info between an excel file and a word one or two excel file. | Excel Discussion (Misc queries) | |||
Macro for Filter Switches ... Maybe??? | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) |