Greetings gurus and thanks in advance:

1: when copying and pasting formulas, is it possible to specify the "step"
the formula references will take between cells? Example: A formula in A1
references data in cell C1, when I copy the fomula to A2, I want the
reference to go to C3 (instead of C2).

2: If you have 2 workbooks, each with multiple sheets in them (Call them
Book1 and Book2). Each workbook has fomulas that call references from
sheets other than theeir own within their respectice workbooks. Can you
combine the 2 seperate workbooks into 1 workbook without the formula
references remaining attached to the original files? Example of what
happened to my formula:

=IF(ISBLANK('C:\Documents and Settings\Adam\Desktop\Battletech\COMBAT
TRACKER -OLD\[BattleTech - Combat Tracker
v1.0.xls]ROUNDS'!N68),"",'C:\Documents and
Settings\Adam\Desktop\Battletech\COMBAT TRACKER -OLD\[BattleTech - Combat
Tracker v1.0.xls]ROUNDS'!N68)