Splitting of columns in different worksheets

[paddy1992]

I have N no. of columns in the 1st worksheet which can be named a
Master or source sheet and the requirement is to split the columns a
per required into the different worksheets of the same workbook.

Example: I should be able to split it like 2 or 3 columns in workshee
2, 5 or
6 columns in worksheet 3 and so on and so forth.

Can someone please let me know how to do i do this and if possible,
can someone please provide me with the code in excel macros

 

[T. Valko]

Multi-posted at Mr. Excel

 

[Simon Lloyd]

Thanks Biff, user has been warned, besides the post isn't that
informative so is unlikely to get a decent response!

Multi-posted at Mr. Excel

--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)

 

[paddy1992]

Hi, Sorry for not being specific about the requirement.I need t
basically fulfill
the requirements as follows.

The data is entered in N number of columns in the Master sheet.
These data needs to split into different column as follows.

For example:Sheet 1 (Master sheet): column A to D to be copied int
Column A to D of sheet 2.
Column E to K to be copied into column A to G of sheet 3.
Column L to S to be copied into column A to H of sheet 4 so on.

Now the copy paste operation is not possible as the next step is t
design a tool which
will take the excel sheet filled with master data as input and th
output will be the columns
split into various sheets of the same workbook.

Note: I would like to retain the original data in the master sheet.

Kindly help me with this particular scenario

 

[Simon Lloyd]

Paddy1992, please supply the links to ALL your other forums where yo
have posted this, i have given you an explanation why, go to you
threads at the other forums and copy the url from the browser window an
paste them here, you are then likely to get the response you require :

Hi, Sorry for not being specific about the requirement.I need t
basically fulfill
the requirements as follows

The data is entered in N number of columns in the Master sheet
These data needs to split into different column as follows

For example:Sheet 1 (Master sheet): column A to D to be copied int
Column A to D of sheet 2
Column E to K to be copied into column A to G of sheet 3
Column L to S to be copied into column A to H of sheet 4 s
on

Now the copy paste operation is not possible as the next step is t
design a tool which
will take the excel sheet filled with master data as input and th
output will be the column
split into various sheets of the same workbook.

Note: I would like to retain the original data in the master sheet

Kindly help me with this particular scenario

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com

 

[paddy1992]

This is the other site where i have posted my query. Thank you i
advance.

*Addition to the Query*: The number of sheets to which the columns nee
to be split is 3. So all the columns in master sheet would need to b
split equally into the three sheets

 

[Ashish Mathur]

Hi,

Try this

1. Select the entire range (including the header row) and assign it a name
(Ctrl+F3), say Dummy
2. Select the entire range once again (including the header row) and convert
it to List (Ctrl+L)
3. Save the file (say try.xls) on the desktop
4. Open a new sheet
5. Now go to Data > Import External Data > New Database query
6. Select Excel files and click on OK
7. In the next box, navigate to the desktop in the right hand side pane and
in the left hand side pane, select try.xls. Click on Next
8. In the choose columns box, click on the + sign before dummy and transfer
the desired columns to the right (by selecting each desired column and
clicking on the > symbol)
9. Click on Next 3 times
10. In the last box, select Return data to MS Office Excel
11. In the Import Data box, select the cell where you want the output and
click on OK
12. Repeat steps 4-11 for generating data on the three other sheets

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[ryguy7272]

Take a look at this:
http://www.rondebruin.nl/copy5.htm

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.

Hi,

Try this

1. Select the entire range (including the header row) and assign it a name
(Ctrl+F3), say Dummy
2. Select the entire range once again (including the header row) and convert
it to List (Ctrl+L)
3. Save the file (say try.xls) on the desktop
4. Open a new sheet
5. Now go to Data > Import External Data > New Database query
6. Select Excel files and click on OK
7. In the next box, navigate to the desktop in the right hand side pane and
in the left hand side pane, select try.xls. Click on Next
8. In the choose columns box, click on the + sign before dummy and transfer
the desired columns to the right (by selecting each desired column and
clicking on the > symbol)
9. Click on Next 3 times
10. In the last box, select Return data to MS Office Excel
11. In the Import Data box, select the cell where you want the output and
click on OK
12. Repeat steps 4-11 for generating data on the three other sheets

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

I have N no. of columns in the 1st worksheet which can be named as
Master or source sheet and the requirement is to split the columns as
per required into the different worksheets of the same workbook.

Example: I should be able to split it like 2 or 3 columns in worksheet
2, 5 or
6 columns in worksheet 3 and so on and so forth.

Can someone please let me know how to do i do this and if possible,
can someone please provide me with the code in excel macros.


--
paddy1992
------------------------------------------------------------------------
paddy1992's Profile:
http://www.thecodecage.com/forumz/member.php?userid=1236
View this thread:
http://www.thecodecage.com/forumz/showthread.php?t=156405

Microsoft Office Help