| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERATE
I AM USING THE OFFSET FUNCTION FOR LOOKING UP CERTAIN INFORMATION IN ANOTHER
WORKSHEET. THIS INFORMATION IS CONTAINED WITHIN A RANGE OF FIELDS EG: A20:A38 WHEN I COPY THIS FORMULA IT AUTOMATICALLY UPDATES THE FIELDS EG: A21:A39 AND SO ON. HOW DO I TURN THIS OFF. I WANT IT TO STAY AT A20:A38. I AM USING EXCEL 2002. I HAVE TRIED EVERYTHING I CAN THINK OF AND GETTING VERY FRUSTRATED! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERATE
SHELL -
ABSOLUTE REFERENCE (INSTEAD OF RELATIVE): $A$20:$A$38 - MIKE "SHELL" wrote in message ... I AM USING THE OFFSET FUNCTION FOR LOOKING UP CERTAIN INFORMATION IN ANOTHER WORKSHEET. THIS INFORMATION IS CONTAINED WITHIN A RANGE OF FIELDS EG: A20:A38 WHEN I COPY THIS FORMULA IT AUTOMATICALLY UPDATES THE FIELDS EG: A21:A39 AND SO ON. HOW DO I TURN THIS OFF. I WANT IT TO STAY AT A20:A38. I AM USING EXCEL 2002. I HAVE TRIED EVERYTHING I CAN THINK OF AND GETTING VERY FRUSTRATED! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERATE
USE ABSOLUTE REFERENCES!
$A$20:$A$38 CLIFF EDWARDS! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERATE
Please don't yell at us... typing in all caps are perceived as
yelling. Cliff Edwards |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERA
Thank you very much, you have saved me wasting hours of my time with such an
easy solution =] "Mike Middleton" wrote: SHELL - ABSOLUTE REFERENCE (INSTEAD OF RELATIVE): $A$20:$A$38 - MIKE "SHELL" wrote in message ... I AM USING THE OFFSET FUNCTION FOR LOOKING UP CERTAIN INFORMATION IN ANOTHER WORKSHEET. THIS INFORMATION IS CONTAINED WITHIN A RANGE OF FIELDS EG: A20:A38 WHEN I COPY THIS FORMULA IT AUTOMATICALLY UPDATES THE FIELDS EG: A21:A39 AND SO ON. HOW DO I TURN THIS OFF. I WANT IT TO STAY AT A20:A38. I AM USING EXCEL 2002. I HAVE TRIED EVERYTHING I CAN THINK OF AND GETTING VERY FRUSTRATED! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COPYING OFFSET FORMULA WITHOUT THE DATA RANGE CHANGING-DESPERA
Thank you very much, you have saved me wasting hours of my time with such an
easy solution =] "ward376" wrote: USE ABSOLUTE REFERENCES! $A$20:$A$38 CLIFF EDWARDS! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a vlookup formula without changing the data range? | Excel Worksheet Functions | |||
| Copying a named range with a changing cell reference | New Users to Excel | |||
| named range in sum formula (indirect, offset, worksheet name) | Excel Worksheet Functions | |||
| Formula to find last value in a range & then offset | Excel Worksheet Functions | |||
| Copying a formula and changing ONE value... | Excel Worksheet Functions | |||
Linear Mode
