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 |