| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I copy formulas but using the same range each time I copy
I want to fill/copy a formula within a specific range but each time I try to
fill or sopy it changes the range it is supposed to looking in so I am getting errors. For example, Row 1 - =LOOKUP(J2,Sheet1!A2:A153,Sheet1!B2:B153) Row 2 - =LOOKUP(J3,Sheet1!A2:A153,Sheet1!B2:B153) But, if I just copy or fill I am getting the second row showing up as: =LOOKUP(J3,Sheet1!A3:A154,Sheet1!B3:B154) instead of as Row 2 above. I do not want to type the formula 500 times. Is there a solution? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
| copy worksheet to a new workbook with formulas .... but new file not point to old one | Excel Discussion (Misc queries) | |||
| How do I copy only cells with formulas in another row? | Excel Worksheet Functions | |||
| how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
Threaded Mode
