Send cell data to next available blank row on another WB via Command button

So im a bit of a noob with macros although im trying my best to learn.

With the help of some of the amazing clever members on here ive managed to learn a few basics including Command buttons that autosave as cell values etc.

Now ive been thinking of asking about this next query for a while but always thought it was not possible, but now as im learning new things i wonder if it is possible.

So currently when i raise an invoice or quotation etc i have to manually record that files specifics in my main WB. Example - I complete an invoice and then manually record the transaction on the next blank row available on the sales page of my main WB. Is there a way to create a command button that upon completing the invoice & once clicked collects the relevant information from the relevant cells in the invoice WB and sends this data to the corresponding cells in the next available BLANK row on the sales page negating the need to manually enter this data?

My gut feeling tells me this is above my understanding of macros but i cant shake the curiousity. Further more i suppose if this is possible, but then the user amends that particular invoice, when sending the data to the main WB it will need to UPDATE the existing record rather than creating a new one in the next available blank row. I hope this makes sense?? Someone please put me out of misery and tell me this cant be done?

If it can be done i suppose i am looking for a template to do this, where i can enter the relevant cells and filepaths my self.

Thanks in advance

Originally Posted by Richard Buttrey

Hi,

Yes this is a fairly common and simple task with VBA.

If you upload your workbook containing your invoice template and sales record data sheet I'll happily add the functionality for you.

The general approach I use is to keep a working row of cells above the database of sales records and link each of those cells back to the invoice template. Then when you click the button to update the Sales database the macro simply copies the working row and pastes it back as values to the next available row on the data sheet.

Editing an existing record just requires another macro to extract the current data from the Sales data back to the invoice template, or pehaps a mirror of it which can then be edited and then updated back to the Sales data.

Thanks for your reply, does this work if they are 2 seperate WB's?

Also, as these are live (in use) WB's they contain sensitive data if i take the time to send blank copies can i simply copy and past the changes over or is it not as simple as that?