I need to update ALL prices within a PDF based on a percentage. To start though I will obviously need to be able to successfully find ALL prices first. Prices are in the format such as:
I found the below VBA code courtesy from www.TheSpreadsheetGuru.com
however, I do not know how to modify it to search ALL worksheets and to search for a pattern/regex.
'PURPOSE: Find & Replace text/values throughout entire workbook
Dim sht As Worksheet
Dim fnd As Variant
Dim rplc As Variant
fnd = "April"
rplc = "May"
For Each sht In ActiveWorkbook.Worksheets
sht.Cells.Replace what:=fnd, Replacement:=rplc, _
LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, _