Hi Maurizio Attached is your file with my modification. Please note that I have remove the background image as the original file size is too big to...
Hi Maurizio As far as I am aware of, the only way to export a picture as an image file (jpeg/bmp etc) using VBA is to paste the required picture to...
Hi Julie Make sure that the linked file HFM Hotel Revenue per Country B17.xlsx is open simultaneously. When working with linked files, it is bet...
Hi Maurizio It is not easy to generate a perpetual calendar in a userform (or even in a worksheet) unless you use the suggestions given my Philip T...
Hi David Thanks for your feedback. Glad to know the explanation is clear enough Sunny
Hi Julie Not too sure if I understood you but see if this is what you are looking for. In Workbook2 enter =INDIRECT("[Workbook1.xlsx]"&C1&am...
Hi Ahmed See my explanation in red below. Find the last row number of the sheets with data as I need to copy from Column A Row 1 till the last r...
Hi Hava SORTING 1) Click the down arrow on the Name header. 2) Select More Sort Options... 3) Select Descending (Z-A) by: 4) Select Sum...
Hi Hava There could be two reasons. Reason 1 If it is happening to only one or two cells then it is likely those cells are formatted as TEXT....
Hi Mark Instead of a single formula, you may want to consider using a Pivot Table to achieve step 1 of extracting the maximum grade for each unique...
Hi Mark There is no attachment.
Hi Give this a try Sub MergeData() Dim LastRow1 As Long Dim LastRow2 As Long Dim LastRow3 As Long LastRow1 = Sheets("Sheet1").Range("A" &...
Hi Diane My formula will also work for that scenario. See the part in red. =IF(AND(E2<>"",(TODAY()-E2)>366,G2=""),"Contact Issued To or...
Give this a try =IF(AND(E2<>"",(TODAY()-E2)>366,G2=""),"Contact Issued To or Department","") Sunny
Hi Khalil Refer attached. Q1 Frans have already given you the first answer. As for the lookup, I believe you are comparing more than 1 col...