Data split in 2-3 columns

**mohan.r1980** · 04-13-2012, 05:59 AM

Hi Friends,

I have large no. of data in Column A and Column B.
i want to print in A4 size paper, i just want to split the data in 2 or 3 columns thats why i save my pages.

i have attached sample file.
in Input sheet i have Original Data and in Output sheet final look.

Pls suggest me

**arlu1201** · 04-13-2012, 06:02 AM

On what basis do you want the data to be separated?

**mohan.r1980** · 04-13-2012, 07:00 AM

No, its a matching data
i.e. P0000100017 - 1210913403

I made it last time in word 2003 in Table
i just want to is it possible in Excel or in word 2007

**arlu1201** · 04-13-2012, 07:05 AM

Please explain in more detail. What do you mean by matching data?

**mohan.r1980** · 04-13-2012, 08:58 AM

i just want to split 55 counts

**arlu1201** · 04-13-2012, 10:21 AM

Try this and let me know if it works -

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View->Macros
Select a macro in the list, and click the Run button

**mohan.r1980** · 04-14-2012, 09:45 AM

hi arlu1201

thank for reply

But this macro make horizontal columns
i just want to make only 2 column Groups i.e in my "output" sheet A To C and "E To G"
First 55 Count in A To C and Second 55 Count in E To G again Next 55 in A To C