I'm working as a newbie in excel VBA and can't figure this one out.
I have sheet "Main" with a range from A1 to E10000. When I press CommandButton1 I would like the content of the range that are not blank to copy to sheet "Reconciliation" in range A1 to E10000 and then also clear values in the range of F1 to F10000.
Not sure if it matters but I have both text and number values in the range of A1 to E10000. I have no formulas in any of the ranges.