Hi.

I am try to create a macro that copy the data from rows 1:6 on Sheet1 and paste only values (no functions,formulas,etc.) to new sheet after Sheet1. Should make a new sheet everytime so everytime i run it, it will create a new sheet and the values will be saved. If possible i want to name the new sheet what the contents are in cell B2.

I keep running into issue when i try to name the new spread sheet the contents in B2. I can copy values too, but it keeps functions and therefore defeats the purpose why i want to paste only values in new sheet. if someone could write a VBA code for what I am trying to do, you will make my day!!! Thanks in advance for any help!!!