98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Transferring data from one spreadsheet to another | Excel forum
Transferring data from one spreadsheet to another | Excel forum
Resolved · Low Priority · Version 2003
Jenna has attended:
Excel Consulting course
Transferring data from one spreadsheet to another
How can you pull text from one spreadsheet to input into another eg. driver report run each week, comments added to report throughout week, how can you transfer comments onto the next report run without searching for each individual driver?
RE: transferring data from one spreadsheet to another
Hi Jenna
Thank you for your question
The simplest method would be to to record a macro of a copy and paste exercise from one woeksheet to another. The exact mechanics of this are however difficult to describer without seeing the workbook in question.
If you could email me a copy with a written description of the data that you want to transfer, then I will investigate further.
My email address is stephenATstl-training.co.uk
regards
Stephen
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Move data worksheet to worksheetTo move data from one worksheet to another, highlight the data. |