I have created a worksheet containing a register of transactions, and I wish to be able to generate a receipt as the transactions are entered using a word template that will pick up the contents of data entered within the row in focus.
I hope to be able to use a quick method (ie macro) to have the spreadsheet take the data with in the row in focus and automatically populate the associated word template with the relevant data. I could then just print the receipt.
I am hoping not to have to close Excel and generate a list to select from within Word as it will always just be the current row that I want to print the receipt for.
Thanks for any ideas and assistance.
I hope to be able to use a quick method (ie macro) to have the spreadsheet take the data with in the row in focus and automatically populate the associated word template with the relevant data. I could then just print the receipt.
I am hoping not to have to close Excel and generate a list to select from within Word as it will always just be the current row that I want to print the receipt for.
Thanks for any ideas and assistance.