please find attached screen prints on how my data looks on XL sheet (as-is). With the help of Macros, I need to cut every 4 columns and need to paste it in a different XL TAB. I have attached another Attachment which gives how my data should look once Macro is executed.

I need this to be a generic one. Like option to choose number of columns and rows to cut/copy.

Sanju

This is not a coding-for-hire site. We try to help those who are stuck with coding problems.

If you have some code you've tried, post it. Otherwise, do some work first and we'll help you if you get bogged down.

commented: Well said! +13
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.