Sub Summarize macro code help needed.....

**ThaGonz** · 10-20-2012, 11:01 PM

I have received great advice here in the past and I greatly appreciate it! I am hoping someone can help me with this issue as well...

I have a workbook with multiple sheets that are being updated regularly by different users. I am using a Sub Summarize macro to copy all data from the individual sheets and paste it all on one summary sheet ("Data Summary") in the workbook so that management doesn't need to look at 20 different sheets to get the data.

The code I am using works great and data from all the sheets populates correctly on the summary sheet but I need some help fine tuning 2 issues. I know it is probably a simple fix but for some reason i just can't figure it out.

Issue 1: I need to copy data from all sheets starting at Row 3 instead of row 1 because the first 2 rows on all sheets are header rows. Right now when I run the Macro I end up with 20 identical header rows on the "Data Summary" sheet

Issue 2: I need one sheets data to be excluded from the summary as it is an instructions page. The sheet name is "Storm" and I do not want its data included in the Summary sheet.

Here is the code I am using any help would be greatly appreciated!

Please Login or Register  to view this content.

**dwint** · 10-21-2012, 12:29 AM

try this code

Please Login or Register  to view this content.

if its not working for you, please post your sample

**ThaGonz** · 10-21-2012, 08:49 AM

dwint thank you for your response. I tried the code you supplied and I keep getting a 400 error. I have attached a sample sheet so you can see what I am trying to do. The sample sheet attached is currently using the original code I attached in the original post.

The buttons at the top of the "Data Summary" sheet run the macros to populate and also clear that sheet.

As you will see when you run the Summarize Macro it works great but as stated in the original post I don't want the "Storm" sheet data or the header row data (rows 2 and 3) from all the other included in the summary on the data summary sheet. So I have formatted all the data I don't want in the summary in BOLD RED with an X next to it. So basically when the summarize macro is run I should see no BOLD RED "X" data on in the data summary

Let me know if there are any additional questions.

Thanks again!!!

**event21** · 10-21-2012, 09:08 AM

Hi -

try this one.

Regards,
event

**ThaGonz** · 10-21-2012, 09:31 AM

Thanks Event, Exactly what I am looking for! Works great

Thanks for everything guys! This one is solved

**ThaGonz** · 10-22-2012, 03:20 PM

OK so I guess I was wrong...The code worked great in the sample workbook attached but for some reason when I add it to the actual workbook I need it for it still includes row 2 from all sheets in the summary but I need rows 1 and 2 excluded as those are header rows. I have attached the actual workbook I need it for if someone could take a look and let me know what I am doing wrong I would greatly appreciate it!

When you open the work book a userform will appear. Check the "fiber data summary" box and that sheet will load. At the top righ of the sheet is the "summary button" that runs the summarize macro. Once you run it you will see all the header rows populate.

The code is under ThisWorkbook in VBA.

Please Login or Register  to view this content.

**ThaGonz** · 10-22-2012, 05:46 PM

Never mind....I figured it out. Thanks all! Solved

**event21** · 10-22-2012, 07:30 PM

Hi -

In the codes, you can find this line;

Please Login or Register  to view this content.

change it to;

Please Login or Register  to view this content.

to exclude the headers.

Regards,
event

Sub Summarize macro code help needed.....

LinkBack

Thread Tools

Rate This Thread

Display

Sub Summarize macro code help needed.....

Re: Sub Summarize macro code help needed.....

Re: Sub Summarize macro code help needed.....

Re: Sub Summarize macro code help needed.....

Re: Sub Summarize macro code help needed.....

Re: Sub Summarize macro code help needed.....

Re: Sub Summarize macro code help needed.....

Re: Sub Summarize macro code help needed.....

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions