Benplayford
Technical User
Can anyone help me?
I want to create a template in excel, much the same way as a letter template can exist in word. What I mean is that once the file is selected you then have to input certain information fields which are then automatically entered into the correct areas of the workbook, thereby eradicating any duplication of entering the same in formation in two or more different places.
My VBA knowledge is limited so I was wondering if there was a quick way of doing this or whether someone could point me in the direction of how to start the process.
Responses would be welcome,
Thanks
I want to create a template in excel, much the same way as a letter template can exist in word. What I mean is that once the file is selected you then have to input certain information fields which are then automatically entered into the correct areas of the workbook, thereby eradicating any duplication of entering the same in formation in two or more different places.
My VBA knowledge is limited so I was wondering if there was a quick way of doing this or whether someone could point me in the direction of how to start the process.
Responses would be welcome,
Thanks