Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Office

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 06-13-2005, 03:11 PM
Novice
 
Join Date: Jun 2005
Posts: 3
jamal420 is on a distinguished road
Default Refreshing Data in Excel

How to refresh data between two worksheets or two Excel files? Basically the question is how to update a column based on another coulmn (comparing the column between two datasets). Any suggestions.

Thanks,
Jamal
Reply With Quote
  #2  
Old 06-13-2005, 03:24 PM
Matrix's Avatar
Matrix Matrix is offline Windows 7 32bit Office 2010 32bit
Admin
 
Join Date: Jan 2005
Posts: 468
Matrix is on a distinguished road
Default

How do those two Excel files connected to each other? Or in other words, how did you make the second Excel file based on the first one?
Reply With Quote
  #3  
Old 06-13-2005, 03:31 PM
Novice
 
Join Date: Jun 2005
Posts: 3
jamal420 is on a distinguished road
Default

Well, in one file I have various fields(file 1) ; in the other file (file 2) I have two fields which are common in the other file(file 1). What I like is to compare (between file 1 and 2) one of the common field and update the another field (updating a column in file 1 from file 2). I hope this clarifies the problem.

Thanks!
Reply With Quote
  #4  
Old 06-13-2005, 03:45 PM
Matrix's Avatar
Matrix Matrix is offline Windows 7 32bit Office 2010 32bit
Admin
 
Join Date: Jan 2005
Posts: 468
Matrix is on a distinguished road
Default

I think you need programming to achieve that, VBA may be the common way.

Since I don't know VBA, I will create two ODBC data source for these two Excel files, then use a programming language I'm familiar with (such as Java) to process them, just like normal Database tables, this is far beyond the Excel scope though.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening multiple Excel files within the same Excel window. lost9471 Excel 2 05-01-2010 01:57 PM
Excel not saving all data and formatting TRT Excel 2 04-09-2009 12:51 PM
System seems to be refreshing - hourglass while typing messa Waldo1973 Outlook 0 07-13-2007 10:25 AM
Automatically entering/fill data in cells in Excel 2003 dipdog Excel 0 08-17-2006 08:37 AM
Saving only "DATA" on excel? No white bottom? jrasche2003@yahoo.com Excel 0 08-07-2006 09:27 AM


All times are GMT -7. The time now is 12:02 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft