Forum Discussion
Using VBA to move letter/symbol to cell to the right
I am trying to write code to move the symbol or letter in a range to cell to the right, so the next column over. My data is in E19:E54 and if there is < or F in with the numbers I want that moved to ...
It didn't save the last edits I made before posting, my apologies for the confusion. I want to take only the cells with F or < in them and move that to the next cell. I already have code written to create this spreadsheet and am trying to add this in. I cannot simply do a formula and I cannot change the integrity of the spreadsheet by adding additional columns. Do you know how to write code for this?
OK. Thanks for clarifying. I'm NOT a VBA person, generally preferring to do formulas, finding them more reliable. So I'll defer to others who are gifted in VBA.