Search results

Afternoon all, In our organisation, one department has a system that require Excel to be in manual calculation mode. Which is a pain when they send you a file and and it knocks it off on all your own files. I'm looking for a simple way to identify this, maybe being able to change the colour of...

This also works, 57. Out of interest is there pros and cons of using Sumifs V SumProduct? Cheers

Works a treat, thank you very much. Like the logic, I'll be able use that going forward :)

Cheers

hello all, I was wondering if it was possible to lookup a date value in one column, then sum the values in the next column for variable number of rows, eg. Data DATE PRICE 01/4/15 10 02/04/15 11 03/04/15 11 04/04/15 10 ... Then i have cells with date and number of...

Cheers Luke - I got so obsessed with "It works on another file" I didn't see the obvious. Appreciate the help.

Afternoon, I need some help with what I thought was a simple refresh. I'm trying to create a button that will update the data in a hidden sheet. I use this same code in a different file and it works fine, but this new file is using a data table. ActiveWorkbook.Worksheets("2015...

Hi, I've got a file that prepare a report pack and prints, various reports. Someone has asked to have a pack excluding a few reports, so I thought I would add a checkbox next to the report list. Just been testing this and it doesn't like it. My VBA knowledge is light, but thought this was...

Hi, I've just completed a rather large product/pricing model and realised that unless I have something that allows the actual data (formula) to be pasted as values, I will have do a lot of manual copy/pasting everything I open a file. This is way beyond my VBA skills (even been generous to...

Cheers Luke, thanks for you help. i would have struggled with "and" bit!

Actually been trying to figure it out, I'm able to show the totals, but struggling with not showing 0Total Sub ShowTotals() ' ' Application.ScreenUpdating = False Range("B4").Select Selection.AutoFilter Selection.AutoFilter Field:=1, Criteria1:="*Total" Range(Selection...

Hi Luke, thanks for the reply. Yeah i though of this, but the length of the product list is inconsistent, I'd prefer something more robust in case list become longer than recorded macro. Cheers Paul

Hi all, I have a large list of products, each with a product total line, e.g. Product1 Product1 Product1 Product1 Total Product2 Product2 Product2 Product2 Total I'd like a button to be able to filter to only see the total lines. It need to ignore "0 Total" as i have a few blanks. Any...

Hello all, I'm trying to link to an external file, but using the data in a cell to reference the sheet name: So this formula works, as it is referencing the file/sheet - the Product Sales.xls file has 24 sheets, one for each product. =VLOOKUP($C$4,'[Product Sales.xls]Product...

Hello all, Bet most of us have been caught by jumping from a file with calculations turned off to another file expecting calculations to be on, printing some work and going into a meeting with a pile of nonsense! Is there anyway, without added something to each and every excel file, that Excel...

Hi all, I was wondering if anyone could give advice or point me in the right direction of some good articles on spreadsheet performance. I.e. Some general rules to manage file size, speed, security. Maybe some guideline on choice of functions, I know some are more CPU heavy than others...

Thank you SirJB7, you confised me a little by using >G6 rather than I7, but I got ya! Spot on and I understand it! Thanks for swift response, appreciated.

Hi all, run into a brick wall with doing some counts. I'm looking to create a count based on a few columns. So been using countifs, all good. But now as well as one value from two different columns i want to look for a range of values in another columns...

Example attached, https://dl.dropboxusercontent.com/u/9071274/LineGraph%20issue.xlsx thanks

Thanks for response. Yeah tried that, it doesn't plot the point but it doesn't remove the line. So it skips the points and the line goes to the next point, which gives a false picture of the zero value. Cheers

Hi, I've a set of values that creates a line graph, most values are around the 90% mark, but there are a few zeros. Rather the the line graph dropping from 90% to 0%, I'd rather not show the line to zero. Tried everything (well everything i thought of), the only way it work is when i...

Spent 30 mins looking for that simple answer! cheers

Hi Luke, Thanks for the pointer. This code is setting the x axis, not Y, where am I going wrong? Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Select Case Target.Address Case "$B$26" ActiveSheet.ChartObjects("Chart 1").Chart.Axes(xlCategory) _...

Thanks guys. With a tweak or two Luke's example will work. Ideally I'd like to set the Y axis maximum scale to based on a value set in cell A13 for example. Also I've removed all gridlines, but again I'd like to set one line based on data in cell A14 (basically a mid point), so we get four...

Hi, I'm trying to create a price/quality matrix, started off thinking it was easy, but hit a brick wall! If you imagine this dataset, a list of competitors, a price which would set the Y axis and Quality score that would be the X axis. E.g. Comp2 would be lower on the price and quality...