LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default freezing formulas when cells move

I have an inventory spreadsheet where I compare the values in 2 columns to
make sure they equal 0. If the 2 values in each row to equal 0 when I
subtract one from the other (A23-B23), this lets me know that the inventory
price has not changed. However, because the new inventory list may have more
or less items that the current inventory list, I have to move cells up or
down to align the similar inventory parts.

I want to put a column to the side where I subtract current inventory value
from new inventory value and get a result of 0. But when I move one column up
or down, the formula changes accordingly. I want to be able to freeze the
formula column so that it always says "A23-B23" even when I move A23 up or
down.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you move cells with a formula DoriCAFL Excel Worksheet Functions 1 March 21st 06 08:27 PM
Copy/Paste how to avoid the copy of formula cells w/o calc values Dennis Excel Discussion (Misc queries) 10 March 2nd 06 10:47 PM
Formula to Sum Cells that Hold If Formulas Brad Larsen Excel Worksheet Functions 2 February 21st 06 07:26 PM
Freezing cells Qban Excel Discussion (Misc queries) 1 December 11th 05 03:48 PM
In Exel 2000, stop the blank cells (with formulas) from printing. tonyoc Excel Discussion (Misc queries) 1 December 10th 04 12:38 AM


All times are GMT +1. The time now is 07:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"