Sytze de Boer wrote: > 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 > Have you read Tamar Granor's Office Automation book? It has content about Microsoft Excel, iirc.
http://www.hentzenwerke.com/catalog/autofox.htm -- Michael J. Babcock, MCP MB Software Solutions, LLC http://mbsoftwaresolutions.com http://fabmate.com "Work smarter, not harder, with MBSS custom software solutions!" _______________________________________________ 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.
