Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 20th 05, 01:38 PM posted to microsoft.public.excel.worksheet.functions
Gary c
 
Posts: n/a
Default Automatically updating data from another excel spreadsheet

I have set up a spreadsheet which required data from another spreadsheet and
want to know how i can set this up to update every time i open the sreadsheet.

I want the full page of the source data copied accross to a worksheet in my
main excel file.

Can anyone help? It is a macro code i need?

  #2   Report Post  
Old November 20th 05, 02:41 PM posted to microsoft.public.excel.worksheet.functions
bpeltzer
 
Posts: n/a
Default Automatically updating data from another excel spreadsheet

If you want ALL the data copied, and the source is a single file, you COULD
set up an equation in every cell (ex: in A1:
=[AnotherBook.xls]AnotherSheet!A1). But it's big and pretty ugly.
The cleaner way, by far, would be VBA code in the Workbook_Open method that
automatically opens the source sheet and copies the entire sheet over.

"Gary c" wrote:

I have set up a spreadsheet which required data from another spreadsheet and
want to know how i can set this up to update every time i open the sreadsheet.

I want the full page of the source data copied accross to a worksheet in my
main excel file.

Can anyone help? It is a macro code i need?



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
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
How do I get data to automatically flow to another sheet? excel 20 dizzyjulie19 Excel Worksheet Functions 1 July 22nd 05 06:17 PM
Automatically transpose when pasting data in excel SSD1 Excel Worksheet Functions 3 July 18th 05 02:38 AM
Updating calculations automatically when i enter in new data chica_guapa Excel Discussion (Misc queries) 1 February 8th 05 10:17 PM
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? oil_driller Excel Discussion (Misc queries) 1 February 8th 05 09:34 AM


All times are GMT +1. The time now is 12:53 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017