Copy and Paste Values

[Chewyhairball]

Hi Folks

I can't figure this out at all.

I have a table of data. They are all formula links to various other sheets.

Once each row has been checked the last column in the row has the text 'complete' typed into it.
I then select the row and copy/paste values to remove the formulas.

It would be good if there was some way of automatically doing this whenever ' complete' is entered

The only thing i have managed to do is to select a cell in the last column when' complete' is entered but the cell selected is the cell below it when i hit enter after typing 'complete'...i gave up trying to code the rest after that


One last thing. I have 20+ tabs each containing data tables so the last column is not always the same so it would be useful if any code could find the last column rather than me typing a specific range.

hope this makes sense

thanks

Rory

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Hi. A lot of work yes and very much appreciated. I have what I asked for so don't worry about the formula thing. I didnt ask before as I didn't realise it mattered and I could just add the formula myself. It's cool though, it's not needed. Thanks for all your help, it's certainly made my life easier. 

 

[Chewyhairball]

A lot of work done here to now realize you wanted all this to happen when a formula caused completed to be entered.

So you want a formula to cause all cells with formulas to erase the formulas.

Thinking about this now It might be something useful to be able to do. I am always trying to learn new code so if it's not to much hassle it would be good. I might not use it for my current project but could see where it might be useful in the future. Thanks ?

Would it be better to start a new thread for this? Ta

 

[My Aswer Is This]

Thinking about this now It might be something useful to be able to do. I am always trying to learn new code so if it's not to much hassle it would be good. I might not use it for my current project but could see where it might be useful in the future. Thanks 

Would it be better to start a new thread for this? Ta

If you want you could try and see.
Yes start a new thread