Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile

2014-07-23 Thread Ashish Kumar
Hi Vaibhav, Reformatted version is great. Regards Ashish On 23 July 2014 11:32, Vaibhav Joshi wrote: > PFA > > Reformatted !! > > Cheers!! > > > On Wed, Jul 23, 2014 at 7:33 AM, Ashu k wrote: > >> Dear Vaibhav Sir, >> >> I am facing 2 problems know. >> >> First is - when I am trying to attac

$$Excel-Macros$$ Re: Indirect Function Not Working on Dates Please Help

2014-07-23 Thread Haseeb Avarakkan
Hello Dileep, In Summary!B5 =SUMIF(INDIRECT(TEXT($A5,"'dd-mm-'")&"!C:C"),B$3,INDIRECT(TEXT($A5,"'dd-mm-'")&"!F:F")) Then copy down & other Amount columns. Haseeb On Mon, Jul 21, 2014 at 2:42 PM, Dileep Kumar wrote: > Dear Friends, > > Please find attached Daily Reporting Formate of

$$Excel-Macros$$ Urgent required Business Analyst/Data Analyst - San Leandro, CA

2014-07-23 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com Position: Business Analyst/Data Analyst Location: San Leandro, CA Duration: 6-12 Months, long term* *Local candidates only, F2F interview is mandatory* Need to close this position by Friday. Client interview slots available. *(please do not submit

Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile

2014-07-23 Thread Ashu k
Dear Vaibhav Sir, If possible than please add BCC function, Text font function, Text colour function, Bold Italic, Underline etc. If these function are adding in it then it's looks more interactive and useful. Kindly help. Thanks & Regards Ashu Kenith On 7/23/14, Ashu k wrote: > Dear Vaibhav

Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile

2014-07-23 Thread Ashu k
Dear Vaibhav Sir, Added BCC funciton is possible in it. Please help. Thanks & Regards Ashu Kenith On 7/23/14, Vaibhav Joshi wrote: > cheers!! > > Working on adding more features viz. managing attachments etc..will share > once done, you can recommend additional features if you want that to be

Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile

2014-07-23 Thread Ashu k
Dear Vaibhav Sir, Please suggest what kind of more features are adding to do it more attractive, innovative & useful. Kindly suggest. Thanks & Regards Ashu Kenith On 7/23/14, Vaibhav Joshi wrote: > cheers!! > > Working on adding more features viz. managing attachments etc..will share > once do

Re: $$Excel-Macros$$ Protect shared workbook

2014-07-23 Thread Vaibhav Joshi
Pl refer: office.microsoft.com/en-us/excel-help/features-that-are-unavailable-in-shared-workbooks-HP005201080.aspx Cheers!! On Wed, Jul 23, 2014 at 2:38 PM, Suman wrote: > Hi, > > I have created a macro on *Change event* to protect a particular column > (Column A) when the user put anything in

Re: $$Excel-Macros$$ Re: Send Atachment ExcelFile

2014-07-23 Thread Ashu k
Dear Vaibhav Sir, Thanks a lot for your valuable support and help. my problem is resolved only b'coz of you. Thanks a ton sir. Thanks & Regards Ashu Kenith On 7/23/14, Vaibhav Joshi wrote: > PFA > > Reformatted !! > > Cheers!! > > > On Wed, Jul 23, 2014 at 7:33 AM, Ashu k wrote: > >> Dear Vai

Re: $$Excel-Macros$$ Plz automation help

2014-07-23 Thread Paul Schreiner
Are you wanting someone to write it for you or give you guidance in writing it? Either way, what you've given us is insufficient to complete the task. The way I usually handle it is with a Dictionary Object. I read in the "Master file" and store the record "index" and row number in a Dictionary

Re: $$Excel-Macros$$ Protect shared workbook

2014-07-23 Thread Paul Schreiner
It's possible that the other users have their macro settings set for a prompt when opening and select to disable macros.   There's a couple of ways to handle this:   Lock and protect the entire sheet, or even hide it. Create a workbook_Open event that unhides or unprotects the sheet. If they've di

$$Excel-Macros$$ Protect shared workbook

2014-07-23 Thread Suman
Hi, I have created a macro on *Change event* to protect a particular column (Column A) when the user put anything in any cell of that column. Now the thing is that code is working properly in normal mode but its not working when I share this workbook. Please help to resolve my query. *Suman K

Re: $$Excel-Macros$$ Plz automation help

2014-07-23 Thread Vaibhav Joshi
hi share sample file with example. cheers!! On Wed, Jul 23, 2014 at 10:03 AM, venkateswara reddy < venkateswara.red...@gmail.com> wrote: > Hi Dear, > > Plz Excel Macros help > > I need to replace in master file previous data with current status data > using macros vba code. > > > I have two fi