98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Cross workbook cell transfers
Cross workbook cell transfers
Resolved · Low Priority · Version 365
Fri 14 Jul 2023, 10:49Delegate Joshua said...
Joshua has attended:
Excel Intermediate course
Excel Advanced course
Cross workbook cell transfers
At the moment I am using a macro to copy the lines on workbook 1 and paste in workbook 2 and then transforming the data in workbook 2 by cutting out of the first 4 columns and pasting them in their relevant column is there a better way of doing this ? (All of this is done in the same macro) workbook 2 is also generated by the same macro it does not exist before I run the macro.
Fri 14 Jul 2023, 11:51Trainer Jens said...
RE: Cross workbook cell transfers
Hi Joshua,
Thank you for the forum question.
Everything can be automated in Excel. My Excel philosophy is "never do manual work in Excel".
So yes you have a better solution, but you will need to write VBA codes to fully automate your task. I do not know, if you have a good knowledge of VBA and can write the codes.
The Power Query tool in Excel could be another solution to fully automate your task. Power Query to me is the most important Excel tool and can save most Excel users huge amount of time.
You have been on our Excel Advanced course. The macro recorder is a part of this course. You can try to record the steps you are doing in workbook 2, but make sure you record it from workbook 1.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Fri 21 Jul 2023: Automatically marked as resolved.
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:Selecting blank cells within a range of dataSelect the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks. |
