Re: $$Excel-Macros$$ Macro to replace cell reference or addresses with their individual calculated values

2014-01-12 Thread Mukesh Kumar
Ashish ji, macro given by you only paste special in column D. But my requirement is according to given examples above Option 1 on running macro the result should be or option 2 Units Rate Amount 1 3 =1*B2 2 4 =2*B3 3 5 =3*B4 4 6 =4*B5 5 7 =5*B6 6 8 =6*B7 7 9 =7*B8 or option 3 My

Re: $$Excel-Macros$$ Gantt chart

2014-01-12 Thread ǝɹohsiʞ ʞ ʌ d
Please browse the following link, it may helpful to you. http://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html On Sun, Jan 12, 2014 at 5:27 PM, rekha siri wrote: > Hi Excel experts, > > Wish you a very happy and prosperous New year. > > > i am trying to build Gantt chart if any one hav

Re: $$Excel-Macros$$ Gantt chart

2014-01-12 Thread Ashish Kumar
Hi, PFA.!!! Thanks & Regards, Ashish Kumar On Sunday, 12 January 2014, rekha siri wrote: > Hi Excel experts, > > Wish you a very happy and prosperous New year. > > > i am trying to build Gantt chart if any one have such template please > share. > > As per previous group mails from Sam i re

Re: $$Excel-Macros$$ Gantt chart

2014-01-12 Thread ashish koul
try this http://www.excelvbamacros.in/2013/07/gantt-chart-in-excel.html On Sun, Jan 12, 2014 at 5:27 PM, rekha siri wrote: > Hi Excel experts, > > Wish you a very happy and prosperous New year. > > > i am trying to build Gantt chart if any one have such template please > share. > > As per previo

$$Excel-Macros$$ Re: Introduce Yourself !!

2014-01-12 Thread jocare
On Friday, June 8, 2012 9:21:59 PM UTC+2, Ayush Jain wrote: > > Hey all new and current posters, > > Welcome to excel group,one of the largest online community of excel Fans! > > I hope you enjoy your time here & find this forum to be a friendly and > knowledgeable community. Please feel fre

Re: $$Excel-Macros$$ dynamic drop down list

2014-01-12 Thread SteveWeaver
Thank you Ashish!!! It's very close . . . 1. Could you explain how to add new years to the drop down list? The three most current years are missing. 2. Can the date shown in the chart be automatically updated to show the period from which the data was used? Thank you so much for your help

$$Excel-Macros$$ Gantt chart

2014-01-12 Thread rekha siri
Hi Excel experts, Wish you a very happy and prosperous New year. i am trying to build Gantt chart if any one have such template please share. As per previous group mails from Sam i referred to Chandoo.org template. Like wise please if any one has such templates do share it. Thanks, Rekha --