Re: $$Excel-Macros$$ Re: Auto highlight Row/Column of Active Cell...

2018-02-14 Thread Vishwanath
HI all, This is really nice posting and solution!!! Just a query extending this macro... Is it possible to run the macro running till it is deactivated. IN short dynamic. I mean the rows and columns should be highlighted as the cursor moves. It would be great utility... rgds vi On Tuesday, Fe

Re: $$Excel-Macros$$ Worksheet to Master - Row consolidation

2013-09-15 Thread Vishwanath
Dear De Premor, I have no words to say thanks.. You are really great. Which place you from? Wish i could meet you some time. rgds vishwanath On 13 September 2013 08:39, De Premor wrote: > PFA and try to run macro named SAVE on module1 > > > On 29-08-2013 18:57, Vishwanath wrot

$$Excel-Macros$$ Re: Worksheet to Master - Row consolidation

2013-09-12 Thread Vishwanath
HI Experts, Your help is appreciated. On Thursday, August 29, 2013 5:27:09 PM UTC+5:30, Vishwanath wrote: > Dear Experts. > Need your help. the solution can be by using the macros. > I have a workbook containing sheet called Indent and master sheet. > Indent sheet is form. The con

$$Excel-Macros$$ Worksheet to Master - Row consolidation

2013-08-29 Thread Vishwanath
Dear Experts. Need your help. the solution can be by using the macros. I have a workbook containing sheet called Indent and master sheet. Indent sheet is form. The contents of the indent sheet to be updated to master sheet in a particular fashion by capturing information of the indent sheet in

Re: $$Excel-Macros$$ Excel Gurus :- Please Help me out for the formula for amount distribution

2013-07-23 Thread Vishwanath
Dear Mr.DP.. Awesome... I admire it. You have reduced my whole day effort to few minutes.. My heart filled thanks to you. Best regards Vishwanath On 23 July 2013 23:55, De Premor wrote: > Ups Sorry, i dont make an error checking before > here is the rev code > > > =(EOMONTH(D

Re: $$Excel-Macros$$ Excel Gurus :- Please Help me out for the formula for amount distribution

2013-07-23 Thread Vishwanath
this example the first month distribution should be 27 days and in the month of December, it should be proportionate to 14 days. The balance should be distributed equally for other months for whole month. Is it something possible? best regards vishwanath On Thursday, July 18, 2013 10:11

$$Excel-Macros$$ Re: Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet

2013-07-23 Thread Vishwanath
Awesome. I was Looking for it. Thanks guys. On Monday, July 22, 2013 8:56:49 PM UTC+5:30, Vijay Gande wrote: > Hi there, > > I'm amateur with excel macros and need help with the following task, > > I've an excel workbook with 16 sheets, all the sheets have same # of > columns but different # of

Re: $$Excel-Macros$$ High low Query

2012-12-06 Thread arvind vishwanath
Hi ppl , Could u suggest some good vb and macros material On Dec 5, 2012 6:56 AM, "Dhaval Shah" wrote: > Friends, > > pls go through the attached excel sheet > > in main sheet there is raw data of differenet date for different product > now suppose product x trade for 5 days and 5 days close va

$$Excel-Macros$$ Re: Vlookup with total

2012-10-23 Thread Vishwanath
Hi, You can also use sumif function =SUMIF(A2:B8,E5,B2:B8). Attachment is with formula results are derived. rgsd vishwanath On Tuesday, October 23, 2012 12:56:36 PM UTC+5:30, Amit Desai (MERU) wrote: > > Dear All, > > > &g

Re: $$Excel-Macros$$ Re: Need Help in allocation table

2012-10-08 Thread Vishwanath
Dear Ashishi, Sending the the sample file. thanks in advance for your cooperation. On 8 October 2012 21:55, ashish koul wrote: > can you attach the sample sheet > > > On Mon, Oct 8, 2012 at 9:53 PM, Vishwanath wrote: > >> Dear wabs, >> Thanks for your reply. >&g

Re: $$Excel-Macros$$ Re: Need Help in allocation table

2012-10-08 Thread Vishwanath
range from and to period for allocation is available in column 2 and 3. Best Regards, Vishwanath Sent from my iPhone On 08-Oct-2012, at 5:28 PM, Vabz wrote: > Hi > > Can you explain base for allocation, theer is no standard method that can be > assumed on the basisi if data

$$Excel-Macros$$ Need Help in allocation table

2012-10-03 Thread Vishwanath
Need help Dear All, I need your help in automatic some calculations in spreadsheet. I have data in excel as below; It consists of 2 parts. first part is Expense statement and second part is allocation required. The expense statement has data period for each type of expenditure. The same ne

$$Excel-Macros$$ Re: Unsubscribe

2009-01-07 Thread Vishwanath Haryan
please unsuscribe me too Thanks in advance Vishwanath On Thu, Jan 8, 2009 at 12:02 PM, Siddhartha Guha wrote: > kindly unsubscribe me too from this group. thanks in advance > regards, > siddhartha > > -- Forwarded message -- > From: Vinesh > Date: Thu