![]() |
How do I import external data and create two formats?
I want to import external data with two types of rows. On the top should be
a title with different widths, and on the bottom will be the data. Both of these types of data are coming from the same external source. I am using excel 2003. Thanks! Example: Quicksilver Oil Company Well Name Data Data Data ..01 .01 .01 ..02 .02 .02 |
How do I import external data and create two formats?
the best way is tto generate the data with commas between fields. The comma
tells excel to put the data in the next column. Putting two comma together like 12,,13 tells excel to put 12 in column A and 13 in column C. then call the file with a .CSV extension. Excel will open .CSV files automatically. Also you can Import CSV files into other workbooks use the Data - Import feature. "Renny03" wrote: I want to import external data with two types of rows. On the top should be a title with different widths, and on the bottom will be the data. Both of these types of data are coming from the same external source. I am using excel 2003. Thanks! Example: Quicksilver Oil Company Well Name Data Data Data .01 .01 .01 .02 .02 .02 |
All times are GMT +1. The time now is 11:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com