Make Formula Constant Number Based on Criteria

[jharvey87]

Hi everyone,

Looking to add a command to a macro that can change a group of cells to a constant number (eliminating the formula pulling live numbers). On my spreadsheet Dashboard, I have a table W5:AE*. When I run this macro, if a cell within the W column (W5:W*) ever equals the value in M5, I would like to essentially do a copy/paste values of the numbers in the corresponding column/row of AC5:AD*.

As an example, if I run this macro now W6 = December 2022, the same value in M5. Therefore the macro would Copy/Paste Values into AB5:AC5, eliminating the live formula, now the cells are showing the hard coded number rather than the formula in these two cells.

Hoping I explained this correctly. If not I can try to create a sample workbook of what I'm looking to accomplish.

Thanks for the help!

[thomglea]

Little confused as to what you are doing, but the VBA command to paste as values is:

Please Login or Register  to view this content.