Modifying column references

R

rsbyers01

Joined
Jul 10, 2009
Messages
1
Reaction score
0
How can I copy a formula in Sheet 1 A1 that reads =Sheet 3!C$3-Sheet3!D$3 from cell A1 to cell A2 and automatically change the column reference 2 columns to the right so it looks like like =Sheet3!E$3-Sheet3!F$3 after it is copied to
A2?

thanks for your help!
 

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

Dsum Help 0
Scrabble Value calculation for Welsh words 0
Cell Reference 1
Countif gone wrong 2
sheet formulas and strings 4
how do i make a sheet number relative in a formula 2
Can Tab name in worksheet change automatically by referencing a ce 2
Look up a text value then count records < a date 3

Top