I am stuck tring to move data from a data entry, spreadsheet, to a database spreadsheet, and to a monthly report spreadsheet.
I am stuck tring to move data from a data entry, spreadsheet, to a database spreadsheet, and to a monthly report spreadsheet.
Here is a bare-bones way to use a macro to get data from one worksheet to another:
Sub dataInput()
'Sheet to get data from
sourceSheet = "SheetName"
'Destination sheet
destinationSheet = "SheetName"
'Get the next empty row
NextRow = Sheets(destinationSheet).Range("A" & Rows.Count).End(xlUp).Offset(1).Row
' Input the data
'Imported value.
Sheets(destinationSheet).Range("A1").Value = Sheets(sourceSheet).Range("A1").Value
End Sub
Replace SheetName for the sourceSheet variable with the name of the worksheet where you want to get the data. Replace the same thing for the destinationSheet variable with the name of the worksheet where you want to put the data.
Range("A1") contains the reference of the cell where you want to get the data from and where you want to store it.
The macro is pretty straight-forward but you will have to put a new line for each piece of data that you want to copy. You could do a full-row copy/paste, but some of your worksheets looked like they didn't have the same columns in the same order, in which case, you will have to copy each cell of data individually.
Try this macro out on a new workbook first until you understand how it works and then tweak it for your situation and copy it to the file with data once you get everything working.