how can I setup a reference for a column of data to another sheet.

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

Guest

I have 24 sheets broken down from one - it is done this way for the group of
people working with it. I want to take the master sheet and use one specific
column that I can update 740 cells (this changes daily). The data will then
show on the appropriate sheet (there is a one to one corrilation). I know
how to reference that sheet with a formula with the sheet name, row & column
and it works, but I don't think I have to up the formula with the next row by
hand. Is ther a way to reference a certain amount of cells like a copy and
paste, but not c & p since all I want to do is only update my sheet. I can't
find anything straight forward for referencing a group of cells to another
group of cells with multiple data in multiple sheets.
 
Hi
if you have a formla such as
='sheet1'!A1
just copy this formula
 
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

using the =page! feature to transpose a row to column 0
Match and delete rows on two different sheets from reference numbers 4
Dependent drop down dynamic range formula, off sheet. 7
formulas copying from sheet to sheet 6
Formula for Next Sheet and Every Other Cell 12
How can I reference a worksheet in a formula based on a cell value 2
move a row of data from one work sheet to another using a formula 1
Losing rows that reference data from another worsheet 1

Back
Top