FIND a value in a Workbook
Closed
gbj
-
Dec 15, 2009 at 02:49 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 15, 2009 at 09:12 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 15, 2009 at 09:12 PM
Related:
- FIND a value in a Workbook
- Run macro on opening workbook - Guide
- Excel vba add sheet to another workbook - Guide
- Transfer data from one excel workbook to another automatically - Guide
- Copy data from one workbook to another vba - Guide
- Split a workbook into individual files in Excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 15, 2009 at 09:12 PM
Dec 15, 2009 at 09:12 PM
As you seem to familiar with writing a macro try these ideas
you need not activate a sheet or cell or even workbook
for this you can use
"with" statement with ofcourse and "end with "
you can loop through the sheets in Book2 to find the entry you ahvae in Book1.
It is also not clear if you do find a value in boo1, in book 2 what do you want to do with the found item.
On these ideas would you like to rewrite the macro?
you need not activate a sheet or cell or even workbook
for this you can use
"with" statement with ofcourse and "end with "
you can loop through the sheets in Book2 to find the entry you ahvae in Book1.
It is also not clear if you do find a value in boo1, in book 2 what do you want to do with the found item.
On these ideas would you like to rewrite the macro?