Hi,
I have a vlookup formula let's say in K2, is there a way to autofill down
but exclude sum totals?
Example
Vlookup formula
data
total sum Group1
data
total sum group2
grand total sum of group1 & 2
So I need to copy the vlookup between the sum totals. Is there a way?
any help would really appreciate.
thanks
Juan

Assuming your sums are formulas, not entered values, then (and for this
example, I'm assuming everycell between and including your vlookup to the
grandsum has something in it) something like:

with activesheet
.range("k2").copy
.range(.range("k2"),
..range("k2").end(xldown)).specialcells(constants_only).pastespecial
formulas_only
end with

sorry, I'm not sitting in front of my excel so I don't remember what the
constants for constants_only and formulas_only really are but if you're in
the vba editor they'll pop up.

"Juan" <(E-Mail Removed)> wrote in message
news:6809DBC8-772D-4659-9F41-(E-Mail Removed)...
> Hi,
> I have a vlookup formula let's say in K2, is there a way to autofill down
> but exclude sum totals?
> Example
> Vlookup formula
> data
> total sum Group1
> data
> total sum group2
> grand total sum of group1 & 2
> So I need to copy the vlookup between the sum totals. Is there a way?
> any help would really appreciate.
> thanks
> Juan