im using this code to fill a number on a different sheet. But how can i fill a cell with wild cards as I cant define the end if the filename prior to the extension?
VBA Code:
For Each rng In WS2.Range("C2", WS2.Range("C" & WS2.Rows.Count).End(xlUp))
Set fnd = WS1.Range("A:A").Find(rng, LookIn:=xlValues, lookat:=xlPart)
If Not fnd Is Nothing Then
fnd.Offset(, 1) = rng.Offset(, 1)
End If
Next rng
search name | example file name | correct name | final order | packet a | packet b | ||||
logo_folio | logo_folio3763012.pdf | logo_folio3763012.pdf | 100 | 3 | |||||
RM | RM9006.pdf | RM9006.pdf | 100 | 3 |