Any data splitting experts out there? Seeking help to split columns data

Hi, I currently maintain a spreadsheet with numerous columns, basically I am looking to split the data whilst retaining the first column.

Simplified version
North East West South
Acct 123 34 21 432
PC 423432 43 432 343432
A&G 3432 43 43 3432
Total 426987 120 496 434


Desired Results
North
Acct 123
PC 423432
A&G 3432
Total 426987

To be saved separately under North, South, East, West tabs.
Would be great if the tabs can be automated to be saved individually as well!

Have came across numerous vba code which can split by rows..but none that is able to split by columns..
Appreciate if there are any experts out there to advise,
Thanks!

Hi,

attach a sample workbook with a source worksheet and a desired worksheet.
Precise if original worksheet must be overwrited or not …

Hi..

Try this..

Please Login or Register  to view this content.

Thanks guys, apo especially!!
This is very close to what I was looking for..

Am sorry if I m sounding too greedy, is it possible if it can be tweaked such that 3 columns are copied and pasted into a fresh sheet with the Sheetname as the characters before the - (i.e. Northwest ), whilst retaining the first column

I have reattached a spreadsheet with the Main sheets and the intended output..

Hi..

Sure.. Click the Button on the Main sheet..

Please Login or Register  to view this content.

This actually copies.

Please Login or Register  to view this content.

Thanks, it works!!

But for some reason the code does not pick up values in rows after a blank row..is there a way around this?

The reason is because 'CurrentRegion' is being used. It will only pick up cells in a contiguous block.

If your data goes out to the M column... for example...

You could change this line:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Great, it works! awesome

You are welcome and thanks for the rep.

Can you mark this thread as "Solved"?

Would like to present an additional requirement, supposed my data for column1 starts from cell a2, but for the rest of columns say the begin only at row10, how do I go about amending your code to capture the desired result?

Have reattached my file, along with desired output in the North, South, East, West tabs.
Would really appreciate the help,
Thanks!

Like this?

Please Login or Register  to view this content.

Thanks Mate!! Much appreciated.