Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refresh data from an Excel sheet
Hello,
I have 3 files which have data. Two are text files and one is an excel file (data1.txt, data2.txt and data3.xls) I have another excel file which I use the data from these files called Summary.xls. It has 3 sheets called data1, data2 and data3 and one Summary sheet. I could easily update the data from the text files using refresh data, but can not find an easy way to refresh the data from the excel sheet. I searched this newsgroup for something similar but everything appears to require extensive programming. Am I missing something or is there an easy way to do this?? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refresh data from an Excel sheet
Has anyone had a chance to look at this? It's been over a month since my
request and haven't had any responses. I'm still doing the copy and pasting from one workbook to another and would really like to automate it. Any suggestions would be appreciated. Thanks... On Mon, 23 Jan 2006 12:21:46 -0500, Sierras wrote: Hello, I have 3 files which have data. Two are text files and one is an excel file (data1.txt, data2.txt and data3.xls) I have another excel file which I use the data from these files called Summary.xls. It has 3 sheets called data1, data2 and data3 and one Summary sheet. I could easily update the data from the text files using refresh data, but can not find an easy way to refresh the data from the excel sheet. I searched this newsgroup for something similar but everything appears to require extensive programming. Am I missing something or is there an easy way to do this?? Thanks -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
help extracting data from an excel sheet | Excel Worksheet Functions | |||
Excel renames sheet (repaired) when trying to change data from a . | Excel Worksheet Functions | |||
How do you set up a data excel sheet that links to a presentation. | Excel Worksheet Functions |