Search results

Here, I have used a similar formula based on your screenshot. I considered JOB IDs as customer names. =IF(INDIRECT(CHAR(COLUMN($C$2)+63+ROW(A1))&ROW($C$2))=$J3,SUMPRODUCT(INDIRECT(CHAR(COLUMN($C$2)+63+ROW(A1))&3&":"&CHAR(COLUMN($C$2)+63+ROW(A1))&8),$K$3:$K$8),0) I made a formula to sumproduct...

Here is a formula that can sumproduct the values under days and job prices based on day numbers: =IF(INDIRECT(CHAR(COLUMN($M$2)+63+ROW(A1))&ROW($M$2))=$T3,SUMPRODUCT(INDIRECT(CHAR(COLUMN($M$2)+63+ROW(A1))&3&":"&CHAR(COLUMN($M$2)+63+ROW(A1))&33),$K$3:$K$33),0) As you have said you want to drag...

Hey bigMe, I have two types of solution to your problem. The first code here will save the attachments from the sender automatically in the folder path you specify. You need to open the Outlook app and enable Macros for it. Next, press Alt + F11 to open the VBA Editor window. After that, insert...