Import text file with criteria

[marreco]

Hi.


Example of text file:

This data is imported into Excel and in the Sheet1 records that begin with 0 (zero) should be copied on Sheet 2, beginning with the letter "A" to Sheet3, those that begin with "C" for the Worksheet 4 with "D" for Worksheet 5, "F" for the Sheet 6, "M" for Planiha 7, with the number "1" to 8 and the sheet with the number "9" for 9 Worksheet.
Already I am grateful for the interest and help

[marreco]

Hi

Doing so is it possible?

[marreco]

If someone did not understand I can explain again

Thank's

[marreco]

Hi

If anyone can help me anyway I am very grateful

Thank

[NBVC]

See attached to see if I got you...

If raw data is in Sheet1, add a column before the raw data, and add formula:

=LEFT(B1)&"_"&COUNTIF(B$1:B1,LEFT(B1)&"*")

copied down.

Then in each other sheet, in A1 enter the beginning Letter/Digit you want to list....

Then select sheet2, hold the shift key down and select the last sheet.

Then in A2 of any of those sheets enter formula:

=IFERROR(INDEX(Sheet1!B:B,MATCH($A$1&"_"&ROWS($A$3:$A3),Sheet1!$A:$A,0)),"")

copied down as far as you need and across the appropriate number of columns...

Then right click any tab name and choose to ungroup sheets....

[marreco]

I'm very happy to have responded, thank you!

There is a chance to do it via VBA?

[marreco]

Hi.

I am very curious about VBA, would also be faster and more responsive.

Thank

[ChrisOswald]

here's my attempt.
Please note that some editing will likely be needed, especially in regards to the sheet names.

Please Login or Register  to view this content.

[marreco]

I am eternally grateful!

I'll try but still thank you!
Thank you!

[marreco]

Hi Chris Oswald, an error occurred.
See,
execution-time error '438 '. The object does not support this property or method at this point of execution.
Can you help me?