![]() |
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