Macro to cut columns in different spreadsheet

[pratik4891]

Hello ,

This is my first post in the forum and I have no knowledge in VB programming
My requirement is like below

I have an excel file with page break and I want to populate each page into different tabs/sheets

Below is the structure

ColA , ColB , ColC{Page Break}ColA , ColB , ColC{Page Break} ColA , ColB , ColC

I need the first group to sheet 1 ,second group (after page break) to sheet 2 and the last group to page 3

Could you please help me to write down the code ?

Thanks!!

[ARGK]

Hi
See sample attached. Open the file and run the Macro SplitColumnsToSheets macro.
Hope this helps.
Good luck.
Tony

[HaHoBe]

Hi, ARGK,

your macro could be reduced to

Please Login or Register  to view this content.

@pratik4891:

In case the columns arenīt specified before you could rely on the vertical pagebreaks in the sheet to add the data to the sheets. As I worked with the sample workbook I just copied over the entire columns which could be reduced to the used range of the worksheet:

Please Login or Register  to view this content.

Ciao,
Holger