not working

I have a SUMIF that is pulling a 10 digit number (6100089103) there are 4 of these numbers that are very similar, replace the last number with 4, 5 and 6. My SumIF is Summing all 4 numbers even though they are not the full number I'm wanting it to pull. Here is my formula: This is a...

Hey mr excel i'm atm working on this code: If Sheets("Counting").Range(i, "R").Value = Sheets("Overview 2014-4").Range("Q1").Value Then Sheets("Counting").Range("S:W").Row.Copy Destination:=Sheets("Overview 2014-4").Cells(Rows.Count, "Q").End(xlUp).Offset(1, 0) End If First part...

I have some trouble with this Code, and i don't know why it's not working?? If Sheets("Counting").Cells("R4").Value = "Amount 2014 - 4" Then Sheets("Counting").Range("S4:W4").Copy Destination:=Sheets("Overview 2014-4").Cells(Rows.Count, "Q").End(xlUp).Offset(1, 0) End If i get...

Using Excel 2013. I have used the autosave function frequently. I know to go to File->Options->Save and enable. -Boxes for for "Save autorecovery" every 10 minutes and "Keep last autosaved version if I close without sending" are checked. -Autorecovery file location...

Hello, Although I've used this forum for years to help me out with several challenges, this will be the first time I actually post a question :) I'm using a PowerPivot table to run a dashboard for production data. In the dashboard are several slicers. The dashboard is has been successfully...

Hi I have been googling and googling for a long time now but cannot find any other with the same issue as me. I have a table (tCableData) with a lot of columns. I'm then doing some lookups in this table to use data from this table on other sheets. I insert a formula like this (in another...

Hi everyone! I'm writing some code to delete hidden rows in a spreadsheet, and it is not working... The worksheet I'm trying it on has a Table (the kind with [@ColumnName] references), which I filtered to show only some rows that match a condition. The others are, of course, hidden. If I run...

Hi I have searched all over the net and found a few threads with the same issue but not one with a solution. My issue is I have conditional formatting controlling if dates should be printed in: mmm, yyyy og dd etc. (for a gantt chart)... this could of cause also be solved by writing a formula...

Hi I am completely new to Excel, but have so far managed to set up a date picker Macro using the Microsoft Month view SP6. However initially neither the Date picker SP6 nor the Month View SP6 controls were available. I had to track them down online and install. However I was disappointing to...

The following code was used to create a chart in excel 2003, but doesn't seem to work in excel 2010? When I run the debugger, the line in red below is highlighted. I am a new user of VBA, please help! Sub TraceXYMulti() Dim myCht As Chart Dim mySrs As Series, Isrs As Integer...

Hello all, I'm currently making an excel spreadsheet that acts as a "dashboard" to useful information. It currently contains over 200 worksheets and I would like for all of them to remain hidden unless a hyperlinked object is clicked on the "Main Menu" that opens them up. Excel will not open...

I am using MS Excel 2010. I have created a custom list with the following data in this order: CY2010Q1 CY2010Q2 CY2010Q3 CY2010Q4 CY2011Q1 CY2011Q2 CY2011Q3 CY2011Q4 CY2012Q1 CY2012Q2 CY2012Q3 CY2012Q4 CY2013Q1 CY2013Q2 CY2013Q3 CY2013Q4 I have selected the entire worksheet by clicking the...

Hi All, I have quite a long Macro which is a little rudimentary. I've been using it for years but have now made some changes to the dates on the sheet to update it ready for this financial year. If I run the macro from within the VBA editor it will execute fine and do everything I need, if I...

Hi All. I'm trying to create a macro that will upoad a .csv file to a folder on my website. I found loads of different version of code to do this and I can't get any of them to work. I admit right here that I am only as much of an expert in this as Googling for 4 hours can make you... so not...

I currently have a set of ListBox controls on a worksheet tab. They are all configured as multi-select and i have the values populated via the ListFillRange properties. Each listbox has an '{All}' option; when the user clicks on this value I want to de-select all other previously selected...

Hi everyone, Wonder if anyone can help. I have the below formula which works fine. =SUM(IF(YEAR('Fixtures & Fittings'!$G3:$G65536)=INDEX!D$17,'Fixtures & Fittings'!$I3:$I65536,0)) However if I copy the formula into another cell it doesn't work? It is exactly the same formula but doesn't...

Hi, In one of my workbooks the undo function has stopped working. Additionally I can not copy and then insert rows/columns. The workbook has no event macros, or any other code to speak of. These functions work correctly in other workbooks. Does any know of a possible cause/solution? I am...

Hello All, I have been using the following sum to calculate the amount of money spent between two dates. =SUMIFS('data'!$AD$2:$AD$184,'data'!$Z$2:$Z$184,">="&A4,'data'!$Z$2:$Z$184,"<="&B4) In coloumn A is the start of the week (date) and in coloumn B is the end of the week (date). I have it...

Hi folks, So im just learning VBA and i thought i could use it to replace one of my more complicated formulas. So basically what this does is calculates the mark to market of various contracts depending on type, pipe, and date. It ran fine for a while and all of a sudden i'm getting gaps...

Hi All, Very frustrating problem: the trace audit tools in my worksheet are all greyed out for some reason (trace precedents, dependents). The worksheet is not protected. It does have probably a couple hundred Index/Match functions throughout the book. I've seen people give suggestions...