ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Placing external data in a worksheet (https://www.excelbanter.com/excel-worksheet-functions/202428-placing-external-data-worksheet.html)

Ken East End

Placing external data in a worksheet
 
I have a monthly report that uses external data. If I import the data into
excel in a code column and a data column format, how can I place this data in
a specified column of a report that also has a code column? The column to
place the data changes monthly and is formatted with subtotals, so it is not
sequential by row as the imported data is.

Otto Moehrbach[_2_]

Placing external data in a worksheet
 
Ken
Nobody but you knows your business. What is a "code column"? What is a
"data column format"? Tell us what you have, what you want to have, and how
you want to get from one to the other. HTH Otto
"Ken East End" <Ken East wrote in message
...
I have a monthly report that uses external data. If I import the data into
excel in a code column and a data column format, how can I place this data
in
a specified column of a report that also has a code column? The column to
place the data changes monthly and is formatted with subtotals, so it is
not
sequential by row as the imported data is.




All times are GMT +1. The time now is 09:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com