Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi!
Please need help. I dont know if it possible but... I have 1 workbook sheet with formulas and values that i want to find and paste in another workbook by run a macro. in the workbook1, select the cell with value that i want to paste to workbook2 if the text that i want to find in the workbook2 its found Example select and copy [workbook1]sheet1!k1 (the cell with the value that i want to paste) activate [workbook2]sheet1!a1 then find the text "article 12 ..." if it found select it and move cursor 2 cells right and then paste te value of [workbook1]sheet1!k1 return to [workbook1]sheet1 but select cell k9 copy ... and so on until the end ( i need for now 3 finds). Thanks i appreciate your help. |
#2
![]() |
|||
|
|||
![]()
The lookup may give you what you need
for diffferent ways to use this formula: http://www.officearticles.com/excel/...soft_excel.htm "Pasmatos" wrote: Hi! Please need help. I dont know if it possible but... I have 1 workbook sheet with formulas and values that i want to find and paste in another workbook by run a macro. in the workbook1, select the cell with value that i want to paste to workbook2 if the text that i want to find in the workbook2 its found Example select and copy [workbook1]sheet1!k1 (the cell with the value that i want to paste) activate [workbook2]sheet1!a1 then find the text "article 12 ..." if it found select it and move cursor 2 cells right and then paste te value of [workbook1]sheet1!k1 return to [workbook1]sheet1 but select cell k9 copy ... and so on until the end ( i need for now 3 finds). Thanks i appreciate your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
paste formulas between workbooks without workbook link | Excel Discussion (Misc queries) | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
copy and paste using code from workbook to workbook | Excel Discussion (Misc queries) | |||
Copy and paste from 1 workbook to another | Excel Worksheet Functions | |||
I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) |