B
Bengineer
I currently have several cells in a summary worksheet that reference values
in the cells of a data worksheet (='sheet#'!B3). This works well. I now have
another summary worksheet that I want to reference the adjoining cells of
this same data worksheet. I can easily copy and paste all of the currently
referenced values from the summary worsheet to the new summary worksheet, but
I would like to know if there is a easy way to now change all the copied
referenced cell values (in this new summary worksheet) to now reference the
cells in the adjacent column just to the right of the data worsksheet?
Example
Current copied value: (='sheet#'!B3)
Desired value: (='sheet#'!C3)
I need to do this several cells.
Thank you in advance for your assitance
Bengineer
in the cells of a data worksheet (='sheet#'!B3). This works well. I now have
another summary worksheet that I want to reference the adjoining cells of
this same data worksheet. I can easily copy and paste all of the currently
referenced values from the summary worsheet to the new summary worksheet, but
I would like to know if there is a easy way to now change all the copied
referenced cell values (in this new summary worksheet) to now reference the
cells in the adjacent column just to the right of the data worsksheet?
Example
Current copied value: (='sheet#'!B3)
Desired value: (='sheet#'!C3)
I need to do this several cells.
Thank you in advance for your assitance
Bengineer