split data from sheet into multiple sheets based on first two letters

**abdo meghari** · 02-08-2022, 04:05 AM

hi
I would split data from sheet TIRES into multiple sheets based on first for two letters (FS,BS.....) into column B and when split data should arrange data the numbers from small to big.
so as you see in sheet BS when arrange. it should search the less number after R and arrange to big and should search the less number in the beginning item before letter R and arrange from small to big,also should replace data in divided sheet when change or add new data in sheet TIRES.
I put simple the result what I want after split in sheets BS,FS. but my true data in sheet TIRES are about 1000 rows and will increase
thanks

**kvsrinivasamurthy** · 02-08-2022, 05:01 AM

This appears to be the extension of the thread below. You want separate macro for this or the macro given in the referred thread can be modified . so that directly you get
BS and Rs sheets without Tires sheet.
copy items into column across files and copy to bottom with ignore duplicate itemshttps://www.excelforum.com/excel-pro...ate-items.html

**abdo meghari** · 02-08-2022, 05:27 AM

so that directly you get
BS and Rs sheets without Tires sheet.

no the sheet TIRES is important .
I don't see similar like my question . in my case should be split based on two first letters not only FS,BS there are manys DT, FD .... then should be multiple divided sheets and when arrange data should be the last number because it's tires desco size and see the first item should be arrange as I put it . I no know if this way logical about arrange or not . I can't modified the code as you suggest and I don't see close as in what I ask for it .

**maniacb** · 02-08-2022, 10:07 AM

Try this code. It assumes the 2-ltr word sheet does not already exist.

Please Login or Register  to view this content.

**maniacb** · 02-08-2022, 11:15 AM

This update will work even if the sheets already exists.

Please Login or Register  to view this content.

**abdo meghari** · 02-08-2022, 11:15 AM

@maniacb thanks for your code but I have two things .
first of all I would when run ,macro continuously just update the data when the sheets have already existed without shows error as occures based on your code because I add new data or change in sheet TIRES , then should add the data automatically to sheets are divided.
second about arranging if you compare the arranging of data based on OP with your code is difference.
I no know if my arranging of data are possible or not . just I would when arrange the data should search the less number after letter R and search the less numbers before letter R. should arrange from small to big . I no know this arranging way can achieve by Excel or not .

**kvsrinivasamurthy** · 02-08-2022, 11:17 AM

In Both FS and BS sheets you are having data starting with BS only. What about FS.

**abdo meghari** · 02-08-2022, 11:30 AM

OMG !

my apologies I attached wrong file .
@kvsrinivasamurthy thanks for inform me
my apologies guys
I edited file .

**abdo meghari** · 02-08-2022, 11:34 AM

@maniacb thanks again . can you see the arranging ,please?

**maniacb** · 02-08-2022, 11:34 AM

See post #5 for your first question. Working on the sorting.

**abdo meghari** · 02-08-2022, 11:36 AM

See post #5 for your first question. Working on the sorting.

I appreciated.

**AliGW** · 02-08-2022, 11:41 AM

Administrative Note:

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.)

**abdo meghari** · 02-08-2022, 11:55 AM

sorry ! here is the link
https://www.mrexcel.com/board/thread.../#post-5831592

**AliGW** · 02-08-2022, 11:55 AM

Thank you.

**sintek** · 02-08-2022, 11:58 AM

Please Login or Register  to view this content.

**abdo meghari** · 02-08-2022, 12:03 PM

@sintek thanks for your code , but the data are not arranging as I put it .
may you see some detailes in post#6 as I said to maniacb ,please? if this is not clear just tell me what you want to know .

**sintek** · 02-08-2022, 12:11 PM

Explain arranging in more detail...By referencing a few items...

**abdo meghari** · 02-08-2022, 12:26 PM

ITEM BRAND QTY
1 FS 195/65R15 EP150 THI 27410
2 FS 195/65R15 EP150 JAP 28445
3 FS 195/65R15 T001 JAP 29480
4 FS 205/65R15 EP150 INDO 25340
5 FS 205/65R15 MY02 THI 26375
6 FS 205/65R15 TZ700 JAP 31550
7 FS 195/55R16 EP300 THI 30515
8 FS 205/55R16 RE003 THI 24305

the most important the sorting should see to after letter R should sort from small to big as you see this alway contains numbers after letter R after the number there is space and some items about sorting should be normal . so in second part after two letters FS should sort based on it
this item 195/65R15 when sort it should sort 195/65 from small to big and also sort R15 from small to big . it's difficult to explain this complicated case .I thought the result where I put it may be clear

**sintek** · 02-08-2022, 01:05 PM

This solves...

Please Login or Register  to view this content.

Untitled.png

**abdo meghari** · 02-08-2022, 01:24 PM

@sintek I no know how thank you . in the beginning I tought this is not possible to sort for this way , but it seems my explenation is not clear.
honestly I had a problem with how to explain this method despite of I issue some results , but it doesn't seem enough .
many thanks for this great help

**sintek** · 02-08-2022, 01:33 PM

.............................................
Thanks.gif

**maniacb** · 02-08-2022, 01:37 PM

Here is another solution for you

Please Login or Register  to view this content.

**abdo meghari** · 02-08-2022, 01:42 PM

@maniacb great code !
million thanks

**Bo_Ry** · 02-08-2022, 01:52 PM

Please try

Please Login or Register  to view this content.

**abdo meghari** · 02-08-2022, 02:53 PM

@Bo_Ry thanks for your trying , but it doesn't arrange correctly .
see this picture based on your code and compare with right arranging as in post#19

**Bo_Ry** · 02-09-2022, 01:52 AM

Try

Please Login or Register  to view this content.

**abdo meghari** · 02-09-2022, 04:09 AM

@Bo_Ry thanks
did you see the result when attach your file ?

the same thing as in post#24 . it doesn't arrange correctly.

split data from sheet into multiple sheets based on first two letters

LinkBack

Thread Tools

Rate This Thread

Display

split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Re: split data from sheet into multiple sheets based on first two letters

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] split data for multiple digits & letters , symbols into sheet based on another

[SOLVED] split data based on three columns to multiple sheets and rename sheets based on headers

[SOLVED] split data across multiple sheets based on month

[SOLVED] split data from sheet to three sheets for many names based on two columns

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

[SOLVED] Split excel data into multiple sheets based on Employee ID

[SOLVED] Split Data from one sheet into multiple sheets

Bookmarks

Bookmarks

Posting Permissions