Hi
I have an excel spreadsheet,I have a problem and I need a macro , in sheet1 I have several values of 7 numbers in a cell, example 1|2|3|4|5|6|7| up to 93|94|95|96|97|98|99|, which can be found on the columns A, B, C, D, E, F, G, H, I, and I want for example to extract all values that begin with the number 1 ,and to put all the values in the worksheet 2 columns A, B, C, D, E, F, G, H, I,, for example 1|2|3|4|5|6|7| ,,,,,, up to 1|94|95|96|97|98|99| moved in sheet2 from sheet1.


I tried to extract the filter from the data tab .... sort and filter,,, filter,,,, filter by number,,,, starting with,,,, we apply the filter, but when we selected data values and take that were among the selected what was not good.


will explain more fully,I like this column A 1|2|3|4|5|6|7| , 21|25|32|43|51|60|73|, 1|2|3|4|52|69|78| ,11|12|30|45|50|61|79| ,3|5|70|74|75|77|79| , 1|22|33|44|50|63|75|, 1|22|33|44|50|63|75|................ column B 1|2|3|4|5|6|23| , 1|2|3|4|5|6|8| , 1|2|3|4|5|6|9| , 1|2|3|4|5|6|10| , 11|21|31|40|52|61|70| , 9|2|3|4|50|68|70| , 1|12|13|24|51|60|77| ,......... column C 1|2|3|4|50|65|70| , 2|5|7|9|10|16|37| ,5|8|9|14|15|26|67|,,,,,,,,,,,1|94|95|96|97|98|99| . In these columns I want to extract all values that begin with nr1 .....1|2|3|4|5|6|7|,,,1|90|91|92|93|94|95| from sheet1 in the sheet2,
I mean these... column A 1|2|3|4|5|6|7| ,1|2|3|4|52|69|78| ,1|22|33|44|50|63|75| ,1|20|31|43|55|60|71|
column B 1|2|3|4|5|6|23| , 1|2|3|4|5|6|8| , 1|2|3|4|5|6|9| , 1|2|3|4|5|6|10| ,1|12|13|24|51|60|77| column C 1|2|3|4|50|65|70| , 1|94|95|96|97|98|99|

Thanks

Your requirements are not very clear.
I suggest you post a sample sheet ( no pics) showing BEFORE and AFTER and ask a mod to move your question to the VBA forum as you seem to want a VBA solution.

Any reason why you opened 2 threads?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you very much
But I solved it with macros that you look above for moving values in another sheet

If you want to help me with a code macro to work at the level of the sheets,Sheet1 Sheet2



I want to move cut/paste all values duplicates from sheet1,
in sheet2

in sheet 1 to remain only the values themselves which didn't pair
I mean if a value is 2 times
to move the original value
but and double found



Thanks

The Advanced tab is good, but I don't have office 2013, I have office 2007

I want to move the duplicate values
in sheet 2
but to keep the values that are single sheet 1


I want to move cut/paste all values duplicates from sheet1,
in sheet2

in sheet 1 to remain only the values themselves which didn't pair
I mean if a value is 2 times
to move the original value
but and double found

file attachment is as example

Attached Files

maxim.xlsx (11.3 KB, 8 views)