I am able to use Spreadsheets to a certain degree but this one has me stumped, I just don't really know where to start as I am very new to Excell (v.2002)...
I want to update the csv file from our website, this file must be imported and exported as an entire text block. From our POS I can export only the fields (SKU and Price) that I want, the POS is very easy to maintain and the prices are (very nearly) always correct.
Is there a way that I can set the price data from the POS to overwrite the price data for the same SKU line on the Website data? I do not need the entire formula, just some hints on which commands etc that I should be looking to use.
BTW this is needs to be done two or three times per week.
Thanks for any ideas.
[ 03-12-2003, 02:00 PM: Message edited by: Lance E ]
I want to update the csv file from our website, this file must be imported and exported as an entire text block. From our POS I can export only the fields (SKU and Price) that I want, the POS is very easy to maintain and the prices are (very nearly) always correct.
Is there a way that I can set the price data from the POS to overwrite the price data for the same SKU line on the Website data? I do not need the entire formula, just some hints on which commands etc that I should be looking to use.
BTW this is needs to be done two or three times per week.
Thanks for any ideas.
[ 03-12-2003, 02:00 PM: Message edited by: Lance E ]