Importing data without losing calulations or formate

  • Thread starter Thread starter garrwan
  • Start date Start date
G

garrwan

Sorry if reposted, didn't seem to go the first time.

Hi,

I am wonder if it is possible to have a worksheet setup so that an
calculations and formatting are maintained if new or additional data i
imported.

IE

Name Cost
x 1
y 2
TOTAL 3 (Sum formula)

But if added another row the sum updates.
Name Cost
x 1
y 2
z 1
TOTAL 4 (Sum formula)

I would be cool with doing it via VBA if neccessary.

TIA
 
Hi,

in nearly all cases you won't need VBA. For your example of the SUM
formula
if you enter =SUM($A:$A) in cell B1 you cann add as many values in
column A as you want

You can also calculate the last row and reference the specific range
using a combination of OFFSET and COUNTA
=OFFSET($A$1,1,0,COUNTA($A:$A)-1,1)

This just as a starter. Maybe you explain your specific problem with a
little bit more detail
Frank
 
Back
Top