Automatic representation of cell values

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Everything is named "Test1": first workbook, this sheet, other workbook...

Please clarify

Cheers,
 
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
 
Back
Top