The info is dowloaded into other sheets. The main sheet uses lookups to
gather all the info together to calculate it.
e.g.
Part No Seq No Description Labour Material Total
1111 2 printer 10 15
25
1112 2 welder 15 10
25
Subtotal 25 25
50

The only thing i type in is the Part no and the rest is picked up by lookups
When i have all the items in that sequence inputted i need to be able to do
a subtotal on them automatically.

"NickHK" wrote:

enyaw,
Does the DataSubtotals achieve your goal ?

NickHK

"enyaw" wrote in message
...
I am creating a template to calulate information that is downloaded from
another program. The information is downloaded into different sheets and
i
need to do lookups to bring the information into one sheet. The problem i
have is that there are subtotals to be placed on the sheet but the
information is not always in the same format. In one download there may
be
four items to calculate while in another download there may be only three.
Is there any programming I can use to calculate the subtotals once all the
items are in place?

Thanks