Search results

I want to have the user name from Microsoft Office populate in cell F14. I have never written VBA code before. I put this code into visual basic module: Function GetUserName() GetUserName = Application.UserName End Function Then in F14 I put =GetUserName() What am I missing??

well, I've done my testing and it's perfect! Thanks so much!

DANG! Luke, that's it!!! I'm gonna play a bit more fudging some dates for testing. :-)

AHA!!!! It works! Using this formula: =IF(ISNUMBER(MATCH($D$16,$A$18:$A$42,0)),"LQR",IF(ISNUMBER(MATCH($F$16,$A$18:$A$42,0)),"SOP","N/A")) And changing the date to include DAYS I get the appropriate value!!!! Um...but I don't want to match the DAY of the evnet, jsut the MONTH of the event.

Fred I think you have it! now that I have expanded the date to include days Cell D16 is June 15, 2012 and cell A27 is June 7 2012. That being said....I don't want to match the DAY of the event, just the MONTH of the event. Any suggestions?

Luke - I applied your formula and it comes back as "FALSE". See the bold text in my prior post. Those are columns D16 and A27

PPAP: Sep-11 LQR: Jun-12 SOP: Aug-12 Date Milestone Height Dummy Milestone Sep-11 PPAP 1 0 PPAP Oct-11 #N/A #N/A 0 #N/A Nov-11 N/A #N/A 0 N/A Dec-11 #N/A #N/A 0 #N/A Jan-12 #N/A #N/A 0 #N/A Feb-12 #N/A #N/A 0 #N/A Mar-12 #N/A #N/A 0 #N/A Apr-12 N/A #N/A 0 N/A May-12 #N/A #N/A 0 #N/A...

so the new formula looks like this.... =IF(ISNUMBER(MATCH($D$16,$A$18:$A$42,0)),"LQR",IF(ISNUMBER(MATCH($F$16,$A$18:$A$42,0)),"SOP","N/A")) I did that but it's not working. It still comes up saying "N/A" in cell A27 where I KNOW it's a match to D16

I tried this but it doesn't work. Fred, you are correct in my question. I want to find out if there are any dates in columm A 18-42 that match D16 or F16.

I tried using google docs for sharing my file but I keep getting an error message. I still don't have a formula for my initial question. I'm hoping someone comes thru for me.

Shoot, it's tough being a newbie. :-) Let me try to clarify. HUI...in response to your question above....yes, the value in mainsheet K2 is a date. My objective is to get all column A cells to validate if their value matches the value in D16 or F16. I'm gonna try to post my workbook, have...

Fred thanks for you quick reply. I have to leave work in a few minutes but I will check back here tomorrow.

Hmmm....I'm getting an error that says "a value is not available to the formula or function"

Well, I guess its in the subject line really. Sorry about that. How can I get all of the cells in column A to validate whether they match the “LQR” date that is in D16 or the “SOP” date in cell F16?

I have a workbook (tracker) with a “Main Sheet” where all of the user data is entered. I want some of the information to roll up into my “Program Status” worksheet. Cell D16 has a simple formula to pull a date from the “Main Sheet” D16=’Mainsheet’!K2 In column A I have 2 years of monthly...