I need to copy a group of connected cells from page one of a notebook to 200
pages that follow. These pages are all in the same file.
I need to copy a group of connected cells from page one of a notebook to 200
pages that follow. These pages are all in the same file.
Hi John
one way to do this (and please try it on a copy of your workbook first) is
to select the group of cells you want to copy, then right mouse click on the
sheet tab and choose
select all sheets
then choose
edit / fill / across worksheets
all
OK
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"John Q" <John [email protected]> wrote in message
news:[email protected]...
>I need to copy a group of connected cells from page one of a notebook to
>200
> pages that follow. These pages are all in the same file.
By 'notebook' we'll assume you mean 'workbook.' By pages we'll assume you
mean 'worksheets' and, presumably, you mean in the same workbook, right?
Assume your source sheet is the first sheet in the workbook, and you want to
copy the 'connected cells' to the following 200 sheets
1) Copy the cells,
2) select the next sheet
3) select the cells where you want to paste
4) while holding the Shift key down, select the LAST sheet of the 200
5) Paste the copied cells
"John Q" wrote:
> I need to copy a group of connected cells from page one of a notebook to 200
> pages that follow. These pages are all in the same file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks