Re: $$Excel-Macros$$ Information

shocking news you are not from IT field not trained programming lang is it possible me also guruji ? than suggest basic vba for me pls check my url guruji thanks On Wed, Dec 3, 2014 at 12:56 PM, Vaibhav Joshi v...@vabs.in wrote: Hi There is no team buddy.. 80-90% queries are not a new, i

Re: $$Excel-Macros$$ Information

Dear Vaibhav Sir, You are really Great. You have solution for all queries. I am associate with this group since one year and learn lot of about VBA. Sir...if you are conducting VBA courses then please enrolled my name first. Keep it Sir. Thanks once again! Regards, Prafull Jadhav

$$Excel-Macros$$ Re: Information

Hard work Experience Pays off Way to gooo On Wednesday, December 3, 2014 12:42:13 PM UTC+5:30, Mandeep Baluja wrote: This question is for vabz, Mostly the queries answered by vaibhav Are you working with a team or you are answering the queries by yourself only ??? without getting help

$$Excel-Macros$$ Folder loop

Hey, I am working on this code if i will not use statement *filename = Dir()* then it goes into a infinite stage. May I know the reason why and why it's stopped when i apply this line. as Per the meaning of this line it will check all the rest of files. Sub

$$Excel-Macros$$ Try this resolve this query.

Try this resolve this query. Trying to automate this any help will be appreciated. Regards, Mandeep -- 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

Re: $$Excel-Macros$$ Try this resolve this query.

Check thisWithout helper column you can do using sumproduct formula..for explanation i have kept formulas in the end... Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Dec 3, 2014 at 4:54 PM, Mandeep Baluja rockerna...@gmail.com wrote: Try this

Re: $$Excel-Macros$$ Folder loop

hi First understand what *filename = Dir()* is doing, its basically providing next file name in folder for all file names.. So when you dont use *filename = Dir()* your *filename *variable is holding your firs file name, your first file name is never gonna be unless its empty directory hence

$$Excel-Macros$$ Re: Try this resolve this query.

Good one bro/Sir( hmmm age? ) Awesome use of EO month and Day function. On Wednesday, December 3, 2014 4:54:19 PM UTC+5:30, Mandeep Baluja wrote: Try this resolve this query. Trying to automate this any help will be appreciated. Regards, Mandeep -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Re: Try this resolve this query.

Cheers..Bro is fine!! + *I did not do this for you. God is here working through me for you.* On Wed, Dec 3, 2014 at 6:03 PM, Mandeep Baluja rockerna...@gmail.com wrote: Good one bro/Sir( hmmm age? ) Awesome use of EO month and Day function. On Wednesday, December 3, 2014 4:54:19 PM

Re: $$Excel-Macros$$ Folder loop

Hey Vabz, it will loop the Next file means all the files reside in a folder having the extension *xlsx ? *or all the files files reside in a folder having the any extension it can be . ? On Wednesday, December 3, 2014 5:37:03 PM UTC+5:30, Vabz wrote: hi First understand what *filename =

Re: $$Excel-Macros$$ Folder loop

Hi It filters only xlsx file since you specified file xtension in beginning only... Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Dec 4, 2014 at 10:05 AM, Mandeep Baluja rockerna...@gmail.com wrote: Hey Vabz, it will loop the Next file means

Re: $$Excel-Macros$$ Querry production analysis

Dear Vaibhav, Thanks the solution is very good. Nemi Gandhi On Mon, Dec 1, 2014 at 6:58 PM, Vaibhav Joshi v...@vabs.in wrote: Hi You can do using PVT table, check this... Cheers!! + *I did not do this for you. God is here working through me for you.* On Mon, Dec 1, 2014 at

Re: $$Excel-Macros$$ Querry production analysis

Appreciate acknowledgement.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Dec 4, 2014 at 11:41 AM, Nemi Gandhi nemigan...@gmail.com wrote: Dear Vaibhav, Thanks the solution is very good. Nemi Gandhi On Mon, Dec 1, 2014 at 6:58 PM,

Re: $$Excel-Macros$$ Re: Try this resolve this query.

Also your carry forward part is taken by sumproduct, and i like sumproduct formula very much because it is very dynamic to handle complex calculations.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Wed, Dec 3, 2014 at 6:03 PM, Mandeep Baluja