Split one excel sheet into multiple sheets based on column value but only selected columns

**nr6281** · 09-25-2019, 03:37 AM

Hi,

I found an macro online that works perfect in splitting the data into multiple sheets based on Column "S". However I only need selected columns to go to the other sheets vs the current all data in Raw file.

I only want the following column to be split "A:B" "E" "H" "J" "N:O" "R:T" only these columns should move.

Please Login or Register  to view this content.

**alansidman** · 09-25-2019, 06:19 AM

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

**nr6281** · 09-26-2019, 05:16 AM

https://www.mrexcel.com/forum/excel-...umn-value.html

**jindon** · 09-26-2019, 05:45 AM

Please Login or Register  to view this content.

**nr6281** · 10-01-2019, 04:15 AM

Please Login or Register  to view this content.

I am getting the above as an Debug not sure what I am supposed to do

**jindon** · 10-01-2019, 04:18 AM

Read a(i,1) when the code get in to a debug mode.
Hover over the cursor on it and you can read.

**nr6281** · 10-01-2019, 04:19 AM

attached is a template password 3091

**jindon** · 10-01-2019, 04:26 AM

Change to

Please Login or Register  to view this content.

**nr6281** · 10-01-2019, 04:34 AM

Perfect works like a Gem :-)

Thank you @jindon.

One question though if you take a look at the attached template I have put the link below. You helped me solve the splitting of data however do you think it is possible to auto allocate names to these task?

https://www.excelforum.com/excel-pro...ml#post5202870

**jindon** · 10-01-2019, 05:25 AM

If that takes care of your original question, select Thread Tools from the menu link above and mark this thread as SOLVED.

Split one excel sheet into multiple sheets based on column value but only selected columns

LinkBack

Thread Tools

Rate This Thread

Display

Split one excel sheet into multiple sheets based on column value but only selected columns

Re: Split one excel sheet into multiple sheets based on column value but only selected col

Re: Split one excel sheet into multiple sheets based on column value but only selected col

Re: Split one excel sheet into multiple sheets based on column value but only selected col

Re: Split one excel sheet into multiple sheets based on column value but only selected col

Re: Split one excel sheet into multiple sheets based on column value but only selected col

Re: Split one excel sheet into multiple sheets based on column value but only selected col

Re: Split one excel sheet into multiple sheets based on column value but only selected col

Re: Split one excel sheet into multiple sheets based on column value but only selected col

Re: Split one excel sheet into multiple sheets based on column value but only selected col

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] PowerQuery - Split column into multiple columns based on another column

Split single column into multiple columns based on value

[SOLVED] Need VBA code to match the value and split the data in the multiple sheets based on column

[SOLVED] Combine Selected Columns & Rows Informations from Multiple Excel Sheets to one sheet

Split excel file having multipl sheets into multiple excel file based on column

split excel sheet in to multiple workbooks based on the number of columns

Split into Multiple sheets based on beginning string in a set column - Code help

Bookmarks

Bookmarks

Posting Permissions