Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

2017-03-17 Thread Sunil Kumar Yadav
Dear Paul, Pls revert, if you have time. On Mar 17, 2017 5:22 PM, "karleenbiggs via MS EXCEL AND VBA MACROS" < excel-macros@googlegroups.com> wrote: > > > On Fri, 3/17/17, karleenbiggs via MS EXCEL AND VBA MACROS < > excel-macros@googlegroups.com> wro

$$Excel-Macros$$ Marriages Hall in Gurgaon

2017-03-17 Thread Pawan Sharma
*Located very close to the centre of the town in* *the central business **district, our hotel features* *spacious conference halls and ballrooms **that* *are

Re: $$Excel-Macros$$ What is dictionary object in vba, how do we use it?

2017-03-17 Thread Paul Schreiner
I'm a HUGE fan of the Dictionary Object. It has multiple uses.In it's basic form, it defines a unique "index" for a two-dimensional array. Let's say you have a large worksheet and you want to get a list of unique values from column "A" a count of each. You can cycle through the rows and check to

Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

2017-03-17 Thread karleenbiggs via MS EXCEL AND VBA MACROS
On Fri, 3/17/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date To: excel-macros@googlegroups.com Date: Friday, March 17, 2017, 1:50 PM -

Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

2017-03-17 Thread karleenbiggs via MS EXCEL AND VBA MACROS
On Fri, 3/17/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date To: excel-macros@googlegroups.com Date: Friday, March 17, 2017, 11:41 AM

$$Excel-Macros$$ What is dictionary object in vba, how do we use it?

2017-03-17 Thread Tulika Chauhan
Hi, i am new to vba, can anybody help me on dictionary? -- 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 this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. P

$$Excel-Macros$$ book for excel

2017-03-17 Thread Cori
Can you suggest a book for excel -- 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 this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Pl

$$Excel-Macros$$ Hi

2017-03-17 Thread girish naik
-- 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 this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, F

Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

2017-03-17 Thread karleenbiggs via MS EXCEL AND VBA MACROS
On Fri, 3/17/17, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date To: excel-macros@googlegroups.com Date: Friday, March 17, 2017, 9:44 AM -

Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

2017-03-17 Thread derrickandrew994 via MS EXCEL AND VBA MACROS
On Fri, 3/17/17, Sunil Kumar Yadav wrote: Subject: Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date To: excel-macros@googlegroups.com Date: Friday, March 17, 2017, 9:17 AM Dear Paul, I want to formula in one col

Re: $$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

2017-03-17 Thread Sunil Kumar Yadav
Dear Paul, I want to formula in one column not month-wise separately. Please guide me! On Fri, Mar 17, 2017 at 12:44 PM, Sunil Kumar Yadav wrote: > Dear Team, > > I want to pick rental pro-rata/monthly as per purchasing date. > > Pro-rata - If purchasing date after 1st then rental will be cal

$$Excel-Macros$$ How to pick rental on pro-rata/monthly basis as per date

2017-03-17 Thread Sunil Kumar Yadav
Dear Team, I want to pick rental pro-rata/monthly as per purchasing date. Pro-rata - If purchasing date after 1st then rental will be calculated days-wise(count) monthly - If purchasing date 1st then rental will be paid full. -- *Sky* "Good, Better, Best! *Always listen to your heart, because