Generating an automatic summary in a different worksheet

hc

New Member
Joined
Dec 22, 2003
Messages
31
(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.
Code:
(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.
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

hc

New Member
Joined
Dec 22, 2003
Messages
31
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

New Member
Joined
Dec 22, 2003
Messages
31
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.
 

Forum statistics

Threads
1,172,067
Messages
5,878,974
Members
433,387
Latest member
boncphoto

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top