enquiry

My formula has magically stopped working.. it used to look like this: =IFERROR(IF(COUNTIF(BookData!O:O,EnqData!Q3)=0,"",INDEX(BookData!B:B,MATCH(Q3,IF(BookData!H:H>=C3,BookData!O:O,""),0),0)),"") What this does: First portion - Counts whether the unique customer reference in Q3 matches...

Sorry if that's confusing. There are two sheets, both have a unique reference on them. One is enquiry data, the other is booking data. I need to match enquiry dates to booking dates to work out lead times, find out how long it takes our customers to book after requesting a brochure (enquiry)...

Good Morning, The code below loads the data into my userform with no issue, but I need to load the userform and have the combobox1 options load also straight away instead of basing the combobox1 data on a change of the userform once its loaded. I am confused on how to get this to work? Should...

Dear all, I am a vba noob, just started building a userform for a month, able to send all the data to excel sheet, able to perform search function and recall back to another userform and etc I need your help on the below scenarios, I was trying to google the answer for a few hours and...

Hi I have a data column that shows a series of level 1 and level 2 tags. the data presents as L1 space and then the name of the level 1 tag then a comma space then L2 space and the name of the level 2 tag. See examples below I urgently need a formula that returns the L1 tag name and a second...