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.
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,514
Messages
5,602,089
Members
414,501
Latest member
mdhaumyu

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