VBA selecting dynamic ranges and export that to PDF

[Jalal Kasmani]

Hi,

I have excel file in which various advices are pasted one below the other. I require a process where the user will enter deposit number (D4567821) to search , so the range from bank N.A. Mumbai till Authorised signatory boibank N.A should get selected and exported that as PDF.

Below is the raw rough data in excel

bank N.A. Mumbai
Branch : Mumbai
Date : 31-MAR-2021
THE ACCOUNTS DEPARTMENT
dasjfndjsfbg
1202,12TH FLOOR,FIRST INTERNATIONAL
dacfdaf
df
cadf
400051
		ADVICE OF FIXED DEPOSIT BOOKED
This is to inform you that at your request, a MIBOR linked Deposit has been booked with the following details :
Deposit No				D012456987254100
Date of Booking				31-MAR-2021
Date of Maturity				20-APR-2021
Principal Amount (Rs.)			65000​
Rate of Interest				Mibor - 2.000
Tenor (Days)				20
Authorised signatory						Authorised signatory
boibank N.A.							Boibank N.A.
bank N.A. Mumbai
Branch : Mumbai
Date : 31-MAR-2021
THE ACCOUNTS DEPARTMENT
dasjfndjsfbg
1202,12TH FLOOR,FIRST INTERNATIONAL
dacfdaf
df
cadf
400051
		ADVICE OF FIXED DEPOSIT BOOKED
This is to inform you that at your request, a MIBOR linked Deposit has been booked with the following details :
Deposit No				D4567821
Date of Booking				31-MAR-2021
Date of Maturity				20-APR-2021
Principal Amount (Rs.)			65000​
Rate of Interest				Mibor - 2.000
Tenor (Days)				20
Authorised signatory						Authorised signatory
boibank N.A.							Boibank N.A.