Hi folk My client has an extremely large XLS spreadsheet and several columns are very wide Column 1 is the SKU, column 5 is the price I need to update column 5 based on my stock file price
I have a fair amount of "creating" or populating an existing spreadsheet with a VFP module, but this one requires me to FIND the SKU in the existing spreadsheet, and then change the cell reference. e.g. E66 or E2500 I already have Hentzen's book and it explains how to search and replace within a Word doc, but not with Excel Can anyone help me with this ? (For various reasons, it is not practical to import the data and then re-export) Regards -- Sytze de Boer Kiss Systems Ph: 64-7-8391670 Mob:021 937611 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
