$$Excel-Macros$$ Customized Inventory Software Required in Excel VBA

2017-03-06 Thread Hitesh Kr. Aoul
Hello, I need a help to make a customized Inventory software for our newly setup business, In which we required 2 login id's, 1. is for Local User and other is Admin (both need to be password protected). Firstly we need to make the master Item Sheet having the details like Item Code, Item

$$Excel-Macros$$ LOOK:Sign The Global Open Letter To Donald Trump

2017-03-06 Thread hassan bourah
Sign The Global Open Letter To Donald Trump *With the Muslim ban, Trump has shown that the worst fears about his Presidency are true. Add your voice to the open letter below to join the resistance — then spread it far and wide: * Dear Mr. Trump, This Is Not What Greatness Looks Like.

$$Excel-Macros$$ Re: Introduce Yourself !!

2017-03-06 Thread hassan bourah
Strade Bianche: deuxième victoire de Kwiatkowski WHAT HAPPENS WHEN YOU PUT CUT UP ONIONS IN YOUR SOCKS WHILE YOU SLEEP Donate Car To Charity California |

$$Excel-Macros$$ LOOOK

2017-03-06 Thread hassan bourah
Strade Bianche: deuxième victoire de Kwiatkowski WHAT HAPPENS WHEN YOU PUT CUT UP ONIONS IN YOUR SOCKS WHILE YOU SLEEP Donate Car To Charity California |

Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month

2017-03-06 Thread Sunil Kumar Yadav
Thank you so much paul it's almost working correctly as per my requirement On Mar 6, 2017 7:39 PM, "Paul Schreiner" wrote: Please take a closer look at my long-winded explanation. I was merely trying to explain how your "static" formula using Today() was inefficient

Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month

2017-03-06 Thread Paul Schreiner
Please take a closer look at my long-winded explanation. I was merely trying to explain how your "static" formula using Today() was inefficient and why. I then went on to suggest that you use (in cell B5) the formula: =IF(YEAR(A5-15) <> YEAR(TODAY()),0, MONTH(A5-15)*1.5) I also said that for your

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

2017-03-06 Thread Paul Schreiner
Maatangi, your file has a link to a file called Database-formats11.xlsb that I don't have, so I'm not sure if I can do much testing. However, as far as the locked/protected cells go:Record a macro in which you Protect the sheet (with a password) and making appropriate selections.then unprotect

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

2017-03-06 Thread georgemartin812 via MS EXCEL AND VBA MACROS
On Mon, 3/6/17, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date:

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

2017-03-06 Thread kenyattafreed via MS EXCEL AND VBA MACROS
On Mon, 3/6/17, cronincarmelita via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date:

Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA

2017-03-06 Thread cronincarmelita via MS EXCEL AND VBA MACROS
On Mon, 3/6/17, Maatangi M. Karthik wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: "MS EXCEL AND VBA MACROS" Cc: