Forum Discussion

horsteadjim's avatar
horsteadjim
Copper Contributor
Jul 31, 2017
Solved

Macro so save a sheet with info taken from a cell.

I have created a spreadsheet where the sheet 1 is a form to be filled in for Quality Control. I have created a "Save" button that will use the 'copy and move' function to create a copy of the first s...
Macros & VBA
Need Help
  • Logaraj Sekar's avatar
    Logaraj Sekar
    Aug 02, 2017

    Hi horsteadjim,

     

    Try this.

    ActiveSheet.Name = Range("C7").Value
Logaraj Sekar's avatar
Logaraj Sekar
Iron Contributor
Aug 01, 2017

Hi horsteadjim,

 

Do this for Copying Current Sheet and Paste it to End of Sheet.

 

Sub Macro1()
a = Sheets.Count
Sheets("Sheet1").Select
Sheets("Sheet1").Copy After:=Sheets(a)
End Sub

For renaming it, you have to specify cell reference which cell value should come as sheet name.

 

Logaraj Sekar's avatar
Logaraj Sekar
Iron Contributor
Aug 01, 2017

Hi horsteadjim

 

Use this one in Command Button

Sub Macro1()
a = Sheets.Count
ActiveSheet.Copy After:=Sheets(a)
End Sub

 

Resources