fitz921322
New Member
- Joined
- Jan 15, 2014
- Messages
- 3
Basically as the title says. I have a formula that I'm trying to paste to a different cell, and I would like to keep the cells the same but change the sheet. I'm looking for quick way to do this besides having to go in and change the cells and sheets manually. Let me give you an example.
C11 = {=MIN(IF('Week 1'!C3:C11,"0",'Week 1'!B3:B11))}
I then copy and paste to C23 and this is what I get:
C23 = {=MIN(IF('Week 1'!C15:C23,"0",'Week 1'!B15:B23))}
Ideally I would like it to look like this:
C23 = {=MIN(IF('Week 2'!C3:C11,"0",'Week 2'!B3:B11))}
I'm looking for a quick fix because I have 320 formulas similar to this, that I'm going to have to copy 8x each to gather data from 8 separate sheets. That's a lot of tedious work.
Thanks!!
C11 = {=MIN(IF('Week 1'!C3:C11,"0",'Week 1'!B3:B11))}
I then copy and paste to C23 and this is what I get:
C23 = {=MIN(IF('Week 1'!C15:C23,"0",'Week 1'!B15:B23))}
Ideally I would like it to look like this:
C23 = {=MIN(IF('Week 2'!C3:C11,"0",'Week 2'!B3:B11))}
I'm looking for a quick fix because I have 320 formulas similar to this, that I'm going to have to copy 8x each to gather data from 8 separate sheets. That's a lot of tedious work.
Thanks!!