no experience, learning on my own : I have three worksheets in excel which I am using. First page is where I put all the data so it can populate in sheet 2 and sheet 3. Sheet 2 and 3 is what I am going to save as pdf. My question, is there a vba code that will name sheet 2 with the value in cell A1 with the letter "F" next to it and then page three with the cell value in A1 again but with the letter E next to it? For e.g. cell A1 has Joy Nice, worksheet 2 will be named Joy Nice-F and worksheet 3 will be named Joy Nice-E. And yes I am new to VBA and I love what it can do. Thank you.