Hi

I import figures from access on a monthly basis. I import a varying number of figures into col B of an excel spreadsheet. I want to automatically add these numbers when a button is pressed and then link the sum into another sheet. Can anyone point me in the right direction?



Cheers
Tony

__________________
Cheers
Tony

u could try record a macro and do this: Data > Import External Data, follow the steps, and stop the macro recording.

Look at your code , and ajust things if necesarry

Function CheckDataForRange(sSheet As String) As Double
dRow = 0
dTotal = 0
Do
    dRow = dRow + 1
    dTotal = dTotal + Sheets(sSheet).Cells(dRow, 2).Value
Loop Until IsEmpty(Sheets(sSheet).Cells(dRow, 2).Value)
CheckDataForRange = dTotal
End Function

that function will total the column data for you and return a value, which you can then paste into the other sheet

hi,
u jus try this,
Select "B2" col and format it similarly for the varying imported data like "####.00".
u jus use "sum()" to a cell(may be usedrange's cell +1 cell) calculate the col "b2" values.
copy the calculated cell value and put it into a variable and open other sheet and paste it!.
is it works for u???
Vinod.


Regards,
VInod