$$Excel-Macros$$ vba to call macro in another workbook

2015-05-28 Thread neotiarohit
hi, could you please help me with this code it says object defined error 1004 I have a workbook named muddmmyy the date is variable I want to call a macro in "ThisWorkbook" sheet I want to call it from another workbook could please help many thanks Application.Run ("MU" & Format(Sheets("Main"

$$Excel-Macros$$ Please help in dividing equal numbers

2015-05-28 Thread Rashi Singh
Dear all, Please help in enclosed problem solution. i have tried many and even googled, but i am unable to create formula. Have exlplained xl sheet, please find. Regards, Rashi -- 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 Fa

$$Excel-Macros$$ Re: vba to call macro in another workbook

2015-05-28 Thread Mandeep Baluja
Use this code as your code contains a syntax error Application.Run "MU" & Format(Sheets("Main").Range("C6").Value, "ddmmyy") & ".xlsm" & "!ThisWorkbook.T" Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/groups/825221420889809/ https://www.linkedin.com/profile/view?id=31253

Re: $$Excel-Macros$$ Please help in dividing equal numbers

2015-05-28 Thread Titu Sharma
please explain your query On Fri, May 29, 2015 at 10:04 AM, Rashi Singh wrote: > Dear all, > > > Please help in enclosed problem solution. i have tried many and even > googled, but i am unable to create formula. Have exlplained xl sheet, > please find. > > > Regards, > Rashi > > -- > Are you =E

Re: $$Excel-Macros$$ Please help in dividing equal numbers

2015-05-28 Thread Chandra Gupta
What's your criteria for "how many 100 or 150 you can use". On Fri, May 29, 2015 at 10:04 AM, Rashi Singh wrote: > Dear all, > > > Please help in enclosed problem solution. i have tried many and even > googled, but i am unable to create formula. Have exlplained xl sheet, > please find. > > > Reg

Re: $$Excel-Macros$$ Please help in dividing equal numbers

2015-05-28 Thread Rashi Singh
Yes Yes, Actually Say i have to give Rs. 2250 to someone else. Now in my drawer box, i have bundle of Rs. 100 and Rs. 150 (Assume). Now How many Rs 100 have to take out from my drawer and Rs. 150 from my drawer. to equivalent Rs. 2250. Hope i could able to explain my query ! Thanks in advance

Re: $$Excel-Macros$$ Please help in dividing equal numbers

2015-05-28 Thread Titu Sharma
how can you have bundle of 150, this should be bundle of 50 i think... On Fri, May 29, 2015 at 11:12 AM, Rashi Singh wrote: > Yes Yes, Actually Say i have to give Rs. 2250 to someone else. Now in my > drawer box, i have bundle of Rs. 100 and Rs. 150 (Assume). > > Now How many Rs 100 have to take

Re: $$Excel-Macros$$ Please help in dividing equal numbers

2015-05-28 Thread Titu Sharma
as per your requirement On Fri, May 29, 2015 at 11:25 AM, Titu Sharma wrote: > how can you have bundle of 150, this should be bundle of 50 i think... > > On Fri, May 29, 2015 at 11:12 AM, Rashi Singh > wrote: > >> Yes Yes, Actually Say i have to give Rs. 2250 to someone else. Now in my >> drawe

Re: $$Excel-Macros$$ Please help in dividing equal numbers

2015-05-28 Thread Rashi Singh
Ok I have only assume that there is 150, Ok no problem lest 50 Rs. Now my query is Distribute 100 and 50 to make total amount of Rs. 2250. Thanks for your revert. On Fri, May 29, 2015 at 11:25 AM, Titu Sharma wrote: > how can you have bundle of 150, this should be bundle of 50 i think... > > O

Re: $$Excel-Macros$$ Please help in dividing equal numbers

2015-05-28 Thread Rashi Singh
Thank you so much, those result are as i expected. Thank you so much. I will study this formula, since i new to excel formulas. Regards, Rashi On Fri, May 29, 2015 at 11:31 AM, Titu Sharma wrote: > as per your requirement > > On Fri, May 29, 2015 at 11:25 AM, Titu Sharma wrote: > >> how can

Re: $$Excel-Macros$$ Please help in dividing equal numbers

2015-05-28 Thread Titu Sharma
updated as per 50 On Fri, May 29, 2015 at 11:31 AM, Titu Sharma wrote: > as per your requirement > > On Fri, May 29, 2015 at 11:25 AM, Titu Sharma wrote: > >> how can you have bundle of 150, this should be bundle of 50 i think... >> >> On Fri, May 29, 2015 at 11:12 AM, Rashi Singh >> wrote: >>

Re: $$Excel-Macros$$ Please help in dividing equal numbers

2015-05-28 Thread Titu Sharma
you are welcome On Fri, May 29, 2015 at 11:36 AM, Rashi Singh wrote: > Thank you so much, those result are as i expected. Thank you so much. > > I will study this formula, since i new to excel formulas. > > > Regards, > Rashi > > On Fri, May 29, 2015 at 11:31 AM, Titu Sharma wrote: > >> as per

$$Excel-Macros$$ Conver Google sheet to Excel sheet

2015-05-28 Thread Sailaja
Hello Forum, I am having a Google Sheet which also needs to work in excel. Could you please have a look at this. Regards, Sailaja -- 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.fa

Re: $$Excel-Macros$$ Conver Google sheet to Excel sheet

2015-05-28 Thread Titu Sharma
this can't work on excel as it taking the references from internet On Fri, May 29, 2015 at 11:51 AM, Sailaja wrote: > Hello Forum, > > I am having a Google Sheet which also needs to work in excel. Could you > please have a look at this. > > > Regards, > Sailaja > > -- > Are you =EXP(E:RT) or =NO