Code to save the sheet with conditions

[Sudhanshu Kuda]

I have a lab testing sheet with many cells having formula and certain cells where the value comes from the other sheet.
Also considering the page breakup, there are five pages one below the other.
I am looking for a option where in I click a button and the
exsisting sheets gets saved as an excel file in some folder but with a condition.

1) After saving cell D4 auto generates a new number (numeric).

2) File is saved in the same name which is there in the sheet.
i.e cell H3-D4.xlsx . Means the file name will be the name in cell H3 then there is - in between and then cell D4.
Or if - is not there then also it will do.

3) Values in these cells gets cleared. Range E6 to K7 , then H12 , J8 , M12.

Thanks
Sudhanshu

[Blokeman]

Try this;

Please Login or Register  to view this content.

[Sudhanshu Kuda]

Thanks a lot Blokeman
I have checked the code and its working fine.
In case if I have any querry related to this issue then how do I
address it to you again.

Thanks again
Sudhanshu