select and paste data based on creteria on previous cells
in [Programming]
|
From: Jerome on 2 Jun 2010 21:22 I have a worksheet running to 700 pages. At various cells, description "cable No" is written. in the next cell the cable number is found and on the cell below the type of cable is found. i have to copy and paste all the cable numbers and corresponding cable types in the next worksheet one below the other. Please suggest me a method. Regards, Jerome -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
From: Rich Locus on 3 Jun 2010 01:54 Jerome: Please give a concrete example of what you are discussing. Does it look like this? Cable No 155 Sheathing Cable No 167 Sheathing Cable No 188 Insulation Or like this: Cable No 188 Insulation Other info Other info Cable No 188 Waterproof Cable No 199 Description Etc. -- Rich Locus Logicwurks, LLC "Jerome" wrote: > > I have a worksheet running to 700 pages. At various cells, description > "cable No" is written. in the next cell the cable number is found and on > the cell below the type of cable is found. i have to copy and paste all > the cable numbers and corresponding cable types in the next worksheet one > below the other. Please suggest me a method. > > Regards, Jerome > > -- > Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ > . >
|
Pages: 1 Prev: Find Min and Max in variable length arrays Next: How to assign unit for TimeValue? |