struggling

I have the following formula that works when both workbooks are open, but not when the one I'm pulling from is closed. This is a report for another team that won't be opening the workbook I'm pulling from. I've read to use SUMPRODUCT for closed workbooks, but struggling on writing it correctly...

I have gave this a good bash and got close but struggling as it is text. So here is the problem. Col A and C are working great. Col. A = dropdown options (15ft basket, 10ft basket, 30ft pipe) Col B = 15x8x4, 10x4x2, 30x1x1 (Dependent on col A selection). Col C seems to be working fine with...

I have a process that needs to loop through all the files in a SharePoint folder but the scripting.filesystemobject function doesn't work. I'm really struggling to find a solution to this and hopefully someone can give a bit of advice. TIA

I would like to be able to count based on these two conditions... I have a portfolio project named "Kim" and there are multiple subprojects under this portfolio with a priority assigned (numerical values used 1, 2, 3...etc) so I want to count how many projects are prioritized as a 1 for "Kim"...

Hi All, I am currently looking to share an access database with colleagues in a different location that access different servers and so cannot store the database locally due to speed issues from elsewhere. I now want to run a Query into an Excel file from the database but struggling to find...

I am inporting a .png file into a worksheet which then hets converted to a .pdf and then I need to delete that specific image form the worksheet but I am struggling to work out the code as the image name changes as it's part of a loop. TIA

Hi Gents, I'm struggling on the above subject guys. Any help! Many thanks.

I have a number of worksheets and want to select all other than 2 specific sheet. I'm struggling to compile the code to basically say 'Select all sheets other then Sheet1 and Sheet2' TIA

If cell AJ4 is between 3.9% and 12.9% I want cell O4 to be coloured green. Struggling to get the simplicity of it, any pointers appreciated.

Hi, I am generally familiar with accessing elements on a webpage using VBA. However I am struggling with the DELETE button on the Kijiji website. Please click the following link to the screenshot (I am not sure how to get the image in the message itself). As there is no id identifying the...

Hi, I've posted a similar post: But I was wondering if it's possible to refresh a report, but when the refresh happens it removes the formulas and database links, but keeps the numeric/text values please. For example, if A1 reads 4, but actually was =2*2, when it refreshes it will just be 4...

Trying to add ISBLANK to the below formula. Struggling to get it to work. Granted, this is for sharepoint but to my knowledge this formula is the same on both applications. I am struggling to add ISBLANK to this so it returns blanks when Date Requested is blank. IF(AND(WEEKDAY([Date...

I am working on Top10 summary table where Top 10 summary is created based on value selected in $C$1. The problem is that i have multiple same entries in Column C, i am struggling to get multiple values. Any help would be appreciated ...

Hi all, I am using the below code to delete a range of columns. Range("A:A,C:C,D:D,E:E,F:F,G:G,I:I,K:K,M:M,N:N,O:O,P:P,Q:Q,R:R,S:S,T:T").Delete However, I also want a code to delete a range of rows but am struggling to work this out. Please can someone help? Cheers Chris

Hi all, Hope someone can help me, I'm really struggling with a problem that I think should be possible. I have a sports league of eight teams. I would like to organise a fixture list so that three teams are at each fixture on a Sunday morning. This would mean that six teams are involved (two...

Hello, I am struggling with the problem shown in the image below. Any help would be appreciated. Thanks in advance. https://imgur.com/a/0dcXl

I have a workbook with over 100 worksheets. In each sheet, Cell A1 is the only thing i'm really interested in, but I need each of those values in one worksheet so I can plot them. I'm really struggling with this as Excel seems to refer to the worksheets by name rather than index so you can't...

Hi, I am doing a project that I'm struggling with a bit. I wondered if someone could help? I have one table which contains calculated data that I want to apply categories to another table. <tbody> A B C D Industry 1 2 3 Energy 25 40 50 Retail 20 57 55 Chemicals 15 25 50 </tbody> So...

My data looks like <tbody> Branch name AA | | Total 1 2 3 4 Branch name AB | | | | Total 5 6 7 8 Branch name AC | Total 9 10 11 12 </tbody> The branch name and one of the totals fall in...

Hi everyone I'm struggling with a CONCATENATE formula. I have the following data: <tbody> A B C D 1 Record REC Linked REC WT/PT Result 2 9 WT REC9WT 3 8 WT REC8WT 4 7 6 PT REC7/6PT 5 6 PT REC6PT 6 5 WT REC5WT 7 4 3 WT REC4/3WT 8 3 WT REC3WT 9 2 PT REC2PT 10 1 PT...