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...
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.
Then i have cells with date and number of...
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.
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...
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...
Actually been trying to figure it out, I'm able to show the totals, but struggling with not showing 0Total
Application.ScreenUpdating = False
Selection.AutoFilter Field:=1, Criteria1:="*Total"
I have a large list of products, each with a product total line, e.g.
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.
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.
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...