G
graydon
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
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