Appending in Excel

[Guest]

I have a master sheet (template) with 3 different categorie
ie: shoes, socks, pant

I want to be able to take the new daily totals for each category and put it on its own sheet so that each category can get it's own total

Each template will have updated data that I would like to append below the old data in each category sheet

Any suggestions on how that can be done?

 

[Don Guillett]

how about ,where shoes is a named range
sheets("shoes").cells(rows.count,"a").end(xlup).row+1=Application.Sum([shoes
])


--
Don Guillett
SalesAid Software
(e-mail address removed)

I have a master sheet (template) with 3 different categories
ie: shoes, socks, pants

I want to be able to take the new daily totals for each category and put

it on its own sheet so that each category can get it's own total.

Each template will have updated data that I would like to append below the

old data in each category sheet.