Trying to get a value to remain copy into a cell and remain the same when condition met

**shadowlost** · 05-20-2013, 01:25 PM

I have an A/R spreadsheet I'm working on that needs to be updated constantly. I've searched around, but I'm not sure I'm unable to load the file for privacy reasons. In essence, here is what I'm looking at:

T73 is calculating the amount Due from multiple clients per other formulas.

the following cells in the row are by Month. U73 = amount due for January, V73 = amount due for February, and so on. These stay blank until "Final" is entered.

What I need is that once U72 says "Final", that U73 = the amount of T73 and not change again. So that when V72 says Final, V73, the February number, will = T73 and then not change. T73 will be constantly changing as numbers change, but I want to 'freeze' those numbers at the end of the month. (but it can't be done by a calendar as it depends on when the numbers are added in.)

(Edited: Oh wow. Sorry about the weird header. I just re-read that. That's what I get for trying to do something like this while on the phone!)

**nemo74** · 05-20-2013, 02:21 PM

upload a small sample file with DUMMY data in it.

we don't need to see any actual data, just data. Also include your desired outcome.

Thanks

**shadowlost** · 05-20-2013, 02:44 PM

Enclosed.. I used the actual T & U columns so you may need to scroll over

**nemo74** · 05-21-2013, 11:02 AM

Sorry for the delay, I only have time to help while at work.

So here put in the sheet you need it on. Enter Final in the cell and doubleclick it

Please Login or Register  to view this content.

Let me know how it goes.

**shadowlost** · 05-21-2013, 02:25 PM

Close! Hm. Should have mentioned some other things I suppose. I didn't realize this would be so complicated! I was hoping it was more of a simple answer than this.

1) The value will not always be in T73. It will always be in Column T, but it will move down as items are added above it. ...

Ok. I'll upload load the actual one after a bunch of editing out...

**nemo74** · 05-21-2013, 02:45 PM

Where is the Final word going to go in this new sheet? Will that move down as well? Why not move T73 to a spot that won't move?

**shadowlost** · 05-21-2013, 03:19 PM

Because I have a lovely boss that wants it this way?

If it's not really doable, just let me know. I can continue to manually update it. And one of these days.. I really will learn VB! I keep promising myself!

Currently I'm using in row 73 for May -> =IF(Y11="Final", "UPDATE", "") to remind me to manually update it. Right now Final will rest in row 11, but it will move at some point.

**nemo74** · 05-22-2013, 01:23 PM

Holy cow!

Shadowlost, your request has been a learning experiance for me. I'm a big VBA rookie, but helping people helps me so its win win. Please try the following code in the sheet you have all your data in. For that top row were you put final, just double click it and the code should do the rest. It works fine on your sample sheet so let me know if you hit any snags.

This has been good fun!

Please Login or Register  to view this content.

**shadowlost** · 05-24-2013, 11:47 AM

Yay! It seems like it's working

Trying to get a value to remain copy into a cell and remain the same when condition met

LinkBack

Thread Tools

Rate This Thread

Display

Trying to get a value to remain copy into a cell and remain the same when condition met

Re: Trying to get a value to remain copy into a cell and remain the same when condition me

Re: Trying to get a value to remain copy into a cell and remain the same when condition me

Re: Trying to get a value to remain copy into a cell and remain the same when condition me

Re: Trying to get a value to remain copy into a cell and remain the same when condition me

Re: Trying to get a value to remain copy into a cell and remain the same when condition me

Re: Trying to get a value to remain copy into a cell and remain the same when condition me

Re: Trying to get a value to remain copy into a cell and remain the same when condition me

Re: Trying to get a value to remain copy into a cell and remain the same when condition me

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions