previously

I have a complex formula that was previously working for the last 6 months. Now when I try to run it, it just gives me a #VALUE ! error. The data set over the last 6 months and now is basically the same volume. I haven't change the formula, the layout of the columns, tab names, nothing ...

Hi All, Quite embarrassed with this one but can't for the life of me fix it. I have a VBA script that works perfectly when triggered as a Macro, but fails when triggered by Worksheet_Activate. The line that fails is: dest.Range("A6:M1000").AutoFilter Field:=pn.Column, Criteria1:="" Where...

Row 100 contains the Text "Comments". With the cursor always on row 26 of the active column, the following code is not working correctly Cells(74, ActiveCell.Column).End(xlDown).Offset(1, 0).Select ActiveCell.Value = TextBox1.Value It should put a new value from Textbox1 of Userform1 below...

Please can someone let me know the best way to approach this challenge - I need to create a Master sheet capturing data week by week during the year from another sheet each week. The issue is lining the data when the client's locations will not always be the same (income is against the...

I'm trying to reference a cell in a formula, but the formula doesn't seem to recognize that the cell contains a defined name. I'm running 2010 on windows 7. An example of what I'm trying to do is that I have two names: SEVEN, which =7 and FIVE which =5. The formula =PRODUCT(SEVEN,FIVE) results...

I'm developing an excel application for a variety of users, and as a result several routines require the adaptability to test the location of several key columns of data. The goal with this small function is to identify the column index of a specified column via the header value. By assigning...

Hi, I have been trying to get rid of the table names that seem to be existing, in excel's memory but i cannot locate or find them in that file. How can i get rid of all these previously named taebls and be able to reuse those names again? your help is greatly appreciated! thanks in advance. Krishna

Hey All: Total newb to macros question, so please be patient, trying to learn I recorded a macro that opens and formats a worksheet then saves as a .csv and .xlsx in a specific file path. I sandwiched this recoded macro inside an Application.FileDialog. The problem occurs when running the macro...

Has this happened to anyone else? I am using the same computer and version of Excel as I have when it worked previously. It didn't work yesterday either. My computer was updated over Christmas, but my colleagues are not having the same problem.

Hi, I need help with SUMIFS or equivalent option in excel. There are two conditions. I want to sum total from D and E IF it's not 0 and IF A and B has W or L. So result from the one below should be 30. Previously I had this: =SUM(SUMIF(range,{"<0",">0"})) But I want to add to requirement of...

Hi, When sending an invoice for work done, I use excel to set up an "installment nota" so that the customer has a complete overview of the amounts that are being paid for this month, in addition to the total accumulated charges since the project started. So the workbook usually ends up being...