how do i copy a formula with different cell reference?

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

Guest

how do i, by copying a formula (with cell reference) 3 rows down but the cell
reference in the formula itself refers 20 rows down? i'm using office 2003.
 
If there is a calcuable pattern, then you design the formula to calculate
where it should reference using something like Offset and some math.

If not, then copying the formula would not be practical. You would
reconstruct it.

--
Regards,
Tom Ogilvy

wisonn said:
how do i, by copying a formula (with cell reference) 3 rows down but the cell
reference in the formula itself refers 20 rows down? i'm using office
Click to expand...
2003.
 
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

Insert Row also adds formulas and moves cursor 2
Problem with a loop and column references 27
Named Range maker code 9
How do I reference cells in CF formula within loop 2
Copy Formula Issue 5
Fill down Formula Automatically 2
Array with many cells from a row but not in order or together 11
Excel VBA 1

Back
Top