•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Cutting and pasting rows
Our take
Are you struggling to organize your heavy databook filled with job codes efficiently? If you've color-coded similar codes but find yourself manually cutting and pasting each row, there’s a smarter way to streamline this process. Leveraging AI-powered tools can help you automate the stacking of similar codes without the tedious manual effort. In this guide, we’ll explore techniques that allow you to consolidate those rows swiftly, saving you time and ensuring your data is neatly organized.
I had a heavy databook which had job codes. But few of the codes were of similar nature.
Eg:
Cell A1, A10, A15, A19 etc were similar codes. I color coded them.
Now, I wanted them to be stacked one below the other, meaning
Code in A10 to be cut and pasted in A10, code in A15 to be cut and pasted in A3 and so on.
Is there any shortcut where i can stack them together without manually cutting pasting each row? The schedule was till column TP and the whole row had to be combined together.
Any tips would be appreciated. Thanks!
Strangely, I am unable to post a sample image. But I would be happy to provide more detail if needed.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience