Delete One Row + Copy All Sheets + Save As

Hi,

This is the original post but it still had some quirks:
http://www.excelforum.com/excel-prog...ml#post3912014

I tried a code that was handed to me earlier:

Please Login or Register  to view this content.

It does delete the row as intended and saves the file but it doesn't retain the other two worksheets when saved. The new workbook only contains data from Worksheet 1 with one less row which is good but I can't figure out how to include the other two worksheets.

How do I retain the process but add two other worksheets with formulas? I also need those to keep the tests intact.
Happy to have forum help! Thanks in advance.

*I want to upload the file but its way past the limit.

Hello, I Didn't get you, what do you mean retain other 2 worksheets , post your data sheet.

The workbook has 3 sheets:
1. Data
2. Test A
3. Test B

In the data there are several rows and I need to delete them 1 by 1 then save each file as I delete them. As I said, file is too large to upload. I'm sorry.

So basically you want TestA and Test B also to be added to every new workbook as it is ..... ???

Yes.

It might be redundant for you but it is necessary for me. Do you think it is possible?

Just use this code , it should work as you required....

Need to change the path

Please Login or Register  to view this content.