Mark Simms
marksimms at verizon.net
Tue May 8 20:36:00 CDT 2012
Charlotte - I understand, but I think this problem has really gotten to you... ;) My rec was related to getting that Excel data into a disciplined database format. Wasn't that the original intention ? > There is no flexibility in the Excel end. We are not allowed to make > any > changes except to add rows and columns if needed to expand the range. > The > only practical thing I can do is temporarily pop in some code in Excel > to > parse data into the the data points. It isn't a pivot format per se, > although I suppose that's what they were aiming for. Anyhow, it will > probably come down to exporting the data into a fixed width text file > and > then reading it into the Excel sheet to fill in the appropriate blanks > from > a macro in Excel. After that, delete the macro and send them the > spreadsheet. Understand that we're dealing with a network environment > where virtually nothing is run locally. > Charlotte Foust