ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Linking data (https://www.excelbanter.com/excel-discussion-misc-queries/156959-linking-data.html)

graydon

Linking data
 
Hi,
Some time ago I had an application made for me that trawls certain betting
website and saves the days info into daily spreadsheets.
I am now trying to convert this data into another spreadsheet that updates
(adds to each field) from each days' sheet.
I have succesfully made a command search through each individual workbook to
leave me with data that I now need to link.(using Dsum)
My problem is that there are around 4500 cells that need to be linked to a
database that will add them all up to work a percentage. (although its the
same cell numbers that dont change, only the spreadsheet changes.)
1. Is there a way I can make a button that will say export the days relevant
cells to the linked workbook and,
2. How do I get the workbook 'collect' the info and add it rather than
replace it?
thanks in advance.
Graydon


All times are GMT +1. The time now is 02:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com