copy selected data from a workbook to another spreadsheet each time I run a template

Hello
It would be great if someone could help me with this. I have no real experience with macros and rely on sites like this to find the code I need. That said I cant find exactly what I'm looking for this time....

I have an excel template which I use for estimating. I would like to copy selected data from that workbook to another spreadsheet each time I run the template. I have organised the data I want into one row on my template and currently I manually select, copy and paste this into the next available row on a spreadsheet called "Estimate List". I have managed to record a macro to do this but it always overwrites the row which I use when I record the macro. I also have problems with whether the Workbook containing "Estimate list" is open or closed when I try to run the macro.

Thanks in advance for any suggestions you might have.

Cheers Mick

PV Potential calculator example.xlsm

Thanks Anthony it helps a lot.
I'm attaching the template and a Blank version of "Estimate List" When I run your macro it tries to save the template which is open. it selects the data which I want t copy but doesn't open "Estimate List" or attempt to past the data to that book.
I'm confident that it's something I'm doing wrong so if you can have a look I'd appreciate it. Its not urgent but something I'd like to resolve sometime.
Thanks Again

Mick

Cheers Anthony I've been away so I haven't had a chance to try this yet, I'll let you know how it works.

That works a treat now that I've sorted out my dodgy filename's (&Extensions)

Thanks again

Mick

Hi Mick
Is there a reason you want to paste as a link because my understanding is that in the PV Calculator workbook that the data in Range("A34:G34") will change. As a result the data in the Estimate list will change so it will always reflect the data in the Calculator workbook and not necessarily the data that was copied across. Does that make sense? Anyway to paste as a link

Please Login or Register  to view this content.

However as I say this will lead to the last rows of data in the Estimate list to be the same value as the current values in the Calculator workbook. It may look like the path to the Calculator workbook does not show in the Formula Bar in the Estimates sheet however once you shut the Calculator workbook the path will show up in the formula bar. The main reason to have links to workbooks is for example a master Price List where you just change the prices in one workbook and this will be reflected in the linked workbook. Anyway see if this is what you are after.

Hope this helps.
Anthony
“Confidence never comes from having all the answers; it comes from being open to all the questions.”
PS: Remember to mark your questions as Solved once you are satisfied. Please rate the answer(s) by selecting the Star in the lower left next to the Triangle. It is appreciated”

Thanks Anthony
That is exactly what I wanted. I understand your comments about changing the last row on the log sheet. I use the macro in a template so I'm always starting with the next No invoice etc. Part of the data transferred is the value of the estimate. its not unusual for me to change estimate's a number of times so this way the data on the log sheet should always be correct? I use a button on the template to run the macro and taking your comments on board I have now set it so the button is deleted once it is used once to prevent me accidently clicking on it and adding the data secondly.
Thanks again for all your help, I included the final code which you might find easier to understand than my ramblings.....

Please Login or Register  to view this content.