Excel Workbook Data populating?

[burblecut]

Greetings all,
I am in the midst of creating a workbook that basically captures data from the user on one sheet, then automatically populates 2 other sheets with this information. Call me a noob but i can't figure out.

Attached is my sheet. It has the following tabs to give you a more understanding:
Log - Gathers information from the Issue 1, Issue 2, etc..sheets
Definitions - does nothing
Stats - Gathers info from the log sheet
Issue template - Template
Issue 1 - User tosses in the info

Also is it possible for excel to auto create tabs? For example Issue 1 is filled out, then it generates issue 2.

Sorry to bother you guys.
Thanks

[JBeaucaire]

This macro will create a new Issue for you based on incrementing the last Issue sheet currently in the workbook:

Please Login or Register  to view this content.

[JBeaucaire]

Actually, I thought a little automation linking the newly created Issue sheet to the next available row on the LOG sheet would be in order, so try this one instead:

Please Login or Register  to view this content.

[burblecut]

Thanks for the reply JBeaucaire! I will give it a shot

[burblecut]

Actually, I thought a little automation linking the newly created Issue sheet to the next available row on the LOG sheet would be in order, so try this one instead:

Please Login or Register  to view this content.

When I add this macro I get a "Type Mismatch" error. Where exactly should I be placing this macro? which sheet? Sorry, new with excel 2007
Thanks.

[JBeaucaire]

1. Open up your workbook.
2. Get into VB Editor (Press Alt+F11)
3. Insert a new module (Insert > Module)
4. Copy and Paste in your code (given above)
5. Get out of VBA (Press Alt+Q)
6. Save your sheet.

Here's a copy of the sheet with the macro installed.

NOTE: When you set up the sheet to use the first time, there needs to be at least one sheet already there called Issue 1.

[burblecut]

Ahhh, I understand now! It works great!
How do I get the Log information to update the stats though? What would be the most efficient way? another macro, or function?

[JBeaucaire]

EDIT: Sorry, the separate STATS sheet. No, I don't do much with charts and stuff. Perhaps over on the Charts forum.