Elisha has attended:
Excel Intermediate course
Excel Advanced course
Quick Copying & Paste of Indifferent numbers in a large spreadsh
Good afternoon,
Is there a way to quickly Copy & Paste indifferent numbers without doing this individually for example:-
If I wanted to Copy the date in Cell A3 (01/04/2013) down to A22.
Then I wanted to Copy a new date in Cell A23 (07/08/2015) down to A40.
Then Copy another new date in Cell A41 (06/12/2016) down to Cell A55
Etc....
Is there a quicker way of doing so? As it would say so much time. The document has 7945 rows
Many thanks,
RE: Quick Copying & Paste of Indifferent numbers in a large spre
Hi Elisha,
Thank you for the forum question.
It is a difficult task to do because there is no pattern in what you need.
If you have Excel VBA knowledge it can be done writing a code and this will be much faster.
You do not have any "normal" Excel tools which can do it.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best 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
