Need Help With Excel Macro Code.

[realniceguy5000]

Hi,

I have a workbook with several worksheets that have data that is recorded weekly. I created a pivot table to sum up the data I need to record in a grand total per person sheet. After I create the pivot table and double click on a persons information it opens up an entire new sheet (example sheet1) What I wanted to do is create a macro that did all the work for me. However the problem I am having is every time I double click a new person information from my pivot table it names the new sheet the next number in line (example sheet2,sheet3) ect... I need a way for the sheet to stay the same name when I run my macro.

Can someone guide me to a solution? Here is my code I have so far.

A few problems I am having are as follows:


1) Everytime I click my button macro it pulls the same persons data reguardless of where the cursor is at.The first person is at "b3" but they can go down as far as "b50".

2) You can see it always referances (sheet1) I need it to always referance the new sheet that was just created at the begining of the macro.

3) I would like this sheet deleted without asking if I was sure I wanted to delete it.

4) Lastly I want it to return to the first sheet and select the next cell down, Problem 1 always takes cell "b3" I would like the macro to pick for example b4 and so on each time it runs till It runs out of data.

Please Login or Register  to view this content.

Thanks for any help somone can provide.

Mike

[shg]

This is the Excel programming forum, so it's a safe bet that you're looking for help with code. Please take a few minutes and look at titles of other threads that give a hint as to what the nature of the problem is, then start a new thread with a descriptive title.

Thanks.