I need to extract all the items that I sell from the source dadafeed I get from my supplier from sheet 1 and place the entire row into a blank row on sheet 2 and highlight (in red) all the cells in column E that say “no”
I am a small business entrepreneur just getting my business off the ground but the extreme difficulty in controlling inventor has cost me sales and created some bad feedback ratings on eBay. I get a data feed with over 10,000 lines of data for the products they provide for me, but I only sell about 130-140 of them. So I need to be able to download their datafeed daily and quickly sort the list so that I only see the items that I sell and not the other 9,000++ otherwise I have to manually look up each item via ctrl-find and search for each of the 130 items to verify they are still in stock which is ridiculous from a time standpoint. Many of these item go in and out of stock daily.
The included photo's below I hope will help give you the idea of what I am working with.
It's not that I am lazy but I have been working on trying to make this work for days now with no results from the formulas as I need them. And I have searched and got nowhere for these results I need. I have also posted it a t(with no replies): Extract all approx match determined from expandable list in sheet two and create table
ANY help would be appreciated.
Note that the source datafeed has variables in the item numbers.
In other words the might be a number 2609 and another number
2609-twin. I need both of those items extracted even if I only have
"2609" typed in the sheet in exhibit "B". SO if it starts with "2609"
then I want it extracted.
I am a small business entrepreneur just getting my business off the ground but the extreme difficulty in controlling inventor has cost me sales and created some bad feedback ratings on eBay. I get a data feed with over 10,000 lines of data for the products they provide for me, but I only sell about 130-140 of them. So I need to be able to download their datafeed daily and quickly sort the list so that I only see the items that I sell and not the other 9,000++ otherwise I have to manually look up each item via ctrl-find and search for each of the 130 items to verify they are still in stock which is ridiculous from a time standpoint. Many of these item go in and out of stock daily.
The included photo's below I hope will help give you the idea of what I am working with.
It's not that I am lazy but I have been working on trying to make this work for days now with no results from the formulas as I need them. And I have searched and got nowhere for these results I need. I have also posted it a t(with no replies): Extract all approx match determined from expandable list in sheet two and create table
ANY help would be appreciated.
Note that the source datafeed has variables in the item numbers.
In other words the might be a number 2609 and another number
2609-twin. I need both of those items extracted even if I only have
"2609" typed in the sheet in exhibit "B". SO if it starts with "2609"
then I want it extracted.