ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I import external data and create two formats? (https://www.excelbanter.com/excel-worksheet-functions/134973-how-do-i-import-external-data-create-two-formats.html)

Renny03

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


joel

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