Copy and Paste

  • Thread starter Thread starter Troy
  • Start date Start date
I would bet it's because the formula is written with Relative references
rather than Absolute references......like A1 instead of $A$1.........

Vaya con Dios,
Chuck, CABGx3
 
This is true and it has be absolute or else conditional
sum won't work. Is there any solution.
 
Perhaps using RangeNames in your formula instead of directly coding in the
cell references would help........

Vaya con Dios,
Chuck, CABGx3
 

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

copying conditon formats with $ 12
Condition formats have $ sign problem copying 1
want to track time while paste value in multiple column of same roe 1
copy and past cells found by SUMPRODUCT 1
Time Sum in Excel 1
Problem with pasting value of a sum 3
Can't Copy and Paste in Excel 2003 0
how can i work on information copied off the web on a worksheet? 1

Back
Top