Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    1
    Views
    85

    Creating charts in every worksheet

    Hi
    The code below runs EXTREMELY slow. Somebody know the reason?




    Sub WorksheetLoop()


    Dim WS As Worksheet, co As Object
  2. Replies
    1
    Views
    138

    Using cell value as an function argument

    Hi!
    What im trying to do is to replace red marked part of the forumula with value from orange cell (look @ screenshot). Value in that cell is a result of CONCATENATE formula and its result is...
  3. Replies
    2
    Views
    1,203

    Index match with mid function

    Hi i cant manage to create index match formula (cell F4). One of the condition to meet by criteria is part of the text in Column D in another file wich should be equeal to 2015. I have never made...
  4. Replies
    0
    Views
    239

    Match index with closest previous date

    Hi!
    Im looking for way to match index from 2 tables with closest day. Screenshot below.
    Imgur: The most awesome images on the Internet
  5. Comparing pivot table and inserting value in cell

    Hi!
    I have 2 pivot tables called:
    in sheet "AKTUALNIE" the name of the pivot = "Tabela przestawna4"
    in sheet "Arkusz1" the name of the pivot = "Tabela przestawna2"

    screens:...
  6. Replies
    3
    Views
    172

    Re: VBA - determine name of the file

    works perfectly thanks man!!
  7. Replies
    3
    Views
    172

    VBA - determine name of the file

    Hi
    In following directory I have file wich in every computer is named differently and I want to write function wich allow me to determine the name of this file. The extension is ".nsf" and its...
  8. Replies
    5
    Views
    471

    Re: VBA - Identify name of the file

    Unfortunently the file name is not same as user name.
  9. Replies
    5
    Views
    471

    Re: VBA - Identify name of the file

    I dimed xxxx as string and pasted xxxx = Environ("username") in the code but error telling me there is no file xxxx in the folder.
  10. Replies
    5
    Views
    471

    VBA - Identify name of the file

    Hi,
    I have following problem. Im sharing some file wich contain macro to automaticly send e-mail from Lotus Notes and I want to make my coworkers to use it. Underlined value in the script is name of...
  11. Replies
    10
    Views
    1,530

    Re: Run macro only if condition is met.

    Hey I made some changes and it finally works as intended, thanks!
  12. Replies
    10
    Views
    1,530

    Re: Run macro only if condition is met.

    Hi, it doesnt work e-mail message is still sending.
  13. Replies
    10
    Views
    1,530

    Re: Run macro only if condition is met.

    The range to check is pivot table in cell N1. If there is no data there like in the picture from first post then macro shouldnt start,
  14. Replies
    10
    Views
    1,530

    Re: Run macro only if condition is met.

    The pivot table range is named "Report" (i defined range as dynamic value so it resize whenever there will be more rows in pivot table).
  15. How to determine if filtered pivot table is empty

    How to determine if filtered pivot table is empty by using vba.
  16. Replies
    10
    Views
    1,530

    Run macro only if condition is met.

    Hi,
    I have following macro wich run 2 macros but I want to check if condition is met before this macro even start. In spreadsheet named "Arkusz1" i have pivot table named "Tabela przestawna 2"...
  17. Replies
    2
    Views
    151

    Re: Macro MsgBox appearing couple of times

    It works. Thanks man!
  18. Replies
    2
    Views
    151

    Macro MsgBox appearing couple of times

    Hi,
    I have macro wich counts how many cells with certain value is in column W and show it in msgbox but whenever macro is runned the message poping 5 times. How to make it show only once?

    Private...
  19. Replies
    4
    Views
    232

    Re: Wich function should I use here?

    Worked like a charm. THANKS!
  20. Replies
    4
    Views
    232

    Wich function should I use here?

    Hello,
    Looking for help on this. I want cell E2 in sheet 1 to show certain "mth" to match "service date" and "serial number" from sheet 2. In result green cells in both sheets should show the same...
  21. Re: Latest date search vlookup and hlookup at the same time

    It works but it doesnt match because if "serial number" is 4536456 it shows last date for "serial number" 234324324 and it shouldnt
  22. Re: Latest date search vlookup and hlookup at the same time

    text but if it could be easier I may change it to date. I just want this to work desnt matter what formating it will be.
  23. Re: Latest date search vlookup and hlookup at the same time

    Yes they are blank but they will be filled in the future.
  24. Re: Latest date search vlookup and hlookup at the same time

    Hi,
    The result of this formula is 0. I enterred as array.
  25. Latest date search vlookup and hlookup at the same time

    Hi,
    Im looking for help on this. I want to always have the latest date of service from blue range of cells in sheet2 to show in column D in sheet1. In this example red cells in sheet 2 should be in...
Results 1 to 25 of 25