Hi All,
I'm looking for a VBA code to complete my inputform.
I would like to when the macro is played, to cut the data in C9:Q9 in the sheet nammed inputform, to the next empty row in the sheet name selceted in cell C6.
So I would like to be able to choose which sheet the data is cut into by choosing the sheet name from a dropdown with the diffrent sheet names, eg. S01, S02, S03 etc.
So I found something like this I imagine would work.
But don't know how to adjust it to pick up the target sheet from cell C6 (in the inputform sheet)
Sub CutToSection()
Dim NextRow As Range
Set NextRow = Range("B" & Sheets("Sheet3").UsedRange.Rows.Count + 1)
Inputform.Range("C9:I14").Copy
Sheet3.Activate
NextRow.PasteSpecial Paste:=xlValues, Transpose:=False
Application.CutCopyMode = False
Set NextRow = Nothing
End Sub
Anyone who can help?
I'm looking for a VBA code to complete my inputform.
I would like to when the macro is played, to cut the data in C9:Q9 in the sheet nammed inputform, to the next empty row in the sheet name selceted in cell C6.
So I would like to be able to choose which sheet the data is cut into by choosing the sheet name from a dropdown with the diffrent sheet names, eg. S01, S02, S03 etc.
So I found something like this I imagine would work.
But don't know how to adjust it to pick up the target sheet from cell C6 (in the inputform sheet)
Sub CutToSection()
Dim NextRow As Range
Set NextRow = Range("B" & Sheets("Sheet3").UsedRange.Rows.Count + 1)
Inputform.Range("C9:I14").Copy
Sheet3.Activate
NextRow.PasteSpecial Paste:=xlValues, Transpose:=False
Application.CutCopyMode = False
Set NextRow = Nothing
End Sub
Anyone who can help?