Hi,
I have two excel files, one consisting the main data consisting of Order ID, Order Name, Location, Status etc and another excel data with Jotform as a input which gets the data for Order Name, Location, Email Id of the person submitting the form.
I am interested in filtering my main dataset as per the request for each unique row of 2nd data sheet such that the person requesting the info gets a html table info/pdf as per Jotform request via Outlook mail.
Also how to automate for each unique row request as per user email id?
WarrenBelz
146,635
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,997
Most Valuable Professional