Hi, I get reports that we need to move certain cells around to make them more readable. The Header is in Row4. The occupied cells are somewhere between A5 and A300, each report is different. I need to copy or cut whichever cell is occupied and paste it one column over and one row down. IE CellA4 is hostname and CellB4 is Machine Type. I don't want these to move. Cell A5 is hostnameA. This needs to move to B6, right under the machine type. They are spaced random within A5 and A300 but they always will be pasted one column over and one row down. I am fairly new to VBA and have tried several Range commands but I always seem to copy all the cells and when I paste them in colB, they write over the existing data. Thanks in advance.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Copy Occupied cells within a range and Paste to a different cell
- Thread starter cbye
- Start date
Excel Facts
Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Similar threads
- Solved
