Re: Sound an alarm when a cell reaches a certain percentage
Thanks chaps, will play around with these ideas - much appreciated.
Re: Sound an alarm when a cell reaches a certain percentage
Thanks chaps, will play around with these ideas - much appreciated.
Re: Sound an alarm when a cell reaches a certain percentage
Does anyone have any bright ideas on this one? thanks chaps
Re: Sound an alarm when a cell reaches a certain percentage
Just to play a sound file only really
Ladies, Gents - the cell I need to watch is G29. I am wondering if it is possible to sound an alarm once when this cell reaches 25%, 50%, 75% and 100% and above? Is this possible in VBA?
Re: Macro to copy and paste table if specific data in the table changes
no, i wasn't - thanks for alerting me!
Re: Macro to copy and paste table if specific data in the table changes
I have attached a sample report. Cells F28:F64 is the range that I need to monitor. So I need a report to come from here to show the Top 20 in this range, sorted by value, together with the Customer Name. I would appreciate any thoughts on this. I should also explain that this Pivot Table is automatically created by our software during the export, and so I am limited as to what I can do with it directly. ***I AM HAVING DIFFICULTIES UPLOADING ANYTHING AT THE MOMENT - IS THERE A FILE SIZE LIMIT OR SOMETHING??***
Hello, I am hoping someone kind could assist me. I have a sales representative report that is automatically updated every few minutes. This shows the Customer Name, Last Contact Date, and then Monthly Spend (current Month). From this data I need to monitor which of my customers are the Top 20 in terms of monthly spend. However I need to be alerted by email (I have CDO code borrowed from elsewhere to send email) if those 20 customers change, i.e. one customer falls behind and another takes it's place. I will try and upload a sample report shortly which hopefully will help to explain, but in the meantime, if anyone has any bright ideas, I would be grateful. Many thanks
Hello All
I am from the UK and I have this Gantt chart that works really well for me.
It automatically shades the weekends in a different colour, and also shades any days that are listed in Column C of a different worksheet. This list in Column C is basically any days that I am not going to be at work, i.e. Holidays.
My question was whether it is possible, and if so, how - to pull through the holidays in England - similar to how it works in Outlook Calender.
Not sure if I am explaining myself properly, can anyone help?
It is just annoying to keep updating the sheet year after year with the new set of holidays.
Thanks !!
Re: Arrow between two different selected cells
This is an excellant idea.
Could this be adapted at all so that you can select more than two cells? This would be awesome if you can select three or more cells so that the arrow line passes through them. Hope this makes sense! and apologies for hijacking the thread!