Re: $$Excel-Macros$$ doubt in extracting worksheet balances to sheet1 with other sheet names

2014-08-07 Thread Vaibhav Joshi
Hi PFA Cheers!! On Thu, Aug 7, 2014 at 11:21 AM, Shankar Bheema shankar.n...@gmail.com wrote: Hai friends I am attaching an Excel workbook for an apartment maintenance. sheet1 i considered as Main page, sheet2, sheet3 will hold individual accounts and their balances when

$$Excel-Macros$$ Re: Shorter way of getting sum of each column using VBA

2014-08-07 Thread 'DanJ' via MS EXCEL AND VBA MACROS
Hi Pramod and Jef, Thank you for your quick reply. I prefer Jef's solution though. By the way Jef, what does number 3 mean after 65536. Thanks again. DanJ On Thursday, August 7, 2014 11:20:24 AM UTC+8, DanJ wrote: Hello everyone, I am trying to get the total of each column K, O, P, T, U,

Re: $$Excel-Macros$$ Fwd: Excel Query

2014-08-07 Thread Vaibhav Joshi
check this... Cheers!! On Tue, Aug 5, 2014 at 11:00 AM, Satendra kumar satendrakuma...@gmail.com wrote: Hi All Expert, Please find the attachment assist me, what i do in this condition? -- Thanks Regards Satendra Kumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ EXCEL TIME DIFFERENCE CALCULATION

2014-08-07 Thread KATHIRVELAN N
Dear Vaibhav, Yes i need it in table in formula, could you please help. Thanks, Kathirvelan On Thu, Aug 7, 2014 at 10:34 AM, Vaibhav Joshi v...@vabs.in wrote: do you want data to populated in table? how? VBA / Formula? On Wed, Aug 6, 2014 at 8:57 PM, KATHIRVELAN N nkathirv1...@gmail.com

Re: $$Excel-Macros$$ Re: Shorter way of getting sum of each column using VBA

2014-08-07 Thread Vaibhav Joshi
3 is column no. i.e. col C. Cheers!! On Thu, Aug 7, 2014 at 12:31 PM, 'DanJ' via MS EXCEL AND VBA MACROS excel-macros@googlegroups.com wrote: Hi Pramod and Jef, Thank you for your quick reply. I prefer Jef's solution though. By the way Jef, what does number 3 mean after 65536. Thanks

Re: $$Excel-Macros$$ Need VBA code

2014-08-07 Thread Vaibhav Joshi
Mayank PFA cheers!! On Tue, Aug 5, 2014 at 12:05 AM, Mayank Agarwal lko.may...@gmail.com wrote: Hello expert, need your help to write macro for atached file; In a file I need to filter data on a country wise and to create new tab for a respective country with the country name as a tab

Re: $$Excel-Macros$$ Excel Macros Help

2014-08-07 Thread Vaibhav Joshi
hi check this., as soon as any data is changed you will get notification to update it.. Cheers!! On Mon, Aug 4, 2014 at 3:40 PM, venkateswara reddy venkateswara.red...@gmail.com wrote: thank you so much for this. I'm grateful again for your time and considerable expertise. This is