Related:
- Create a spreadsheet that captures data in sheet 1
- Fnaf 1 download pc - Download - Horror
- Gta 1 download - Download - Action and adventure
- Fnia 1 - Download - Adult games
- Create skype account with gmail - Guide
- Tentacle locker 1 - Download - Adult games
1 response
If you can stand by, I am getting ready to publish a HOW to on how to do exacty that, as EVERYONE wishes to use EXCEL as A DATABASE!
You do understand it is way easier to build a table, an entry form linked to the table, and report from the table, right?
Hang tight.
Here is a start to find the last line available on the sheet:
Here is a snippet that will select the entire row:
This will copy the row:
There ya go. There is a start. Let us know if you get stuck, or cannot reverse engineer the example codes to fit your model. I still think you will find using ACCESS to do what you are doing a lot easier, especially if you have no coding in VBA, as the learning curve will be the same!!!!
It's kind of fun to do the impossible! -Walter Elias Disney
You do understand it is way easier to build a table, an entry form linked to the table, and report from the table, right?
Hang tight.
Here is a start to find the last line available on the sheet:
X = Cells(ThisWorkbook.Worksheets(whatsheet).Rows.Count, 1).End(xlUp).Row
Here is a snippet that will select the entire row:
ActiveSheet.Range("A1").EntireRow.Select
Selection.Copy
ThisWorkbook.Worksheets(whatsheet).Select
This will copy the row:
Private Function copyRow(whatrow, whatsheet)
ActiveSheet.Paste Destination:=Worksheets(whatsheet).Range("A" & whatrow)
Application.CutCopyMode = False
End Function
There ya go. There is a start. Let us know if you get stuck, or cannot reverse engineer the example codes to fit your model. I still think you will find using ACCESS to do what you are doing a lot easier, especially if you have no coding in VBA, as the learning curve will be the same!!!!
It's kind of fun to do the impossible! -Walter Elias Disney
