Hi Scott ... thank you for caring to help. I don't see where I can upload an example, so I will try to explain as best I can. Like I said, I am really at a loss. There has to be a way EXCEL can work for me.
All of my data starts as a .txt file. I Open it in excel to make the changes needed as I have over 11,000 items. I sort and make changes several times to specific data and type, but that isn't the issue as that can change depending on my mood :-)
Column A = Action (Add to inventory, revise, or delete from inventory)
Column B = item label that may be used for multiple items... such as different quantites, but still the same part number.
Column C - I = different descriptives that doesn't change
Column J = Retail (not used, just reference for me)
Column K = Selling price
Column L = where I do my modifications to start price that I get from Column M which is my cost. I get my start price using =M2*35%+M2 and if no mods are needed I move it to K. This is the intial sheet. I save as .csv to upload to the web... with Column A being a command of ADD.
Once the product is added to the web a unique id is assigned. I can if I have to manually MATCH as this would be a one time task.
What I need to do is REVISE my selling prices daily. I receive a daily datafeed (.txt) This is where I don't know how to explain it. I need somehow to match to current inventory and update the prices. Once I get that part accomplished ... I want to be able to ADD and REMOVE items that aren't on my main file.
I know excel is a great tool and it is probably wasted in my hands as I don't use (don't know how) for all it's worth. I am familiar with the basic math functions of it, sorting, find and replace ... simple stuff ... that's about it.
I don't find it in help ... I tried a couple of different things from the import data, that made a mess that I couldn't undo (no ask for save) ... but I did attempt from a copy.
so ... how do I match and replace as the main thing I need to do?
Thanks for helping! ... Lisa
