Transfer data from drop down box to a different sheet

[monkeytennis]

Hi everyone,

It's that time when I need help again and things start to get too complicated for me.

As the title says I want to move information (cumulative) that is selected from a drop down box in sheet 1 column A to a column in sheet 2.

If I select a geographical county in sheet 1 cell A1 via a drop down box of say 50 counties and then a different county is selected in cell A2 and so on, I want to see the cumulative result of that action in sheet 2 . In sheet 2 all of the 50 counties are detailed alphabetically in individual cells in column A. I need the cumulative (and running) total of each county (referenced from sheet 1) to appear by its respective county detailed in sheet 2 column A and to appear in sheet 2 column B.

I hope someone can understand what I am trying to do. I'm sure its possible but this is a bridge too far for me,

Thanks in advance.

 

[monkeytennis]

Thanks. I was using the wrong column to refer to which is why I was getting zeros. In addition to counting the counties cumulatively we are also looking at revenue per county too. So in sheet 1 column C the revenue is detailed in each row. What forumla would I need to keep a cumulative count of the revenue in column c sheet 2 against the respective counties?

This time i'm not selecting data from a drop down but manually putting in whatever is relevant.

Many thanks for you help.

 

[GlennUK]

Use SUMIF the same way.