software

HI,
here's the query:

A sheet named Test1 contains some values on column F,G,H and J.
This sheet (Test1.xls) contains values upto more than 100 rows.

Now, I open a another excel-workbook (Test1.xls), which contains more than
10 sheets.

Now, I wanted to select a particular row in Test1.xls and run a macro which
allow us to copy those contents into the active sheet of Test1.xls.

Like, running a macro and selcting a row from Test.xls ==gt; should pick up
the values of:
(a) value of column F of Test.xls to be copied into column G14 (activesheet
of Text1.xls)
(b) value of column G of Test.xls to be copied into column H14 (activesheet
of Text1.xls)
(c) value of column H of Test.xls to be copied into column I14 (activesheet
of Text1.xls)Alernatively, If there's any other wayof doing such things in a better way.
Please do provide the details.Thanks a Lot.
Venkat

Everything is named quot;Test1quot;: first workbook, this sheet, other workbook...

Please clarify

Cheers,
--
AP

quot;Venkatesh Vquot; gt; a écrit dans le message
de ...
gt; HI,
gt; here's the query:
gt;
gt; A sheet named Test1 contains some values on column F,G,H and J.
gt; This sheet (Test1.xls) contains values upto more than 100 rows.
gt;
gt; Now, I open a another excel-workbook (Test1.xls), which contains more than
gt; 10 sheets.
gt;
gt; Now, I wanted to select a particular row in Test1.xls and run a macro
which
gt; allow us to copy those contents into the active sheet of Test1.xls.
gt;
gt; Like, running a macro and selcting a row from Test.xls ==gt; should pick up
gt; the values of:
gt; (a) value of column F of Test.xls to be copied into column G14
(activesheet
gt; of Text1.xls)
gt; (b) value of column G of Test.xls to be copied into column H14
(activesheet
gt; of Text1.xls)
gt; (c) value of column H of Test.xls to be copied into column I14
(activesheet
gt; of Text1.xls)
gt;
gt;
gt; Alernatively, If there's any other wayof doing such things in a better
way.
gt; Please do provide the details.
gt;
gt;
gt; Thanks a Lot.
gt; Venkat
a excel-workbook that contains the values in cells are named as Test.xls.

The other excel-wrokbook named as Test1.xls.

Sorry for the confusion!
Rgds,
Venkat

quot;Ardus Petusquot; wrote:

gt; Everything is named quot;Test1quot;: first workbook, this sheet, other workbook...
gt;
gt; Please clarify
gt;
gt; Cheers,
gt; --
gt; AP
gt;
gt; quot;Venkatesh Vquot; gt; a écrit dans le message
gt; de ...
gt; gt; HI,
gt; gt; here's the query:
gt; gt;
gt; gt; A sheet named Test1 contains some values on column F,G,H and J.
gt; gt; This sheet (Test1.xls) contains values upto more than 100 rows.
gt; gt;
gt; gt; Now, I open a another excel-workbook (Test1.xls), which contains more than
gt; gt; 10 sheets.
gt; gt;
gt; gt; Now, I wanted to select a particular row in Test1.xls and run a macro
gt; which
gt; gt; allow us to copy those contents into the active sheet of Test1.xls.
gt; gt;
gt; gt; Like, running a macro and selcting a row from Test.xls ==gt; should pick up
gt; gt; the values of:
gt; gt; (a) value of column F of Test.xls to be copied into column G14
gt; (activesheet
gt; gt; of Test1.xls)
gt; gt; (b) value of column G of Test.xls to be copied into column H14
gt; (activesheet
gt; gt; of Test1.xls)
gt; gt; (c) value of column H of Test.xls to be copied into column I14
gt; (activesheet
gt; gt; of Test1.xls)
gt; gt;
gt; gt;
gt; gt; Alernatively, If there's any other wayof doing such things in a better
gt; way.
gt; gt; Please do provide the details.
gt; gt;
gt; gt;
gt; gt; Thanks a Lot.
gt; gt; Venkat
gt;
gt;
gt;