Copy range data against a value in excel

Closed
yogu - Jan 7, 2009 at 07:16 AM
livetalk10 Posts 17 Registration date Friday August 8, 2008 Status Member Last seen April 5, 2009 - Jan 7, 2009 at 11:52 AM
Hello,

I have a chemistry of 304 L,304,310 etc & I have to past this chemistry where 304,304l appears in sheet of excell.


e. is as follows


1. 304L %C % CARBON Spectrometer fixed 1 3 % 0.000 0.030
%Mn % MANGANESE Spectrometer fixed 1 3 % 0.000 2.000
%Si % SILICON Spectrometer fixed 1 3 % 0.000 1.000
%S % SULPHUR Spectrometer fixed 1 3 % 0.000 0.030
%P % PHOSPHORUS Spectrometer fixed 1 3 % 0.000 0.045
%Cr % CHROMIUM Spectrometer fixed 1 3 % 18.000 20.000
%Ni % NICKEL Spectrometer fixed 1 3 % 8.000 13.000
%Cu % COPPER Spectrometer fixed 1 3 % 0.000 0.750
%Mo % MOLYBDENUM Spectrometer fixed 1 3 % 0.000 0.500

2. 316L %C % CARBON Spectrometer fixed 1 3 % 0.000 0.030
%Mn % MANGANESE Spectrometer fixed 1 3 % 0.000 2.000
%Si % SILICON Spectrometer fixed 1 3 % 0.000 1.000
%S % SULPHUR Spectrometer fixed 1 3 % 0.000 0.030
%P % PHOSPHORUS Spectrometer fixed 1 3 % 0.000 0.045
%Cr % CHROMIUM Spectrometer fixed 1 3 % 18.000 20.000
%Ni % NICKEL Spectrometer fixed 1 3 % 8.000 13.000
%Cu % COPPER Spectrometer fixed 1 3 % 0.000 0.750
%Mo % MOLYBDENUM Spectrometer fixed 1 3 % 0.000 0.500

1 response

livetalk10 Posts 17 Registration date Friday August 8, 2008 Status Member Last seen April 5, 2009 7
Jan 7, 2009 at 11:52 AM
Hi,


Try formating the cells in the format that your require it should work
0