Generating an automatic summary in a different worksheet

[hc]

(This question follows from this thread, if you are interested.
http://www.mrexcel.com/board2/viewtopic.php?p=352437#352437)

I have the following worksheet:

Column A is text only.
Column B is integers only.
Column C is text only.

(Worksheet called "Contents")
A         B      C      
-         -      -
Month     No.    Footastic
-----     ---    -----
JANUARY   1      FOO1   <-- Row 5.
                 .      <-- Info about FOO1 in other columns.
                 FOO1	<-- If I write FOO1 here again by mistake, ignore it. Look for unique items
                 .          only.
                 FOO2
                 .      
                 .      
JANUARY   2      FOO6
                 .
FEBRUARY  1      FOO1
MARCH     1      FOO2
.
.
.
etc for the rest of the year. The No. column does not represent a date.


If I click on a button called gotoSummary, I want the "Summary" worksheet (which already exists) to be populated in the following manner:


(Worksheet called "Summary")
A         B      C
-         -      -
Month     No.    Footastic  <-- Column headings are already in place, start from Row 5
-----     ---    -----
JANUARY   1      FOO1   <-- Row 5
                 FOO2   <-- Ignore the data in columns D onwards
JANUARY   2      FOO6
FEBRUARY  1      FOO1   <-- I will then type in new data for each FOO.
MARCH     1      FOO2   <-- Column D data here is different to Column D data in the "Contents" worksheet

If I then modify the original worksheet by adding or deleting rows, the "Summary" worksheet must be updated when I click on the gotoSummary button again. The data which I manually typed in (in the Summary worksheet) must not be lost.

Thank you.

 

[hc]

There must be a solution to this.

What about keeping both worksheets synchronised by a worksheet_change sub instead of clicking on a button?

Maybe I need to introduce a unique identifier for each No.?

What do you think?

 

[hc]

For completeness ...

I have realised that this is actually a relational database problem, so I have gone with MS Access to solve this.

Thanx again for all the help.