Recent content by mr_hiboy

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!