• 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.

Search results

  1. J

    get data from cell depending on dates from array of cells

    Alan or anybody, I have tried to modify the above successful code that prints to 7 day forcast sheet to do almost the same for 7daySMMP check. What I need is for a macro to work with (see the attached sheet) having the output basically the same but with the following criteria. If todays date...
  2. J

    get data from cell depending on dates from array of cells

    Is it possible to use the output data from the above to place into a monthly calendar so I can use it for assignments for staff? I know I will have to modify the original code to cover more days but I need it to auto update bi-weekly calendar.
  3. J

    get data from cell depending on dates from array of cells

    Sorry, I have not been on for awhile. I figured it with your help of course, thanks.
  4. J

    get data from cell depending on dates from array of cells

    I am trying to get this info for 5 days now and when I add For Each c In rng lr = s2.Range("D" & Rows.Count).End(xlUp).Row If c.Value = s2.Range("A1") Then r = c.Row x = c.Column s2.Range("D" & lr + 1) = s1.Cells(r, 2) & s1.Cells(2, x)...
  5. J

    macros with arrays and other functions need explained

    If your still around and have a mind to would it be possible to tackle the index and small? Your teaching method was great for me.
  6. J

    macros with arrays and other functions need explained

    I know I am several days late but I just found I did not respond appropriately to this reply, It is great and just wanted to make sure you knew it was appreciated. Thank you and again sorry for lateness.
  7. J

    get data from cell depending on dates from array of cells

    Both work great and thank you. Additionally I would like to get the name out of the corresponding row at the top of the column with the date as well. I have attached the file with what I would like sheet to be. Thanks for looking
  8. J

    get data from cell depending on dates from array of cells

    Thank you very much, I got it and it works great
  9. J

    get data from cell depending on dates from array of cells

    I am uneducated in excel, where do I place this. I am sure not in a cell. I opened VBA and added module in sheet 2 but do not know how to get it to run
  10. J

    get data from cell depending on dates from array of cells

    I have todays date in a1 I have names in b3 to b25 (not every cell will always have a name, can be empty) I have dates spread throughout cells F3 to AZ25, also have cells with initials and blank cells. (All cells in array have formulas in them.) On sheet2 I want to compare todays date (A1) with...
  11. J

    macros with arrays and other functions need explained

    For the GURU I have the following two macros/functions in my workbooks and want to expand and or modify what they do. I thought I could figure it out but to no avail. Is there anyone out there that can break these down for me so I can tell what each function does so I can work with them and...
  12. J

    Link Excel sheets to Powerpoint for slideshow

    bobhs, I tried to get a dropbox account but they wanted me to sign up for 9.99 a month. I can not do it at work as the site gives a virus warning error, probably having to do with the security settings. Thank you for your help.I have a gmail account, but don't know if we are supposed to leave...
  13. J

    Link Excel sheets to Powerpoint for slideshow

    bobhc, Thanks, I found at work I have Office 7 on XP 2002 and not much seems to be the same. When I copy just area I need on slide and try to paste I do not get the paste special. I use insert object, excell file and link, it pastes in slide and updates when I change file. I insert object into...
  14. J

    Link Excel sheets to Powerpoint for slideshow

    Hello I have a followup with this topic. Like I said it works but I have multiple sheets in my workbook and I need each sheet to fit on a slide. When I change sheets in excell then the sheets change on the slide in Powerpoint as well. Don't know if I forgot something when I pasted. I do...
  15. J

    Link Excel sheets to Powerpoint for slideshow

    Good day to you bobhc, Thank you for your response. I tried it on a quick workbook I have and it worked so far. Thank you for your help, it is greatly appreciated. I am new to this advanced features of excell and powerpoint so I will for sure be having many questions as I wade through my...
  16. J

    Link Excel sheets to Powerpoint for slideshow

    Hello, I have an excel workbook with multiple sheets that I want to make a PowerPoint to display on a monitor in a dayroom that is hooked to a computor. I need each sheet to fit on one slide. The sheets are updated on a shift by shift basis and need this to be active on slideshow also. I would...
Back
Top