Previous Topic Next Topic

Finding word and copying row

Closed
luxusas - Feb 27, 2010 at 08:59 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 28, 2010 at 08:22 AM
Hello,
I have one problem with excel. In worksheet A in column A is 100 numbers from 1 to 10 they are written random. In columns B, C, D are data. I want to find all the numbers 1 in column A and copy rest of the data that is in those rows (to the right of number 1) to worksheet B in rows 1, 2, 3, 4 and so on. How should i do it?
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 28, 2010 at 12:27 AM
If only "1" is needed then filter on 1 and copy the data to other sheet

if all numbers are needed in order, then sort the data and then you can copy
0
luxusas
Feb 28, 2010 at 08:05 AM
I need to do it automaticaly. For example i have worksheet named "general" i write in A1 "1" in B1 data1 in C1 data2 in D1 data3. Then i have worksheet named "1" and i need to put data1 to worksheet "1" B1 cell, data2 to worksheet "1" C1 cell and data3 to worksheet "1" D1 cell. Then everything starts from the beginning: now i write in worksheet "general" A2 cell "9" and in B2 - data4, in C2 - data5, in D2 - data6. And now i have other worksheet named "9" and i have to put data4 to woksheet "9" B1 cell, data5 to C1 cell and data6 to D1 cell. And everything begins again: now i write into worksheet "general" A3 cell "1", B3 cell - data7, C3 cell - data8 and D3 cell - data9. And now i need to put data7 to worksheet "1" B2 cell, data8 to C2 cell and data9 to D2 cell. This is quit difficult for me to do this, if its possible anyway.
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766 > luxusas
Feb 28, 2010 at 08:22 AM
Have a complete hands off process for it would be difficult because of so many "if and buts" How ever you can more easily have a macro that would do the job for you once the data is populated and you are ready to move rows from one worksheet to other

See this https://ccm.net/forum/affich-258700-interesting-question-for-excel-champions
This solution is based on same idea
0

Similar discussions

How to convert the tamil pdf file to tamil word file
varathalakshmi -
karthik -

12 responses