Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: Vba for each cell in rng insert dynamic formula

    ThA k you Dante
  2. Re: Vba for each cell in rng insert dynamic formula

    Thank you igold ��
  3. Re: Vba for each cell in rng insert dynamic formula

    Hi igold

    Many thanks for this, however I need to paste the values from the formula into each of cell before moving onto the next one, is this something you could help with 😊.
  4. Vba for each cell in rng insert dynamic formula

    Hi all,

    this might be simple but can’t get my head around it.

    i would like to put a formula into each cell within a range (B2:AZ517)

    Then paste the value then move onto the next cell.

    The...
  5. Re: Filter Table save as new workbook in same folder

    Many thanks Dante ��
  6. Re: Filter Table save as new workbook in same folder

    Hi

    Sorry for not being clear. I have one sheet with all the data. And one sheet(“Names”) in range A2:A21 with all the managers name I need.

    I like to create a workbook for each manager with...
  7. Filter Table save as new workbook in same folder

    Hi all,

    I wonder if someone could help.

    I have a table in Sheet “Final Filtered” range A1:S510. I like to create a new workbook and filter by manager which are in column G. Sheet “Names” rows 2...
  8. Replies
    6
    Views
    218

    Re: Conditional formatting formula for cell

    Brilliant thank you so much ��
  9. Replies
    6
    Views
    218

    Re: Conditional formatting formula for cell

    Thanks for replying

    https://www.dropbox.com/s/gbc9lkfd6memmyx/IMG_5177.jpg?dl=0

    Ill try to explain. Basically the story is.... there is a school trip and only certain number of pupils based on...
  10. Replies
    6
    Views
    218

    Conditional formatting formula for cell

    Hi all. Wonder if anyone can help.

    How do you put this formula into a conditional formatting formula based on if the answer is “Pass” the cell is green, “Inter” the cell is yellow and fail it’s...
  11. VBA Loop thorugh Files in folder and emove all non letters and numbers in file name

    Hi everyone,

    Been a while since I posted.. but need some help please.

    I would like to rename / remove all non letters/numbers in a name file basically remove all symbols from it. in a given...
  12. Pivot table formula to work out year on year performance Like for Like

    I have this type of information in a table. put into a pivot table.
    Is there a way of using pivot table formulas to work out LFL perofrmance
    formula would be ((this year-Last Year)/Last Year)
    ...
  13. Replies
    1
    Views
    105

    Userform listbox

    H all,

    i am after a bit of code that when a checkbox is clicked a listbox will appear on a userform.

    Can an anyone help please
  14. Re: Vba code to change checkbox colour when ticked

    Thank you
  15. Vba code to change checkbox colour when ticked

    Hi guys
    wonder if you can help.. Does anyone know what the code will be to change a userform checkbox to green when selected.

    regards
  16. Formula to copy across columns for football comp Cell reference error

    Hi all,

    Wonder if you can help.

    Trying to find a formula that be copied across columns to split a string containing numbers into two adjest columns. however to my frustration when I try to...
  17. Re: Pivot table Help : Change Column field values

    Can anyone help with this?

    Thank you
  18. Pivot table Help : Change Column field values

    Hi all,

    I need your help. I have a pivot table depts in the rows and week numbers in the columns. I need to change the amount week numbers shown depending on the selected week number.

    eg if...
  19. Macro for PowerPoint slides from excel name list

    Hi everyone

    wonder if you can help I want to create slides from a master slide and adding names from a list in excel.

    Does anyone one know a macro that can do this . I've got 200 names and...
  20. Replies
    4
    Views
    662

    Re: FreeMapTools - vba to click show button

    Thank you very much
  21. Replies
    4
    Views
    662

    Re: FreeMapTools - vba to click show button

    Im getting an an error with
    Dim inet1 As Inet
    Dim mypage As Variant




    Set inet1 = New Inet
  22. Replies
    4
    Views
    662

    FreeMapTools - vba to click show button

    Hi all

    wonder if you can help. Im trying to set up a problem that will use freemaptool website to find distance between 2 postcodes.

    however I need a command to click the "Show" button on the...
  23. Re: Work out amount of hours in given time slot

    Thank you great stuff
  24. Re: Work out amount of hours in given time slot

    Hi andrew thanks for the reply. How do I measure how many hours there are per time slot.

    is there a formula I could use.

    if someone works 1000-1900
    between time slot 0900-1200 will be 02:00...
  25. Work out amount of hours in given time slot

    Hi all,

    i would like to workout how many hours per time slot.

    but the format is in 1000-1900

    the time slots will be:
    0900-1200
    1200-1800
    1800:2200
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4