Search results

  1. P

    Sumifs with multiple Criteria

    This works =SUMIFS(Data!$D$7:$D$150000,Data!$B$7:$B$150000,">=01/01/2019",Data!$B$7:$B$150000, "<=31/12/2019",Data!$F$7:$F$150000, Customers!A7) Not sure why but on this attempt I didn't type the last part of code.
  2. P

    Sumifs with multiple Criteria

    Hi Forum, This Sumfs sums the sales amounts in Sheet Data Col D where customer name Sheet Data Col F matches with current sheet (Customers A7 - Works well. =SUMIFS(Data!$D$7:$D$150000,Data!$F$7:$F$150000, Customers!A7) This Sumfs is similar but sums all the sales amounts for 2019. Sheet Data...
  3. P

    Update Cells from Another Workbook

    Hi Forum, I have a Worksheet (A) with 50,000 plus rows and the records have been updated. Headings are Invoice Number, Part Number, Sell Price & Cost Price, Customer, plus the updated column. This Workbook / Worksheet is copied from another Workbook (B) that downloads from a Database. The...
  4. P

    KeyPad Error

    Just realised the code is xl (XL) not x1 :banghead:
  5. P

    KeyPad Error

    Hi Forum, Learning Excel VBA and I could not get code to run. Copied code from file and it worked. Trial and error proved the problem was my keyboard typing number one "1" was not accepted. The copied code 1 and my 1 look exactly the same but must be different behind the scene :eek: Anyone...
  6. P

    Investment Property Software

    Hi, I am looking for software to keep track of our investment properties income and expenditure. Anyone have suggestions on this. Want to avoid the monthly rental versions. Appreciate advice.
  7. P

    Find Cell Value. and perform Loop

    Thanks June7, Your help is much appreciated. The Project was never going to be easy as the Raw Data was not good but at least we have a result better than guess work. The Data is nearly 70,000 rows but we do not have to run every week. Maybe once or twice a year.
  8. P

    Copy New Data Only ??

    Hi Forum, Is it possible to Copy Rows from Workbook A to Workbook B where they do not already exist in Workbook B ? Workbook A is populated by MYSQL from a Database and overwrites data. Workbook B has 5 Columns from Workbook A. It would be great if the code to Copy from Workbook A to Workbook...
  9. P

    Find Cell Value. and perform Loop

    Thanks again June7. Just got up and will try again in a hour or so when at work. I was thinking... Should the Sheet be Sorted first ? Sort by A Descending then E Descending. Run through the records and where an x is found, check the next record and if value in A is the same, then x E, check...
  10. P

    Find Cell Value. and perform Loop

    Just realised my Software details were out of date. Now using Win 10 with Office 2016.
  11. P

    Find Cell Value. and perform Loop

    Thanks again June7. I don't have ActiveX Data Objects x.x Library 2.0, 2.1, 2.5, 2.6, 2.7, 2.8, 6.1 plus ..Objects Recordset 2.8 Library & 6.0 Library
  12. P

    Find Cell Value. and perform Loop

    Thanks June7, Some records in the last column have an x. Where a row has an x. All Rows with the same reference in column A also need to have an x. This is Sheet1. Trust this helps and many thanks for your assistance. However we need all of the rows that have an x in one or more
  13. P

    Find Cell Value. and perform Loop

    Macro is IdentifyInstalls()
  14. P

    Find Cell Value. and perform Loop

    File attached :)
  15. P

    Find Cell Value. and perform Loop

    Here is my code so far. It works to find the Rows with "x" in Column 5 - E. It appears to identify the Value in Column 1 - A for this Row. I have inserted i2 to then process the worksheet to change the value in E where the value of A is SORef. Of the 20 records it should have added x to all...
  16. P

    Find Cell Value. and perform Loop

    Thanks June7, Was hoping for some basic code examples and then I can take it from there. Became skilled at Access VBA although not used same for 5 years :( but Excel has different commands.
  17. P

    Find Cell Value. and perform Loop

    Hi Forum, I need to check records in an Excel 2016 file - Column D. If this is "X" Then I need to save the Cell Value Offset -4 - Column A to Variable "SORef" Then I need to Loop through all Rows in Column A with the same "SORef and change the Cell Value for Column D to "X" This may mean...
  18. P

    Hello from New Zealand

    Hi All, I have been away from this forum for a long time. Haven't used Access for a number of years - Time flys. Good to see some old names still posting. All the best from Tokoroa New Zealand. Bill
  19. P

    Form Control to display in Form or be invisible and other Controls to use space

    I moved the Line to the Top of the Detail Section and took out any code to change it's position. The Expand and contract facility works well now that it does not also need to move the line. there should be a way to move the line but it appears fine at the top.:)
  20. P

    Form Control to display in Form or be invisible and other Controls to use space

    Thanks JHB, Your sample works perfectly. My problem may be the Line. I Will take my line. It may be preventing the Detail from shrinking. I will try some more in 24 hours. Appreciate your assistance.:)
Top Bottom