duteberta
Board Regular
- Joined
- Jun 14, 2009
- Messages
- 92
- Office Version
- 365
- Platform
- MacOS
I have a table with the fist column being "Status" which is a dropdown of 3 values ("ACTIVE", "PENDING" and "SOLD").
If I select "SOLD" from the dropdown I want THAT ENTIRE ROW to convert to values. Meaning all formulas or functions within that row turn to values (so they never change).
Maybe the drop-down trigger of "SOLD" would trigger a macro that would copy and PASTE as values with number formatting. Not sure exactly how to do this.
I need help knowing the VBA code to enable for this please.
If I select "SOLD" from the dropdown I want THAT ENTIRE ROW to convert to values. Meaning all formulas or functions within that row turn to values (so they never change).
Maybe the drop-down trigger of "SOLD" would trigger a macro that would copy and PASTE as values with number formatting. Not sure exactly how to do this.
I need help knowing the VBA code to enable for this please.