Search results

ah victim of poor sorting in the first place! Thanks Hui, also using the & isnew to me, a great help too! Thanks again

Hi I'm trying to cum the quantity of product I have between specific ranges. Been trying with Sumifs, but now thinking this may not be the best solution. Wanted to double check before I start trying something else. I've explained on the attached. Thanks in advance for you help...

ah ha school boy error, I had Private Sub Worksheet_Open() changed it to workbook! Worked a treat, also added the calc in the code Luke, cheers Thanks again

actually Q4 was a cheat cell, i'd rather have done the calc in the code, but that wasn't working then tried the cheat cell

thanks for quick reply as usual. xlsm file Q4 has formula, =TODAY()+14-N4 (the +14 is so i can test today) The result 13, therefore >7 thanks

Hello one and all, Been looking pop a simple message on opening a file. Checks if the data is up to date, if note alerts me to update. Tried this in thisworkbook object, but no joy? Private Sub Worksheet_Open() If ActiveWorkbook.Worksheets("FleetChanges").Range("Q4") > 7 Then MsgBox...

Actually it still doesn't work. example, firstly i made the product 1 bar bright yellow (easy to follow). if you make the value of product 1 a higher number (e.g. 20000), then sort by YTD. Product 1 moves but when you look at the graph the first bar colour is bright yellow but it product 2...

ouch! Looks great. Cheers Hui

cheers https://dl.dropboxusercontent.com/u/9071274/Summary%20Temp.xlsx

Hi Hui, thanks for the quick response. That's what I was trying but when the data changes, the bars are reorder depnding on results. Therefore the first bar which was green stays green when in fact the product/bar has moved. thanks

Hi, Hope someone can help here. I have a bar graph that has 5 bars, say Product1 - 5. The data is order best to worst performing and depending on the data selection Product 1 may appear top or bottom, therefore moves on the chart. I want each product (bar) to be a specific colour, i.e...

Hi, I want to display a persons username from active directory in cell A1. Seen a few ways (some quite complicated) but can't seem to get it to work. Any thoughts? thanks in advance Paul

Believe me I tried all (well not all obviously!) variations. Was nearly there! This works a treat. Cheers Colin, much appreciated.

Hi, I have a hidden datasheet linked to sql server table. On my report sheet i have a button that unhides the data sheet, selects a cell and run background refresh, then hides the data sheet again. Am I able to run the data refresh without un-hiding the sheet (so it's visible to the end...

hi, I've got a few large files which link to various files in a Links folder. I've had to move the links folder to make life similar but am now having to edit/link and change source to the new file. Some of which are taking 5 minutes to update, I have 24 files do to each with 7 files to...

Hi Deb, Thanks for your reply. A1 = A therefore sum column B which in this case is 1. Both your alternatives work, but are work arounds, surely the sumifs should works without having to rewrite the sumif element? Trying to get my head around it. Cheers

Hi, I'm trying to get sumifs to work, even on very simple example it's doesn't seem to want to play! Simple file, Cell A1 =A, A2 =B Cell B1 =1, B2 =2 The following should give 3, but it's giving zero. If I run one criteria at a time it works. =SUMIFS(B1:B2,A1:A2,A1,A1:A2,A2) It's...

Also is there a reason why using this code would prevent "undo" - when I have the code in place if i type in a cell and then undo, it doesn't work. remove the code and it works fine. Any pointers would be great on the above. thanks

Apologies for being a pain. But I can't seem to get it to work in my file. Your example works fine and I've copied the exact code to to my file (see dropbox file above), but not working. Any chance you could have a quick look? Cheers

Hi Hui, I'm also getting that result to. Before I was scrolling, which it doesn't work for.

Thanks for your help, might have to do for now. I've read something about a moursewheel fix, seems excessive. http://office.microsoft.com/en-gb/excel-help/add-support-for-the-scroll-wheel-to-the-microsoft-visual-basic-for-applications-6-environment-HA010117590.aspx

Ah i see the issue. If you scroll using the scroll bar or mouse wheel it doesn't work. Like you say, if you use the down arrows it doesn't. It would need to work with scroll to be most useful. any thoughts? Thanks

Here's my file for you to look at. https://dl.dropboxusercontent.com/u/9071274/Scroll_Issue.xlsm Appreciate your help (it's likely to be something I've missed! :)

Great - took a little tinkering as the chart is dynamic based on dropdown selection so percentage vary from -40% to >100% Definitely look better! Cheers Paul

Just checked again on the work network and even your example doesn't work. File saved as Macro enabled, calcs on, not sure what enabled events is? But other bit of vb and macros work in the file. Cheers