Fix macro to work when worksheets are added

**messermc** · 04-02-2013, 05:41 PM

I have a macro that was working well. It was copying the outputs from 2 merged & concatenated cels, and pasting the results into a separate worksheet. However, I have another macro that launches a new blank worksheet/form and it adds changes the worksheet name by NEW PLATE, then NEW PLATE (2), NEW PLATE (3) and so on. As a result, my maco fails.

In addition to the needed fix, I would also like to have the macro paste the data into another workbook as well.

Please Login or Register  to view this content.

Thank you

**JBeaucaire** · 04-02-2013, 07:07 PM

Try this.... instead of needing a specific sheet, it "COPIES" from whatever the activesheet is and pasted into the SUMMARY without activating it first, that's not necessary.

Please Login or Register  to view this content.

**messermc** · 04-03-2013, 08:17 AM

Thank you JBeaucaire,

Your code eliminated the problem with the changing worksheet names. Works great. Did you have any thoughts on the second part of my question?

"In addition to the needed fix, I would also like to have the macro paste the data into another workbook as well."

Thanks again!!!

**JBeaucaire** · 04-03-2013, 10:49 AM

What workbook? Full explanation.

**messermc** · 04-03-2013, 11:17 AM

I want to do everything the same as it is now, but in addition, also paste the data into a separate excel workbook, whereas the the data is currently being pasted into a separate worksheet in the same workbook