Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill down Vlookup formula between sum?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofill down Vlookup formula between sum?
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup, Column Index Num and Autofill | Excel Worksheet Functions | |||
VLOOKUP and AutoFill | Excel Worksheet Functions | |||
Vlookup and autofill | Excel Discussion (Misc queries) | |||
No autofill VLookup function | Excel Worksheet Functions | |||
VLOOKUP Changing reference cells in autofill | Excel Worksheet Functions |