Search results

Thank you Debraj. This worked perfectly! I appreciate your help!

Hello, Happy Monday... HAHA! Oxymoron.... :rolleyes: I need to add a name to the dialog box that opens with the below code. I do not want it to say "Open". I want it to say "Open Anchor File". Please help. Here is the code. MsgBox Application.Dialogs(xlDialogOpen).Show(arg1:=Filename) I...

Thank you, utsav! This worked great! Have a wonderful day!

Hi utsav, no that did not work. It cleared the data in A2, but did not input what I entered into the inputbox. I attached the file and the macro... EDITED (SirJB7)

Good Morning, I am stuck. Can you please help me?:( I have written this code, but am at a loss as to how to actually make what they enter populate in Cell A2. Or How to make it a mandatory enter, (Loop) Dim Month As String Dim p As String p = "Enter first day of the last...

You my Friend are an absolute genius!!!!! Thank you so much! I am quite grateful for the help! Have a great weekend all!

Good day everyone and Happy Friday! I am trying to build a rather large complex nested IF statement. I have 49 different options that I need to reveiw for in column collection (or single cell) These are listed in the cell as shown below. And since they are in a single cell combined as they are...

This is fantastic! Thank you, I was able to take this detail and change it a bit to meet a new requirement. But just having this guide was exactly what I needed and fantastic! Thank you again for helping me. Have a great day!

Good afternoon. Thank you for taking the time to assist me. I have a chart that I need assistance with please. My chart shows two data points, 1. Actual Score 2. Goal I have 33 different departments that I am tracking, and need for them to reflect in the chart when we meet or exceed the...

Hello, I am new to Chandoo but am already a fan! @SirJB7 was great at helping me with my first question. I am going to spend some time trying to solve the next one, but may be back tomorrow. I love Excel, and just recently started a new job where I am finding out all the wonderful things about...

I apologize for missing the introduction. My Name is Samantha. I am extremely grateful for your help! I spent about 3 hours trying and searching for a solution to this and was unsuccessful, however your first suggestion worked perfectly! I cannot thank you enough! I was able to input the formula...

Hello, I have a spreadsheet with two tabs. Tab one has a value that is brought in from tab 2 using =IF('Tab2 '!B23<>"#DIV/0!",Tab2'!B23,"-") Oridinarily this would work just fine, however my problem is that the data in Cell B23 is a formula of =B21/B22*100 which will return the solution...