Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking data | New Users to Excel | |||
Linking data | Excel Discussion (Misc queries) | |||
linking data | New Users to Excel | |||
Linking Data | Excel Worksheet Functions | |||
linking data | Excel Discussion (Misc queries) |