| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
find data in another workbook
I am trying to put together some code that will search a specific
workbook for data, and if that data is not present in that workbook to delete the data in the current workbook. Can anyone help with this? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
find data in another workbook
This should work.
Sub fndOthWb() x = ActiveCell.Value With Workbooks(2).Sheets(1).UsedRange Set c = .Find(x, LookIn:=xlValues) If Not c Is Nothing Then Else ActiveCell.Delete End If End With End Sub "nannon8" wrote: I am trying to put together some code that will search a specific workbook for data, and if that data is not present in that workbook to delete the data in the current workbook. Can anyone help with this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find data another workbook | Excel Programming | |||
| loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming | |||
| HOW DO I USE MACRO TO FIND REPEATING DATA FROM ANOTHER WORKBOOK | Excel Programming | |||
| HOW DO I USE MACRO TO FIND REPEATING DATA FROM ANOTHER WORKBOOK | Excel Programming | |||
| EXCEL: Find data in worksheet and create a new sheet in same workbook | Excel Programming | |||
Hybrid Mode
