Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / July 2007

Tip: Looking for answers? Try searching our database.

How to auto update a spreadsheet with data from a .xls file?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TriumphRM - 28 Jul 2007 06:06 GMT
I am saving a banking statement to a file in xls format and want to be able
ot open the spreadsheet and have the data already loaded.  Also, I would like
to keep appending the file that the banking statement is saved to if you have
any ideas on that.
JLatham - 28 Jul 2007 15:24 GMT
I think we need a little more information about your process -

You say you're saving the bank statement to a file in .xls format.  Then
when you open that file later, that data should still be there.  

I'm actually thinking that you may be well served with a simple manual
process:
get your latest statement information into an Excel workbook,
open your 'permanent' record workbook, then copy from the latest information
and use Paste Special with the [Values] option chosen to paste the latest
information at the end of previous information in the 'permanent' workbook.

> I am saving a banking statement to a file in xls format and want to be able
> ot open the spreadsheet and have the data already loaded.  Also, I would like
> to keep appending the file that the banking statement is saved to if you have
> any ideas on that.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.