Quick Copying & Paste of Indifferent numbers in a large spreadsh

Resolved · High Priority · Version 2010

Tue 10 May 2016, 12:52 Delegate Elisha said...

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,

Wed 11 May 2016, 09:41 Trainer Jens said...

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

Wed 18 May 2016: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Status Bar Functions

When using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet.

However, if a range of cells, containing numbers, is highlighted, and then a right-mouse click is performed at the bottom right side of the status bar, then the result of those functions will be displayed.

View all Excel hints and tips