Duplicating data to multiple pages of the same wookbook

D

DarrellK

Can I enter data on pg1 of a wooksheet & have SOME of it automatically enter
on pg2?
 
J

JulieD

Hi

Depending on what you're really after - the following in a cell in Sheet 2
will put the data from cell A1 in sheet 1 into it.

=Sheet1!A1

Cheers
JulieD
 
B

Bon Rouge

Hey there,
This is useful for me, but if I have the name of a sheet in a cell
could I use that somehow instead of the actual name of the cell? (s
that I don't have to write the name twice).
I hope you understand what I mean..
 
F

Frank Kabel

Hi
you could use INDIRECT. e.g. if cell B1 stores the sheet
name and you want to get cell X1 from this sheet try:
=INDIRECT("'" & B1 & "'!X1")
 
I

icestationzbra

provide more detail as to what you want to do (as in, where are yo
going to store the sheet number and cell number where the value i
going to end up at, and where does the value originally reside) an
why. layout of the sheet will help.

sometimes doing things simply will help more than doing i
artistically, as i found out while trying to solve this query. in an
case, you will still have to enter some sheet number and cell numbe
some place, even in the macro if it is needed
 
I

icestationzbra

:), seems like more than the OP, i was the one who was trying to thin
of a profound answer. the answer was really simple... pretty duh o
me..
 
B

Bon Rouge

I was wondering if it's possible to somehow put a formula in the sam
cell of every worksheet - I have about 200 in about 4 or 5 workbooks
without actually opening every one...?
I'm guessing that it's not possible, but I'm kind of new to this. (I'v
been using Excel for a long time for my business, but I've had the mos
basic sheets - now there are a few things I need to do which are mor
complicated).

Thanks in advance for any help
 
M

Myrna Larson

You can't modify a workbook without opening it. But you could automate this
process with a VBA macro. Have you used VBA at all?
 
B

Bon Rouge

OK, I can't modify a workbook without opening it, but could I modify al
of the sheets in a workbook at the same time - as I said, I have abou
200 sheets in... actually, in 6 workbooks.

No, I haven't used VBA - sounds useful. How could I do this with VBA?

Thanks for the help
 
B

Bon Rouge

I think I've found the answer to my own question...

If I copy all sheets from all the books into one book and then selec
all sheets in the big book I can insert anything into the same cell o
every sheet.

I found this out far too late (after going through every page to ad
the same formula in the same cell... D'oh!).
Oh well, you live and learn...

Thanks for your help
 
Top