Macro Help Needed - Copy data row(s) from column into new file
Closed
Burt_Macklin
Posts
4
Registration date
Friday June 27, 2014
Status
Member
Last seen
July 17, 2014
-
Jun 27, 2014 at 03:41 PM
Burt_Macklin Posts 4 Registration date Friday June 27, 2014 Status Member Last seen July 17, 2014 - Jul 17, 2014 at 10:40 AM
Burt_Macklin Posts 4 Registration date Friday June 27, 2014 Status Member Last seen July 17, 2014 - Jul 17, 2014 at 10:40 AM
Related:
- Macro Help Needed - Copy data row(s) from column into new file
- Windows 10 iso file download 64-bit - Download - Windows
- Kmspico zip file download - Download - Other
- Saints row 2 cheats - Guide
- Tiny 11 iso file download - Download - Windows
- Download audio file from messenger - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 28, 2014 at 09:02 AM
Jun 28, 2014 at 09:02 AM
When you say it should begin. Why cant i say B3 begins with 601 also. So I guess question is what criteria one should use to say this is different and this still starts with
Burt_Macklin
Posts
4
Registration date
Friday June 27, 2014
Status
Member
Last seen
July 17, 2014
Jul 1, 2014 at 12:05 PM
Jul 1, 2014 at 12:05 PM
The identifier is this number in column B. So in the example I gave, I need to be able to take every row that begins with "601.004.005" in column B and save them into a new workbook.
Then I need to do the same for every row that begins with "601.004.005.01" in column B.
Then finally to do the same for every row that begins with "601.005.001" in column B.
So even though B1 and B2 begin the same, the additional numbers in B2 differentiate it from B1.
Does that make sense?
Thank you very much,
Then I need to do the same for every row that begins with "601.004.005.01" in column B.
Then finally to do the same for every row that begins with "601.005.001" in column B.
So even though B1 and B2 begin the same, the additional numbers in B2 differentiate it from B1.
Does that make sense?
Thank you very much,
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 5, 2014 at 09:40 AM
Jul 5, 2014 at 09:40 AM
I am still not clear
In B column you had these values
601.004.005
601.004.005.01
601.005.001
You said B1 and B2 start with same number but all three start with 601. So why not all three. And if actually meant that we should look for pattern of XXX.YYY.ZZZ to say that number starts. What I am trying to understand is till what point you look to say this number also starts with same
So
601.004.005
601.004.005.01
601.005.001
601.004.9999 (does this go with B1 and B2?)
601.004.005.01.99 (will this go with B1 and b2)
In B column you had these values
601.004.005
601.004.005.01
601.005.001
You said B1 and B2 start with same number but all three start with 601. So why not all three. And if actually meant that we should look for pattern of XXX.YYY.ZZZ to say that number starts. What I am trying to understand is till what point you look to say this number also starts with same
So
601.004.005
601.004.005.01
601.005.001
601.004.9999 (does this go with B1 and B2?)
601.004.005.01.99 (will this go with B1 and b2)
Burt_Macklin
Posts
4
Registration date
Friday June 27, 2014
Status
Member
Last seen
July 17, 2014
Jul 7, 2014 at 09:23 AM
Jul 7, 2014 at 09:23 AM
Oh I understand. Sorry I'm not intentionally trying to be unclear. Let me just lay out the actual numbers I have to work with:
601.004.0003%
601.004.0010%
601.004.0019%
601.004.0027%
601.011%
601.007%
601.004.0002.017%
601.004.0002.014%
601.004.0006%
601.004.0008.006%
601.004.0008.007%
601.004.0008.008%
601.004.0008.009%
601.004.0008.010%
601.004.0008.011%
601.004.0008.012%
601.004.0021%
601.004.0022%
601.004.0026%
601.004.0018%
601.004.0024%
These are all the unique identifiers, for lack of a better word. On the actual spreadsheet, all of these numbers look like AAA.BBB.CCCC.DDD.EEE and it varies as to which part of the number (i.e. CCCC or DDD, etc) is different.
For the above the % means that it doesn't matter what numbers appear after the %. So what I need is for everything that "begins" with 601.004.0003 to be copied into new spreadsheet and saved. Same thing for 601.004.0010 and so on down the line.
Thanks very much for your help.
601.004.0003%
601.004.0010%
601.004.0019%
601.004.0027%
601.011%
601.007%
601.004.0002.017%
601.004.0002.014%
601.004.0006%
601.004.0008.006%
601.004.0008.007%
601.004.0008.008%
601.004.0008.009%
601.004.0008.010%
601.004.0008.011%
601.004.0008.012%
601.004.0021%
601.004.0022%
601.004.0026%
601.004.0018%
601.004.0024%
These are all the unique identifiers, for lack of a better word. On the actual spreadsheet, all of these numbers look like AAA.BBB.CCCC.DDD.EEE and it varies as to which part of the number (i.e. CCCC or DDD, etc) is different.
For the above the % means that it doesn't matter what numbers appear after the %. So what I need is for everything that "begins" with 601.004.0003 to be copied into new spreadsheet and saved. Same thing for 601.004.0010 and so on down the line.
Thanks very much for your help.
Burt_Macklin
Posts
4
Registration date
Friday June 27, 2014
Status
Member
Last seen
July 17, 2014
Jul 17, 2014 at 10:40 AM
Jul 17, 2014 at 10:40 AM
Any ideas?
