[Solved] Stop Auto-Increment when Copy/Pasting Formulas
Posted: Sat Aug 14, 2010 6:51 pm
Anyone know how I can stop the program from assuming I want different data when I copy paste? For instance, these are the formulas in Column A:
When I copy and paste into column B they turn into this, so the are all off by a letter:
I want it to end up with same ."B40", etc. as the first one.
Any ideas?
Thank you.
Code: Select all
='August 2010'.B40
='August 2010'.C40
='August 2010'.D40
='August 2010'.E40
='August 2010'.F40
='August 2010'.G40
='August 2010'.H40
='August 2010'.I40
='August 2010'.J40
='August 2010'.K40
='August 2010'.L40
='August 2010'.L40
Code: Select all
='August 2010'.C40
='August 2010'.D40
='August 2010'.E40
='August 2010'.F40
='August 2010'.G40
='August 2010'.H40
='August 2010'.I40
='August 2010'.J40
='August 2010'.K40
='August 2010'.L40
='August 2010'.M40
='August 2010'.M40
Any ideas?
Thank you.