Here are your reports produced by pivot tables
HTH,
--
AP
Here are your reports produced by pivot tables
HTH,
--
AP
Hi,
Could you please post as an attachment the document Test.docx which contains bookmarks.
TIA,
--
AP
Hi,
Budget Adjustment Template (VBA) v1.0.xlsm
HTH
--
AP
The output fields were blank because there is nothing to replace in the input field.
I modified the macro so that, in case no keyword was found in input, it prints input without changes in output field.
Could you please post a workbook with sample expected results ?
TIA
--
AP
You posted a .xlsx workbook without any code. Please post the original .xlsm.
Cheers,
--
AP
Paste this in your worksheet code,
then save the workbook as xlsm.
This should work faster
Cheers,
--
LR