If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
copying absolute formulas
Hi, I have a large number of formulas in a table. All seven days of the week are represented. Monday has the correct formulas (and includes absolute references (row only). If I copy the formulas to Tuesday the wrong columns are now refereced. Instead of going thorough hundreds of formulas, is there a way I can exactly copy the formula so all references remain in tact? Thanks, Matt |
#2
|
|||
|
|||
copying absolute formulas
MJKelly wrote:
Hi, I have a large number of formulas in a table. All seven days of the week are represented. Monday has the correct formulas (and includes absolute references (row only). If I copy the formulas to Tuesday the wrong columns are now refereced. Instead of going thorough hundreds of formulas, is there a way I can exactly copy the formula so all references remain in tact? Thanks, Matt Look at the help file under Absolute Reference. If that doesn't help you, post an example of one of your formulas, where it is located on your worksheet, where you want the copy located, and what you want the copy to look like. |
Thread Tools | |
Display Modes | |
|
|