issue

Hi All, I have a strange issue with a dropdown list. I have 3 dropdown list: 1. Dropdown 1 (B5) is independent (static List) 2. Dropdown 2 (C5) is dependent on dropdown 1 (using a named range to get list based on dropdown 1) Named Range Formula: =OFFSET('Drop Down...

I extracted some code from my project and created an Excel Add-In with it. The project now references the Add-In and everything seems to work fine, however if I completely close down Excel and try to open the project directly, Excel crashes. If I open some other Excel file or create a Blank...

Currently, we have a macro that stops and forces you to save the file when it switches between windows. We'd like it to be able to run all the way through without forcing this save option, any help on resolving this issue would be greatly appreciated. I've attached a portion of the VBA code and...

I was try to get a file from our network drive and try to access it from there. then i got the issue : Microsoft Excel cannot access the file "https://service.intralinks...." then the excel file is not responding . i thought that would be account or network issue, so i have login to...

I would appreciate someone sharing their Hyperbolic Decline macro or equation. Q=Qo/(1+Di*b*t)^(1/Di) Where: Q=production rate Qo=initial production rate Di=initial decline rate b=decline rate t=time My issue is D change at each time step Trendline doesn't have the Hyperbolic Decline option

Hi I have some issue with wrapping text. In the sheet below. Cell B7 has 5 lines. When I resize column B (make it wider). I will still have 5 lines and each line will have more white spaces. Why is that? why some text form the second line join the first line to fill the white space? Also cell...

I have a template (*.xltm) which has a few different tables in it, each table is named based upon what it is used for. Example: tblDates; tblLocations; tblStatus; etc A number of in-cell formulas reference the tables by name and their contents. When I save the file, it gives it a unique file...

Hi, When I open an excel workbook, I get the message "Sorry, we couldn't find \\...\hstbar.xla Is it possible it was moved, renamed or deleted?" Does anyone know what the issue is or how to fix this? Thanks

Hi there, I am trying to use Solver for portfolio optimization. I'm using 9 stocks and Solver runs fine when I try to optimize for the lowest monthly draw-down using all 9 stocks (it gives a weight to each stock from -1 to 1. Where I run into an issue is if I add a constraint that requires that...

Long story, but will try to make the explanation brief. I work with an individual customer and provide information on a daily basis. normally we enter our info into a database and the customer imports into their own and then does what they want with the data. This particular customer (same corp...

Hi I require a little help (scrub that change little for a lot of) please, trying to write a formula where is looks at 2 non adjacent cells in one tab, and looks in another tab to see if it can find the same info, if it does then to put from the 2nd tab another cell value. So in (tab1)W1 IF...

So, received a bunch of help in my other thread on how to set up some formulas to only look and count certain values that we use for tracking maintenance performed at our Job Sites. The only issues i have left is when tracking 200 and 2000. So, i have the one formula that successfully sees...

I am trying to create a formula to convert data in C1 to something else in C2, for example. I am working with wood/board lengths. If in C1 I enter 2 x 4 x 91.5", I want the same data entered into C2 but converted to 2 x 4 x 8’ or 2 x 4 x 96”. C1 will contain an actual measured length needed...

Hi All, Im sending an email from excel using some sort of formula. In my body of mail 1st I have some content then few pictures then followed by that some content and below that I have a textbox in which I have a hyperlink. Im successfully able to paste the entire content in email and able to...

Hi All, Thanks for putting in time for viewing my post. I am stuck with a runtime issue, the bit of code that seems to be causing an issue is the text below in bold "DoCmd.SetWarnings True strFile = arwGetPersonalFolder & "\BromptonLungFunction.xls" ' &...

Hi all, I am having a minor issue with a function for concatenating a range into a comma seperated list. The function is as follows: Function ConcatUniq(xRg As Range, xChar As String) As String Dim xCell As Range Dim xDic As Object Set xDic = CreateObject("Scripting.Dictionary")...

I am having 2 issue with my conditional format formula. I am trying to work out a formula that allows me to detect new entries daily. So what if i put an entry in today tomorrow it would be gone until a new entry was made that day. Below is what i have already but it seems to be constant...

HI All, I have slightly long formula but i have some issues with #Div/0! fault in some of the returns. Do you know how I can adjust formula to return 0 in case of issue ?:confused...

Hi, Can you see file below, and advise how I can add codes (as the clicked event) to the button within Ledger sheet? https://1drv.ms/x/s!Ai8CrEskdewXngRR6DYl8WCGYsQY It seems also the below codes do not copy the values of cells properly. Any idea...

Hi All I've been using Excel on Mac for many years and never had this issue till now. It's probably more that I don't understand than an issue. I have always been able to double click on sheets in Excel Objects, they would open in a window with a gray title bar and the option to close, min or...