• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by Howardc

  1. H

    Setting up a check box

    Hi SisJB7 Thanks for the information, much appreciated
  2. H

    Setting up a check box

    Hi SirJB7 Thanks for the help much appreciated. If new data is imported into column C , will it still work? In the live data, the existing account numbers are in Col E and the imported account numbers are in col EP. I wanted a way of ensuring that if I checked the col containing imported...
  3. H

    Vlookup question

    I have the following Vlokup formula VLOOKUP(A5,$L$11:$U$171,10,FALSE) I would like to change the Vlookup to combine with another formula to lookup at the column offset number for Col U starting from Col L i.e 10 instead of having to manually count the cfol offset in this eg ,10 Your...
  4. H

    Setting up a check box

    Hi, SirJB7 I have uploaded a new workbook in drop box 1) I would like a check box in Col A 2) If an item is checked, then Col B must state "Account mapped" , if unchecked "New Account" Your assistance in resolving this would be most appreciated...
  5. H

    Setting up a check box

    Hi Hui Have you managed to have a look at my reply regarding setting up a check box? You assistance in this regard is most appreciated
  6. H

    Setting up a check box

    Hi Hui Thanks for the reply. I have posted a sample of the workbook on dropbox. Your assistance is helping me set up a checkbox will be most appreciated https://www.dropbox.com/s/2peq5esnfgcmmgf/Account%20Numbers.xls Regards Howard
  7. H

    Adding up values based oncertain criteria

    Hi Hui Thanks for the reply, much appreciated
  8. H

    Adding up values based oncertain criteria

    I would like a formula to add values which are in Col E based on account numbers which are in Col D for eg the account number series are 3099 to 3199 (these are four digit numbers) 3000D to 3199D (these are 5 digit numbers all ending with a D) 3000K to 3199K ,3000A to 3199A I need a seperate...
  9. H

    Setting up a check box

    I would like to have a check box in Col D , which is in the column next to the account numbers to ensure that all the account numbers have been mapped i.e being taken into account. A trial balance is imported into my management accounts workbook each month and if any new account numbers have...
  10. H

    VBA Code to Create Pivot Table

    Hi SirJB7 Thanks for the reply Regards
  11. H

    VBA Code to Create Pivot Table

    Hi SirJB7 Thanks for the reply. The reason I ran the macro twice was to ensure that it is working properly
  12. H

    VBA Code to Create Pivot Table

    Hi Luke I have tried to record a macro to create a Pivot Table for sheet purchases. The Pivot table was created perfectly when recording the macro (source data sheet “imported data”) However, when running the macro a second time, it comes up with run time error 5 and the following...
  13. H

    VBA Code to Create Pivot Table

    Hi Luke Will record macro and if I need any further changes, I will get back to you
  14. H

    VBA Code to Create Pivot Table

    I would like VBA code to delete the current Pivot table sheets and to create two Pivot table sheets-see sheet "Purchases" & "FA-YTD Dep" The Pivot Table-"Purchases" must contain the following:Asset Type, Capital Cost, financial Year The Pivot Table FA-YTD Dep must contain the following:Asset...
See more
Back
Top