Search results

Thank you

Hi, I would like to find an approach to do the following: Copy data from range B18:F20 as a table in the email with the numbers in bold Copy the range B2:G13 as image in outlook email. The items have to be in spcefic order, first the table(point 1) and then the range as image(point2) I have...

I am using Access 2007 and VBA to process around 200 Excel reports. The process is a follows open excel file populate excel file via an Access 2007 query via vba close file repeat steps 1 to 3 for rest of the files The problem I am facing is, the memory used by excel increases as more files...

Thanks

Hi, How do I do that? Regards

Hi Somendra, Thanks for the reply. I still have one issue. For some selections, there are blanks rows in the list box. Is it possible to avoid them? Regards Mandeep

Hi, I wish to populate a list box (with blue border in the attached file) based on the value selected in the dropdown(in D4, in the attached file). For e.g. if I select Sector from the dropdown, I should get the following values in the list box:- (All), Sec1, Sec2, Sec3, Sec4, Sec5 I wish to...

I have a template in xlsb format ( lets call this t.xlsb) that I use to create reports using Access 2007 & vba. This template has 2 sheets, each with a pivot table. Whenever I make changes to the template and run the reports, the reports get corrupted. So I do the following steps 1. save the...

I am unable to transfer data from excel 2007 to access 2007 using the docmd.transferspreadsheet command. Hence the workaround I am using is - create a linked table in access linked to the excel file - run a query which will append data from the linked excel table into the access table. Any...

For Criteria 4, I have to ignore all the 3 values. For e.g. if the values for that column are A, B, C, D, E, F, G. I need to ignore the values E & F & G Just to add I am able to get the desired results if use an ms-access query but I would like to use Excel formula

Luke I tried your suggestion of adding multiple SUMIFS. But I did not get an answer My requirement is as follows =SUMIFS(total column,criteria1 col,criteria 1, criteria 2 col, criteria 2, criteria 3 col, criteria 3, criteria 4, OR(not equal to any 1 of 3 possible values to be checked))

Is it possible to use OR function as one of the criteria in SUMIFS function?