Search:

Type: Posts; User: Apple08; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    8
    Views
    120

    Re: Copy/Paste and remove duplicates

    Fab! Thanks Fluff!
  2. Replies
    8
    Views
    120

    Re: Copy/Paste and remove duplicates

    Hi Peter, could you tell me what the sorting code should be added to my macro to make it more reliable please?
  3. Replies
    8
    Views
    120

    Re: Copy/Paste and remove duplicates

    Thanks Fluff and Peter, it works now! Really appreciated!
  4. Replies
    8
    Views
    120

    Copy/Paste and remove duplicates

    Hi all

    I have done a macro to copy data from sheet2 to sheet 3 then remove duplicates, however it doesn't work, please could anyone help?


    Sub Reconcile()

    Dim LastRow AsLong
    ...
  5. Replies
    3
    Views
    54

    Re: If and End with

    Excellent! It works! Many thanks!
  6. Replies
    3
    Views
    54

    If and End with

    Hi everyone

    There is an error 'End if without block if' with the code below:

    Please could anyone help.


    Sub RemoveRows()
    Sheet1.Select
    Dim x As Long,LastRow As Long
  7. Replies
    4
    Views
    107

    Re: Subtotal in the last row of table

    I see, many thanks for your help, I will have a go.
  8. Replies
    4
    Views
    107

    Re: Subtotal in the last row of table

    I just added it as a total row. However I noticed when I put in the subtotal formula with a blank row gap between the last row and the subtotal row, then the subtotal row appears after filtering. ...
  9. Replies
    4
    Views
    107

    Subtotal in the last row of table

    Hi everyone

    I have a table of data for users to filter as necessary, therefore instead of having a sum total at the last row of my table, I put in =subtotal(9,G4:G565) for about 10 columns. ...
  10. Replies
    9
    Views
    221

    Re: Iferror index match formula

    I have now resolved it by removing V&A in the formula!
  11. Replies
    9
    Views
    221

    Re: Iferror index match formula

    Hi Fluff, I finally found out it's the sorting in the macro, once the report is sorted the formulas are messed up. I have now moved the sorting before the input of formulas, however I have a...
  12. Replies
    9
    Views
    221

    Re: Iferror index match formula

    I wonder am I possible to send the worksheet to you for checking
  13. Replies
    9
    Views
    221

    Re: Iferror index match formula

    No there are no merged cells
  14. Replies
    9
    Views
    221

    Re: Iferror index match formula

    Thanks Fluff. The formula in I2 and J2 appears as =IFERROR(INDEX(Cost!$A:$C,MATCH('V&A'!$E4,Cost!$A:$A,FALSE),3),"")

    it should be V&A!E2

    The formula in I3 and J3 appears as...
  15. Replies
    9
    Views
    221

    Iferror index match formula

    Hi everyone

    I have a problem to copy and paste in the index match formula to the last row. I suppose I2 and J2 formulas should be pasted in until the last row. however I noticed the macro below...
  16. Replies
    2
    Views
    139

    Re: Lookup formulas in specific columns

    I prefer a macro as the report is to be setup for another team to use and columns in the report are various due to individual customise setting from the raw data report.
  17. Replies
    2
    Views
    139

    Lookup formulas in specific columns

    Hi Everyone

    I have two spreadsheets. Sheets(1) is with unknown number of columns and rows. Sheets(2) is a list of profiles and rates. I need to look up the specific rate in Sheets(2) for the...
  18. Replies
    17
    Views
    447

    Re: Userform dependent Comboboxes

    I just noticed the texbox numbers have been changed while I moved around textboxes. They work now. Sorry for the confusion. Many thanks for your help!
  19. Replies
    17
    Views
    447

    Re: Userform dependent Comboboxes

    Thanks Fluff, I have amended code below, however only TextBox 3-5 work, but not TextBox1 and 2, have I done something wrong:


    Private Sub ComboBox2_Change()

    'input budget...
  20. Replies
    17
    Views
    447

    Re: Userform dependent Comboboxes

    Thanks Fluff, I have done the code below but it didn't work, it works with only the TextBox1.value is added, but it didn't work after I added in Textbox2 to 5. Please could you let me know what I...
  21. Replies
    17
    Views
    447

    Re: Userform dependent Comboboxes

    I need to match with different sheets to retrieve data, once a Portfolio, project and financial year are selected then I need to retrieve budget data from sheet budget, other monthly data from sheet...
  22. Replies
    17
    Views
    447

    Re: Userform dependent Comboboxes

    Many thanks, however I have to match up quite a number of textboxes, due to my limited understanding of the code above, am I able to use something like if comboboxes value matches with...
  23. Replies
    17
    Views
    447

    Re: Userform dependent Comboboxes

    I am now able to get the combobox value, however how can I get the data in column E (textbox1) based on the combobox2 and 3 value please?
  24. Replies
    17
    Views
    447

    Re: Userform dependent Comboboxes

    You are brilliant, many thanks!
  25. Replies
    17
    Views
    447

    Re: Userform dependent Comboboxes

    Thanks Fluff! It works perfectly!

    Please if I want to add more dependant comboxes, e.g. combobox 3 data in Column D depends on combobox 2, how should I edit the code? Many thanks.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4