access course microsoft training - Copying formula to other worksheets

Hi Jean-Paul, Thanks for the post, I guess this is really an Excel question, so here goes, If the two spreadsheets are consistent (exactly the same) you can copy the cell that holds the formula and then paste it into the same cell in the new worksheet, it will retain its formula and relative reference. If however you just need it to look at the same cells in the original spreadsheet but provide the answer in the new spreadsheet, then in the target cell place an equals sign (=) and navigate to the cell with the formula, select it and press the enter key. Hope that works..