Can any one provide macro copy values of one column to another column.
I am importing and populating the Textfile data(WHICH HAS 10000 Records) into excel sheet of Ranges Column A,B,C,D i want to copy specific values of column A and paste into Range of Column H,I,J,K
Assume Excel sheet have this data after importing
REFDES!PIN_NUMBER!NET_NAME!NET_ETCH_LENGTH!(Headers)
DUT!H41!DDR3_DQ[19]!9498.34!
DUT!H42!DDR3_DQ[23]!9498.02!
J1!AX2!GND!333256.77!
J80!DS3!NOA_AVRB_STB[0]!7573.99!
C459!1!LDP1-16_VTT!7660.31!
I want a macro copy values from J1 to J80 and paste it into H,I,J,K like below.
REFDES!PIN_NUMBER!NET_NAME!NET_ETCH_LENGTH!
J1!AX2!GND!333256.77!
J80!DS3!NOA_AVRB_STB[0]!7573.99!
Above event suppose to occur when the Ranges of Column A,B,C,D filled with values.
Can any one help me please.Thanks
I am importing and populating the Textfile data(WHICH HAS 10000 Records) into excel sheet of Ranges Column A,B,C,D i want to copy specific values of column A and paste into Range of Column H,I,J,K
Assume Excel sheet have this data after importing
REFDES!PIN_NUMBER!NET_NAME!NET_ETCH_LENGTH!(Headers)
DUT!H41!DDR3_DQ[19]!9498.34!
DUT!H42!DDR3_DQ[23]!9498.02!
J1!AX2!GND!333256.77!
J80!DS3!NOA_AVRB_STB[0]!7573.99!
C459!1!LDP1-16_VTT!7660.31!
I want a macro copy values from J1 to J80 and paste it into H,I,J,K like below.
REFDES!PIN_NUMBER!NET_NAME!NET_ETCH_LENGTH!
J1!AX2!GND!333256.77!
J80!DS3!NOA_AVRB_STB[0]!7573.99!
Above event suppose to occur when the Ranges of Column A,B,C,D filled with values.
Can any one help me please.Thanks