Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
bill@bb
 
Posts: n/a
Default How do I create a list in excel that contains external data?

I have spreadsheets linked to external data sources but I also need to add
data to them. Whenever the data source is refreshed rows are correctly added
or deleted from the columns containing external data but not from the columns
containing my data. My rows end up not corresponding to the external data
rows. I thought designating the entire data range as alist might help but I
recieved an error that says you can't make a list that contains external
data. Any one have suggestions?
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You could store the related data on a separate sheet. Then, on the
worksheet with the external data, use VLOOKUP formulas to return the
related date for each row.

There are VLOOKUP instructions and examples he

http://www.contextures.com/xlFunctions02.html

bill@bb wrote:
I have spreadsheets linked to external data sources but I also need to add
data to them. Whenever the data source is refreshed rows are correctly added
or deleted from the columns containing external data but not from the columns
containing my data. My rows end up not corresponding to the external data
rows. I thought designating the entire data range as alist might help but I
recieved an error that says you can't make a list that contains external
data. Any one have suggestions?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to alphabetize a list in Excel DJ Somers Excel Worksheet Functions 4 January 1st 05 04:39 AM
How to I create a pdf file from Word or Excel files stolitx Excel Discussion (Misc queries) 4 December 28th 04 08:17 PM
Create invoices from excel workbook KJH Excel Worksheet Functions 5 December 22nd 04 03:21 PM
How do I create a geographic map in Excel 2003? cain Excel Worksheet Functions 1 December 6th 04 11:29 PM
Is there a way to create a standard OHLC bar chart in Excel? [email protected] Charts and Charting in Excel 3 December 2nd 04 10:49 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"