GS wrote:

Thanks Garry, I'll try both of those approaches.

I realised after posting that my query might sound a bit strange. I
should have reminded others of the following background.

I write macros with a program called Macro Express Pro, using
hundreds
of them to improve PC productivity in and between many applications.
The
macro prompting my post is intended to automatically copy about 40
values from cells in a worksheet SingleWalk.xlsm into a worksheet
WalkIndex.xlsm, which is the sheet in my question. (There are
hundreds
of sheets to be copied into WalkIndex.)

At the moment I have to include user interaction within my macro,
asking
for *manual* entry of the current row number.

Yes, I recall that you use ME and so did check it out!

Here you'll only get Excel-based solutions so we don't need to know ME
is being used at your end.

I prefer a cleaner (and easily distributable) approach...

store the source data files in 1 folder and use ADODB from my Excel
project file to read all the sought data in without having to open
the source files!

..so others do not require the external dependency (ME) to do the task.

I too would far prefer a VBA-only solution, but my skills are not up to
it!

Expanding on my earlier description:
https://dl.dropboxusercontent.com/u/...el-Copy-02.jpg

I've written and tested the macro for the first two of the 40 cells, but
it's clear that it's a tedious exercise, And I expect quite slow to run,
even on one worksheet X.

Could you amplify on "...use ADODB from my Excel project file" please?
Is this something I can look at somewhere?

--
Terry, East Grinstead, UK