Create drop down list, find, copy and add cumlative total

**Matso** · 10-06-2010, 02:36 AM

I can't seem to get any vba coding correct to do what I want to do, so any help would be appreciated.

After I paste new data in Sheet1, I am trying to create a drop down list of 'Site Name' in cell E5.
Then once I select a site it searchs sheet1 for an exact match copies and adds the cumulative total for the year across the sheet.
This is also done for the Org, Sub Division and Division.

**JBeaucaire** · 10-06-2010, 03:14 AM

1) Click on INSERT > NAME > DEFINE
2) Names in workbook = Site_Name
3) Refers to: = =OFFSET(Sheet1!$D$6,0,0,COUNTIF(Sheet1!$D:$D,">a"),1)

4) On Sheet Master cell E5 use the data validation settings:
Allow: List
Source: =Site_Name

**Matso** · 10-10-2010, 08:25 PM

Thanks Jerry.
It makes it easier for me to adjust the list of site names accordingly as it does vary with additional sites.

However is there a macro that could do the cumulative counting once the site is selected?

The reason is that there is less likeliness of tampering with the code as there are some staff able to unlock the worksheet even if I password protect it.