Recent content by PNGBill

  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...
Top Bottom