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 wrote: > Go

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 wrote: > Dear Vaibhav, > > Thanks the solution is very good. > > Nemi Gandhi > > On Mon, Dec 1, 2014 at 6:58 PM, Vaibhav Joshi wrot

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 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 1:46

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 wrote: > Hey Vabz, > > it will loop the Next file means all the files reside

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$$ 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 wrote: > 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

$$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 =NOT(

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

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 wrote: > Try this resolve this query. >

$$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 RU

$$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 Select_Folder_and_copy_files_into_c

$$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

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 9920553518

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 wrote: > Hi > > There is no team buddy.. 80-90% queries are not a new, i have alr