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