Recent content by IainG

Can anyone help me develop the following code so that I can capture data from specific sheets(if they exist) within a source workbook? The code below scrolls through and opens files from within 3 folders on my network drive and copies a specific range from sheet1 to a NEW workbook(Sheet1)...

Oh my head! Sorry about that, I think I need a break.... Thank you for taking the time to help.

I have attached a sample of the data. Thank you.

That's giving me a #N/A

My actual data range (Sum Range) is (G6:HZ20) Critera1 is Text (F6:F20) Criteria2 is a Date (G5:HZ5) You wouldn't happen to know if there is a function that will allow Column & Row criteria?

Can anyone tell me if the SUMIFS function can work in this way? I used something similar with the SUMIF from and earlier post which worked great, but now need to use multiple criteria. This code is producing the #Value...

NBVC, The 2nd option worked perfectly! So obvious when you see it. Thanks You.

Hi, Can anyone tell me if its possible to use the LEFT() function or an equivalent function within this formula, =SUMPRODUCT(SUMIF(INDIRECT("'"&$E8&"'!$F$6:$F$20"),$F8,INDIRECT("'"&$E8&"'!A$6:A$20"))) The INDIRECT(ref_text) is working perfectly when it finds a complete match, but I want it...

Can anyone help me please? I have a report that contains a subreport that I sum for each section and it works perfectly using a text box. However, I am now wanting to sum those text box values to a Report Total and show it in the Report Footer! I have been trying to sum the text boxes which...

Can anyone help me here please. I am using a Subform (summary List) to allow users to scroll and select a record ID. The record ID has a OnClick event that moves the Main Form to the selected record. All working fine appart from the Subform refreshing once the Main form displays the record...

That has worked perfectly! Sorted. Thank you for the super fast response.

Can anyone help with this Form issue please. I have a combo box on my form where the user selects a Currency(cCur) from a query. Each currency record in the query has related exchange rate fields, GBP and USD. The user also inputs a value(pVal1) that I then want to use in calculating...

David, That works just fine. Many thanks. Iain.

Runtime Error message 94 Can anyone help with the following? I am trying to use the MONTH function within the following procedure but I get an 'Invalid use of Null' error when [StartDate] is blank! Private Sub StartDate_AfterUpdate() Dim aMonth As Integer aMonth = Month([StartDate]) If...

Hi Boblarson, I tried your code but unfortunately got the following error and crashed Excel! Method 'Hidden' of Object 'Range' Failed I need the code to Hide or Unhide the relevant row based on cell value 0 or >0 I have managed to get the function working with the Worksheet_Activate...