Search results

Luke, Now Cell A3 in my destination sheet is 1. I feel like if I could explain better you would be able to help me. I want all line items in my Action Item Matrix where colum B = 1 to populate my destination workbook.

Here is what I did IF('[Action_Item_Matrix.xlsm]ACTION MATRIX'!$B$3=1,'[Action_Item_Matrix.xlsm]ACTION MATRIX'!$A$3:$M$3,"CRAP") The destination cell is now just a 1. Maybe I can explain it differently. I have workbook A and Workbook B. Workbook A has all of the data in it, North...

Thanks Luke. I need the entire row copied to destination workbook if this formula is true. This is hard to explain.... =IF([Book1.xls]Sheet1!$A$1=4,[Book1.xls]ENTIRE ROW,"")

I want to take information from an existing action item workbood and populate another workbook. Basically, I'm looking to put an equation in the destination workbook something like IF(workbook D column A row 1 = 4 then populate workbook F with line 1 of existing workbook #4 data, "") Any ideas?

I can't figure it out. Thanks anyway Luke

I fooled around with this but couldn't figure it out. I was hoping it was simple. Nothing as easy as telling excel that if cell A has text then put picture in cell B?

I would like to know how to put a picture in cell A when there is text in cell B. What text in cell B doesn't matter. If cell B has any data at all in it (not blank)then cell A should have engine picture in it. Thanks!

Whooops! Ok..this worked until I got to 3/12. Then it became 1/4. Apparently it's dividing to the smallest FRACTION. Any other ideas?

THANKS!!!

I want to use a cell to show completed vs. due. So...I have 12 tasks and 2 are done. I want to show it as 2/12. But when I do that I get either 40586 or 12-Feb(date). How can I format this to show the 2/12 that I want? Thanks!

My boss just came by to ask me to put together a chart for our project. He want's dates to be the value on the chart. So I have events that need to be captured with the planned, actual and projected dates. Our company is nutorious for running behind on projects and he wants the timing...

OK...I'm back. I am using the chart type that Luke M suggested. It's exactly what I want. I am having difficulty with the "named range" part of it. I need to make the drop down list like Chandoo is showing. I can't get the named range part to save or something...it doesn't show up in the...

Luke, I meant Check boxes not text boxes. OK...I followed the directions in the link above that HUI posted. I'm at step 4 and don't know what the formula is supposed to do. The instructions say to load the table up with formulas....what would the formulas be?

ACK! I was over thinking it!

OK...I'm stuck. How do I link a text box to a cell???

I'm gonna give this a try. Not really what I was intending but it's gonna make the boss drool! I'll let ya know.

I have several charts relating to employee responsibility. The charts are used to help track progess of these employees. For example: Sally Smith is 20% complete with A, 40% complete with B and 0% with C. Diane D. is 0% complete with A,B and C. In this example I don't want Diane D.'s...

I'll check back tomorrow. Thanks

Here is what I just tried: Function test() test = Application.UserName End Function Same result. I did find 3 functions in the User Defined category. They are all the same cuz I've been working to get it right. Should I delete 2 of them? If so how do I delete them? :-)

Yeah, the code is still "=GetUserName()" after I save it. One thing tho...I notice that the type ahead feature brings up lots of suggestions for putting my code in F14 like "getpivotdata" but "GetUserName" does not pop up in the type ahead suggestions. Oh..I don't think you are condescending...

Well, when I insert a comment it comes up with my first and last name... "Diane xxxxxxx"

Um....just went to save it and now the #NAME? error is back in F14 again. I didn't rename it, just saved it as same file (.xlsm)

OK...did that and now I'm getting a 0 (zero) in F14.

OK Luke, I did that. I'm getting the same error. I don't know diddly about writing VBA code this is my first attempt. Do I have to save the code first? If so, how do I do that?

#NAME is the error message. Shoulda stated that, sorry. Hmmm...I went in and checked and it says Sheet12. When I created it I went to my spreadsheet and double clicked the "Visual Basic" icon. Then I pasted the code in.