update or record button

[larzep]

Hi guys,

Been searching everywhere on the net for help with writing up a macro. What I am trying to do is that I have 2 spreadsheets. One is a database spreadsheet (master) while the other is a template one. What I'm needing help with is a macro that i click on after filling out the template spreadsheet, it would copy various cells into my database spreadsheet and automatically inserts a new row + auto sort alphabetically (if not to much to ask)

It is for a quoting spreadsheet where after filling out the details, I would click on the update button and it would record all the details into the database spreadsheet.

VBA is just too confusing to follow but need something to properly record our records. Could someone please help thanks I don't know where to start.

[larzep]

Sorry here is the attached workbook examples that I am trying to build a macro for.

[royUK]

I would have the template sheet in the same workbook as the data sheet. The basic code that you need can be adapted from the Contact Form example here

If you want to maintain separate workbooks then you need to specify which workbook the code is writing to

[larzep]

Hey,

Thanks for that. I've manage to work it out but tweaking a few codes here and there. Got it to report the details of the template into the master as a report so that anyone can access and open up to see all the quotes we've done. One problem is that if someone tries to access the template file and click the macro via the shared network, it bugs out. How would you fix this? Atm all the files are located on my computer while the quote template are accessed by 2 other users from other workstations.