Re: $$Excel-Macros$$ formatting cell

Dear Abhishek Thanks for reply. Actually already some value in cell b1. In short I have a date of material received in cell a1 and qty in cell b1. But shelf life of material is only 15 days so i want to highlight that once the 15 days over I cant put formula in B1 so I want conditional formating

Re: $$Excel-Macros$$ SUMMARY OF DATA

Dear paul can you help me in generating the summary as per the attached with macro On Tue, Dec 1, 2015 at 7:54 PM, Paul Schreiner wrote: > Absolutely. > I do it daily. > actually, nightly. > It's done by the time I arrive at work each weekday. > > I use VBA macros to

Re: $$Excel-Macros$$ formatting cell

The formula is to be used in conditional formatting dialog box only...not in B1. PFA sample attached. On Thu, Dec 31, 2015 at 3:00 PM, Shrinivas Shevde wrote: > Dear Abhishek > Thanks for reply. > Actually already some value in cell b1. > In short I have a date of

Re: $$Excel-Macros$$ formatting cell

Dear Abhishek Thanks sir Problem Solved Regards Shrinivas On Thu, Dec 31, 2015 at 3:39 PM, Abhishek Jain wrote: > The formula is to be used in conditional formatting dialog box only...not > in B1. > > PFA sample attached. > > On Thu, Dec 31, 2015 at 3:00 PM, Shrinivas

Re: Fwd: $$Excel-Macros$$ Extract reports into a new workbook

Please find the attached file with solution In case of any problem please let me know On Dec 31, 2015 4:05 PM, "Rajeev Kumar" wrote: > ANY UPDATE PLEASE!!! > -- Forwarded message -- > From: Rajeev Kumar > Date: Thu, Dec 31, 2015 at

Fwd: $$Excel-Macros$$ Extract reports into a new workbook

ANY UPDATE PLEASE!!! -- Forwarded message -- From: Rajeev Kumar Date: Thu, Dec 31, 2015 at 9:09 AM Subject: $$Excel-Macros$$ Extract reports into a new workbook To: excel-macros@googlegroups.com Dear Experts, Please find attached excel file and help

$$Excel-Macros$$ Re: data validation upon saving...

Hi Lin, Check the attachment and find the same Scenario as required !! One thing which i didn't understand from where predetermined Total comes.(If I am assuming it correctly You are trying to validate values from two different sheets), Set this scenario in your sheet accordingly. Regards,

$$Excel-Macros$$ Happy new year

Happy new year to all members. Last year I really got excellent support from all members. I hope same will be continue . Special thanks to Noorani sir . -- Shrini -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of