Ive got a template which I currently fill in using data which is stored on two other spreadsheets (copy and paste).
I want to be able to populate the template automatically from the two spreadsheets.
When I receive the two spreadsheets, I save them in a folder on my C drive then open them up and manually copy the data from them to the Template. The data is always in the same location the received spreasheets.
What I would like to do is load my template, run a macro which prompts me for the location of the two spreasheets, after I enter it, I want the template auto populated using the macro.
How can I acheive this guys?