I have some data that i want to move but am running into an issue, i guess you cant move multiple rows at once in Excel VBA. I was trying to use Range("C:C").SpecialCells(
row.cut then paste the data at the bottom of my list with something like Range("A" & Rows.Count).End(xlUp).Offs
et(1, 0).PasteSpecial xlPasteValues. But excel is throwing a fit. No matter what paste command i use it will not paste multiple rows.
The only other way to do this that i know of is with a Search in column C and if data is found then move it to the bottom, then loop this a number of times. Is there an easyier way to handle moving the data. I have Attached a sample workbook with a before and after table for reference.