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