I have a spreadsheet, from which I need to copy the contents of a cell
to multiple destinations (419 to be exact). I'm hoping there's an easy
way to do this, and that I don't have to copy/paste 419 times! Thanks.

What multiple destinations? Other sheets? Other files? Other
applications? HTH Otto
"Scratch" wrote in message
ps.com...
I have a spreadsheet, from which I need to copy the contents of a cell
to multiple destinations (419 to be exact). I'm hoping there's an easy
way to do this, and that I don't have to copy/paste 419 times! Thanks.

Sorry - other Excel spreadsheets.


Otto Moehrbach wrote:
What multiple destinations? Other sheets? Other files? Other
applications? HTH Otto
"Scratch" wrote in message
ps.com...
I have a spreadsheet, from which I need to copy the contents of a cell
to multiple destinations (419 to be exact). I'm hoping there's an easy
way to do this, and that I don't have to copy/paste 419 times! Thanks.

Based on the detailed response, Yes, you will need to copy to each location.

why not start now. <g

--
Regards,
Tom Ogilvy


"Scratch" wrote:

Sorry - other Excel spreadsheets.


Otto Moehrbach wrote:
What multiple destinations? Other sheets? Other files? Other
applications? HTH Otto
"Scratch" wrote in message
ps.com...
I have a spreadsheet, from which I need to copy the contents of a cell
to multiple destinations (419 to be exact). I'm hoping there's an easy
way to do this, and that I don't have to copy/paste 419 times! Thanks.

depends on where the multiple locations are.

If there are multiple sheets in a single workbook, then you could probably
do all the sheets at once by grouping the sheets.

Also, even if you had to do it 419 times, if you use a macro, it does all
the heavy lifting. But specific information would be needed to say.

--
Regards,
Tom Ogilvy


"Scratch" wrote:

I have a spreadsheet, from which I need to copy the contents of a cell
to multiple destinations (419 to be exact). I'm hoping there's an easy
way to do this, and that I don't have to copy/paste 419 times! Thanks.

I supplied more detail (above), but I also wanted to mention that, if
it makes a difference, all the files are located on a server. Thanks.


Tom Ogilvy wrote:
depends on where the multiple locations are.

If there are multiple sheets in a single workbook, then you could probably
do all the sheets at once by grouping the sheets.

Also, even if you had to do it 419 times, if you use a macro, it does all
the heavy lifting. But specific information would be needed to say.

--
Regards,
Tom Ogilvy


"Scratch" wrote:

I have a spreadsheet, from which I need to copy the contents of a cell
to multiple destinations (419 to be exact). I'm hoping there's an easy
way to do this, and that I don't have to copy/paste 419 times! Thanks.

You say that all 419 files have the same name and are all in different
folders. Let's call those folders sub-folders. Are all those sub-folders
under one folder? HTH Otto
"Tom Ogilvy" wrote in message
...
depends on where the multiple locations are.

If there are multiple sheets in a single workbook, then you could probably
do all the sheets at once by grouping the sheets.

Also, even if you had to do it 419 times, if you use a macro, it does all
the heavy lifting. But specific information would be needed to say.

--
Regards,
Tom Ogilvy


"Scratch" wrote:

I have a spreadsheet, from which I need to copy the contents of a cell
to multiple destinations (419 to be exact). I'm hoping there's an easy
way to do this, and that I don't have to copy/paste 419 times! Thanks.

Otto, yes, they are all located under the one folder, but not directly
under. It's kind of complicated to explain, but they all share the
same root folder. Thanks.


Otto Moehrbach wrote:
You say that all 419 files have the same name and are all in different
folders. Let's call those folders sub-folders. Are all those sub-folders
under one folder? HTH Otto
"Tom Ogilvy" wrote in message
...
depends on where the multiple locations are.

If there are multiple sheets in a single workbook, then you could probably
do all the sheets at once by grouping the sheets.

Also, even if you had to do it 419 times, if you use a macro, it does all
the heavy lifting. But specific information would be needed to say.

--
Regards,
Tom Ogilvy


"Scratch" wrote:

I have a spreadsheet, from which I need to copy the contents of a cell
to multiple destinations (419 to be exact). I'm hoping there's an easy
way to do this, and that I don't have to copy/paste 419 times! Thanks.

Everything on your hard drive shares the same root folder. It may be
complicated to explain but Excel will need to know exactly where each and
every file is located (full path), so to get any help with a macro for this
job, you will have to provide all the paths. If all the files were located
in folders that were all under one folder, it would sure make your life
easier. HTH
Otto
"Scratch" wrote in message
oups.com...
Otto, yes, they are all located under the one folder, but not directly
under. It's kind of complicated to explain, but they all share the
same root folder. Thanks.


Otto Moehrbach wrote:
You say that all 419 files have the same name and are all in different
folders. Let's call those folders sub-folders. Are all those
sub-folders
under one folder? HTH Otto
"Tom Ogilvy" wrote in message
...
depends on where the multiple locations are.

If there are multiple sheets in a single workbook, then you could
probably
do all the sheets at once by grouping the sheets.

Also, even if you had to do it 419 times, if you use a macro, it does
all
the heavy lifting. But specific information would be needed to say.

--
Regards,
Tom Ogilvy


"Scratch" wrote:

I have a spreadsheet, from which I need to copy the contents of a cell
to multiple destinations (419 to be exact). I'm hoping there's an
easy
way to do this, and that I don't have to copy/paste 419 times!
Thanks.

Otto,

Thanks. I know they all share the same root. Maybe I should have used
"branch" instead. :) I'll try to break it down this way:

On the server there is a folder called "Files"

"Files" contains folders 33, 34, 35, 36 and so on

In each of these folders there are subfolders 33-a, 33-b, 33-c, 34-a,
34-b, 34-c and so on

In each of these folders is another folder which is called the same in
all of the folders - "Parts"

In "Parts" is a file called fileA

As I mentioned, I need to copy a single cell in another Excel workbook,
fileB, into each of these files called fileA. If I have to call the
full path for each file (all 419) into a macro, it certainly seems like
it would be easier, unfortunately, to just copy and paste 419 times.


Otto Moehrbach wrote:
Everything on your hard drive shares the same root folder. It may be
complicated to explain but Excel will need to know exactly where each and
every file is located (full path), so to get any help with a macro for this
job, you will have to provide all the paths. If all the files were located
in folders that were all under one folder, it would sure make your life
easier. HTH
Otto
"Scratch" wrote in message
oups.com...
Otto, yes, they are all located under the one folder, but not directly
under. It's kind of complicated to explain, but they all share the
same root folder. Thanks.


Otto Moehrbach wrote:
You say that all 419 files have the same name and are all in different
folders. Let's call those folders sub-folders. Are all those
sub-folders
under one folder? HTH Otto
"Tom Ogilvy" wrote in message
...
depends on where the multiple locations are.

If there are multiple sheets in a single workbook, then you could
probably
do all the sheets at once by grouping the sheets.

Also, even if you had to do it 419 times, if you use a macro, it does
all
the heavy lifting. But specific information would be needed to say.

--
Regards,
Tom Ogilvy


"Scratch" wrote:

I have a spreadsheet, from which I need to copy the contents of a cell
to multiple destinations (419 to be exact). I'm hoping there's an
easy
way to do this, and that I don't have to copy/paste 419 times!
Thanks.