Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-13-2005, 03:11 PM
jamal420 jamal420 is offline
Novice
Refreshing Data in Excel
 
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 Refreshing Data in Excel Windows 10 Refreshing Data in Excel Office 2010
Admin
 
Join Date: Jan 2005
Posts: 429
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
jamal420 jamal420 is offline
Novice
Refreshing Data in Excel
 
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 Refreshing Data in Excel Windows 10 Refreshing Data in Excel Office 2010
Admin
 
Join Date: Jan 2005
Posts: 429
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
Refreshing Data in Excel Opening multiple Excel files within the same Excel window. lost9471 Excel 2 05-01-2010 01:57 PM
Refreshing Data in Excel 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft