#1
|
|||
|
|||
How to move data from one sheet to another
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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 Last edited by maximbebi; 02-14-2014 at 10:11 PM. |
#4
|
|||
|
|||
How to move data from one sheet to another
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to move data from one sheet to another | maximbebi | Excel | 2 | 02-17-2014 08:50 PM |
Combine Data From 2 Sheets into a new sheet | bremen22 | Excel | 1 | 09-11-2013 12:59 PM |
data linked from excel sheet | megatronixs | Word VBA | 1 | 08-19-2012 11:09 PM |
sheet 2 data highlight in sheet 1 | gsrikanth | Excel | 1 | 04-21-2012 06:25 PM |
Looking up data and populate a new sheet | Boatwrenchv8 | Excel | 4 | 04-13-2012 05:56 PM |