Automatic representation of cell values

[Guest]

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 ==> 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

 

[Ardus Petus]

Everything is named "Test1": first workbook, this sheet, other workbook...

Please clarify

Cheers,

 

[Guest]

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