How to Create Static numbers from a live formula

**john dalton** · 10-07-2011, 05:22 AM

I have a running stock column as part of a stock control sheet and I need the stock movement lookup sheet that displays the current running stock beside each stock line to freeze that particular result when the stock line has an items taken so that the user can quickly check what stock was on shelf at the time the item was taken, then the next time the stock is taken again it is frozen again agianst that line and so on.

The formula that displays the result is -

=IF(ISNA(VLOOKUP($F5,data,7,FALSE)),"",VLOOKUP($F5,data,7,FALSE))

Thanks in advance

JD

**6StringJazzer** · 10-07-2011, 11:02 AM

This requires some VBA. It's not incredibly complicated but you would need to provide more details, ideally attach your workbook. In particular you need to define how you can tell "when the stock line has an items taken". The macro would detect when that condition occurs, then populate the cell by effectively calculating the value in the same way that the formula does.

How to Create Static numbers from a live formula

LinkBack

Thread Tools

Rate This Thread

Display

How to Create Static numbers from a live formula

Re: How to Create Static numbers from a live formula

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions