Hi, I am not good with Macros so I am looking for help creating a macro that takes data from formulas, copies the formulas down to the next row and then does a copy paste special values on the original line. Can someone help me with this?
My cells with formulas are b49:x49, I want to copy those formulas down to b50:x50, then go back to b49:x49 and Paste special values.
Any help would be appreciated. I am not good with this code stuff and tried to do a basic record but could not get it to work.