Standard entry from another worksheet

[bartmanekul]

I just need a pointer for this one.

Tried googling, but think I'm putting the wrong terms in.


I have a template spreadsheet, which people use for scoring.

This data needs to go into a table, and although I've made it as easy as possible - set it up so they only have to copy and paste a single line into the data table, I'd still much rather not have them in the table in the first place.

So first:

Is it possible to include a button for them to press on this template sheet which will add the results to a new row in a data table in another spreadsheet?

If so, how do I do this? I've never touched VBA, though if there's existing code I can likely modify to my needs.

Again, if possible, is there anything that can be done to stop someone from adding an entry twice (i.e. they press the button again)?

Thanks in advance.

 

[welshgasman]

Did you ever resolve this.?

DatabaseName = Cells(Rows.Count, 1).Value

 

[dmt32]

Did you ever resolve this.?

DatabaseName = Cells(Rows.Count, 1).Value

Golly, I thought this was resolved long time ago

All OP needed to do was add a button to template workbook & call the function

Private Sub CommandButton1_Click()
    Dim DatabaseName As Variant
    DatabaseName = BrowseFile
    If DatabaseName = False Then Exit Sub
    Cells(Rows.Count, 1).Value = DatabaseName
End Sub

Dave

 

[welshgasman]

My interpretation was that the o/p needed to change the location of the database workbook?
If I understood your code correctly, that would just mean changing the value in the range I posted earlier.?

 

[dmt32]

The function calls the GetOpenFilename dialog which is used to get the path & filename to the database workbook.

This string is stored at the cell address & is referenced by SaveTemplateData code.

Dave