Recent content by liamm

Hi Skip, sorry I'll try and explain as much as I can with my little knowledge.. Regarding how the data is updated - this is done manually. Each day, or numerous times per day, a user open the sheet and records their progress against their own activity in %. I think I have found the info I need...

Hi, I have a spreadsheet with a cell (D13) which AVERAGES a column of data. This data column is updated frequently but not on a routine basis. I want to capture the value from the AVERAGE cell(D13) and copy the value and current date to a table on another sheet each time the data column is...

Thanks for the replies guys. Andy, I think I will try this suggestion - I have seen some code for sending mail via Exchange so will try this out. If I get stuck I will come back for some help Many thanks, Liam If you can help, GREAT If I can help, EVEN BETTER

Hi Andy, sorry for the delay in getting back. We do have Exchange and as stated in my last post I am thinking of getting the guys to launch the spreadsheet each day to 'check' if there are any expiry dates. I don't think task scheduler is an option as this is accessed on multiple accounts &...

Hi guys, taking mintjulep's suggestion - So why not have the spreadsheet send out a notice every time that it is updated, rather than on a schedule? I don't think this would work because the spreadsheet might not be updated for a week or so but in the mean time an expiry date might pass. I...

Hi guys, thanks for your responses. The spreadsheet is accessed across a network by different people working a 24 hour shift pattern. Rather than me checking every morning or the guys needing to check every night (the spreadsheet only gets updated occasionally), I wanted the spreadsheet to...

Hi, I have an excel spreadsheet with some conditional formatting based on expiry dates. The column headers are: Column E - Date Defeated Column F - Expiry Date Column G - Date Re-instated The conditional formatting covers column F and changes format based on the following: If cell is blank no...

Sorry SkipVought, could you give me some more help on how to use this please? If you can help, GREAT If I can help, EVEN BETTER

Hi, I have an excel worksheet that I use to list stock. The sheet is laid out to mimic the shape of my stock room i.e. the data is not just listed in rows. I have multiple blocks of cells which include date for product name, amount, delivery date. What I would like is to be able to highlight a...

Hi again, tried your last code and it worked - mm/dd/yyyy. I have formatted my cells ddd-dd-mmm and used your code and the script works smashing. I just need to get my head around how I want the spreadsheet to work now. i.e. I would like it to Open with todays cell at the top of the page and...

Sorry, this did not work It filtered out all the results so that it showed no data at all. Can I ask, in the coding how does it get todays date from the code? Thanks for all this help, Liam If you can help, GREAT If I can help, EVEN BETTER

Sorry, this didn't work. I got a compile error showing the last " mark at the end of Criteria 2 line. When I removed this " the macro ran but the filter showed no fields. If you can help, GREAT If I can help, EVEN BETTER

Hi, when I use a date it filters: Sub Macro1() Selection.AutoFilter Field:=1, Criteria1:=">=18/01/2009", Operator:=xlAnd _ , Criteria2:="<25/01/2009" End Sub Can I do this without having to type in the date? If you can help, GREAT If I can help, EVEN BETTER

Can I not use something like Now()? instead of having to type in the date each time If you can help, GREAT If I can help, EVEN BETTER

Hi, I tried this and it removed all fields. The code is: Sub Macro2() Selection.AutoFilter Field:=1, Criteria1:=">=TODAY", Operator:=xlAnd, _ Criteria2:="<TODAY+5" End Sub Do I have to tell it the date format? and if yes , how would I do this Liam If you can help, GREAT If I can...