Multi sheet workbook, with Summary page

[twix]

Hello All, first time user.

I have read a lot of the "multi sheet" threads and I don't think they have answered what I am trying to do. I have a workbook with many sheets, and any of the sheets can have data entered daily. I want to have a summary sheet that keeps a snapshot of the important data as its entered.

Example:
Day 1 - Sheet 1 has 3 entries into rows 1, 2, 3. Parts of that info goes onto the Summary Sheet - Rows 1, 2, 3
Day 2 - Sheet 2 has entries into Rows 1 and 2 also Sheet 3 has entries Rows 1, 2, and 3. That info goes into the Summary Sheet in order of entry onto Rows 4, 5, 6, 7, 8.
Day 3 - Sheet 1 has an entry into Row 4 that info goes into Summary Sheet onto Row 9.

ETC.


Is it possible to compile a running Summary Sheet while working in all of the other Data Entry sheets?

[alansidman]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[FDibbins]

Hi and welcome to the forum

Sounds to me like your data recording system needs to be revised before you start trying to run summaries on it I suggest you have 1 sheet for entering all data, that will make summaries and extractions far easier

[twix]

Here is a sample workbook. The headers are all on ROW 1 so my example shifts down one spot. Sorry.

[twix]

There are 3 managers responsible for different regions. We'd like to keep the region and corresponding notes separate and just compile on the summary sheet the snapshot data.

[twix]

Is this a situation where Macros come into play?