Duplicating data to multiple pages of the same wookbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I enter data on pg1 of a wooksheet & have SOME of it automatically enter
on pg2?
 
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
 
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..
 
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")
 
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
 
Frank has given me the answer.
Thanks Frank - I appreciate it.
Great stuff
 
:-), 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..
 
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
 
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?
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

getting rid of the second wookbook version 3
summary sheet across multiple sheets 3
passing array of structs to unmanaged code 2
Need a Macro 3
Deleting data but keep formulas/formatting. 3
Range name copy Macro 1
Change properties of a multipage 5
Pivot table for reporting sales performance 2

Back
Top