Import Excel data into new Excel spreadsheet

G

Guest

Is there an easy way to import data from an (ugly) Excel Spreadsheet which I
will call "the raw data" into my (pretty) Excel Spreadsheet with nice
formatting.
I need to do this once a month.
The data is the all same (oh, ok there's some extraneous data in the "raw"
one - some extra columns - but I can delete those columns either before
importing or after).
Thanks!
Frank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Data Import into Excel 3
Unwanted formatting with imported data 1
Excel 2003 - Importing External Data - formatting problem? 2
SAP export to Excel 2003 1
Import External Data 3
Access Subscript out of range when importing into access 2010 from excel 0
Import Multiple XML Files into Excel 3

Top