R
rspoo
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.
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.