excel-2013

I would profoundly appreciate assistance from anyone regarding dynamically updating the X-Axis value of an Excel Bar-Chart via EITHER in-sheet formulae OR via VBA-code. I've unsuccessfully tried the following: ---Created a named-range on the 3 in-sheet cells (Q2, R2, & S2) which will always...

So this formula works great. It looks for apple in a range and returns yes if it finds it. However, I would like to be able to look for multiple things and return yes if any of the items are found. If possible I would like it to return the value of the first one found...

I have named multiple cells different names, but they all include the same format. for example: hello_2_hi hello_4_meet hello_2_me is it possible to replace "hello" to something different all at the same time? NOTE: I'm talking about the cell name, not cell content.

<tbody> own vofavorite I have been working in <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space...

OK, I really did look for the answer for this, but after about 2 hours of reading posts, I'm no closer to the answer. :( I am trying to open a second workbook from the one with the VBA in it. I need to set that other file's name in one place so someone else could edit my code if they exporting...

Hi Everyone, I'm drawing data from a website that requires login credentials to access. When I initially set up the queries I navigated through the portal that appears when you select the From Web option under Data, inputting my username and password to get onto the site and then navigating to...

Hi Everyone, Quick question, what is the easiest way to have a monthview control default to the current date when it's launched? I know I could do something like MonthView1.Value = Range("A1").Value And have A1 fill with the current date, but I feel like there must be a way to do this...

Hi Everyone, So I have a MonthView userform set up with the multiselect option enabled. I'm trying to get the start date and end date that the users select into two different cells on the worksheet (let's say A1 and B1 for example). From what I've looked up I understand that you can get the...

I have a system I have created overtime that puts email data onto an excel spreadsheet. This is great but what I would also like to do after this has run is extract the emails including any attachments from Outlook into a new folder on my Windows PC and then add an ID onto it which is put...