Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Everything is named "Test1": first workbook, this sheet, other workbook...
Please clarify Cheers, -- AP "Venkatesh V" a écrit dans le message de ... 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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "Ardus Petus" wrote: Everything is named "Test1": first workbook, this sheet, other workbook... Please clarify Cheers, -- AP "Venkatesh V" a écrit dans le message de ... 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 Test1.xls) (b) value of column G of Test.xls to be copied into column H14 (activesheet of Test1.xls) (c) value of column H of Test.xls to be copied into column I14 (activesheet of Test1.xls) Alernatively, If there's any other wayof doing such things in a better way. Please do provide the details. Thanks a Lot. Venkat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Equation to refer to data value(s) and not the cell?? | Excel Discussion (Misc queries) | |||
How to take a cell that has 3 values and make 2 more new lines | Excel Worksheet Functions | |||
Multiple Cell Values, please help | Excel Discussion (Misc queries) | |||
How do I copy cell values (derived from formula), not references? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |