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