I've created a worksheet that our sales team will use to keep track of new accounts. It's almost completed but it is lacking one crucial piece. I need a macro that fill find, copy, and paste values right back onto the cells it originally selected.
On the attached spreadsheet, column H is the "Initial Contact" column. Cells in this column contain a format to insert today's date once there is any value place in the adjacent cells in column F, the "Input #1 column".
My issue is, I need the "Initial Contact" cells that contain today's date, to remain with that date permanently. Since they have a formula in them, I need a macro that searches column H for today's date, selects the cells or the range of cells containing only today's date, ignores blanks or any other dates other than today's date. Once it selects those cells with today's date, I need it to copy and then paste values right back, so the formula is replaced by only the date values. Is there anyone that can help with this? Your help is appreciated!
▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !
On the attached spreadsheet, column H is the "Initial Contact" column. Cells in this column contain a format to insert today's date once there is any value place in the adjacent cells in column F, the "Input #1 column".
My issue is, I need the "Initial Contact" cells that contain today's date, to remain with that date permanently. Since they have a formula in them, I need a macro that searches column H for today's date, selects the cells or the range of cells containing only today's date, ignores blanks or any other dates other than today's date. Once it selects those cells with today's date, I need it to copy and then paste values right back, so the formula is replaced by only the date values. Is there anyone that can help with this? Your help is appreciated!
▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !
