error 1006 is showing when I am running after changing the path.
Please help
Thanks & Regards,
Sagar
On Thu, Mar 7, 2013 at 5:53 PM, Pravin Gunjal wrote:
> *Thanks Anil.*
>
> -- Forwarded message --
> From: अनिल नारायण गवली
> Date: Thu, Mar 7, 2013 at 10:19 AM
> Subject: Re:
congratulations
On Thu, Mar 15, 2012 at 11:39 AM, jmothilal wrote:
> Congratulation Noorain.
>
>
> Mothilal.J
> Universal Computer\
> Vellore -2
>
>
>
>
>
>
> On Thu, Mar 15, 2012 at 11:36 AM, Dilip Pandey wrote:
>
>> Congratulations Noorain
>>
>> Keep up the good work and keep helping :)
>>
*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *SAGAR KASANGOTTUWAR
> *Sent:* 23 May 2012 1:00
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Error 10
Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* SAGAR KASANGOTTUWAR
> *Sent:* Wednesday, May 23, 2012 2:30 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Error 1004 at the time of Crl. + A command
>
> Dear all,
>
> I am facing
t; --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Fri, May 25, 2012 at 4:45 PM, SAGAR KASANGOTTUWAR <
> sagarkasangottu...@gmail.com> wrote:
>
>> Dear All,
>>
>> Please find attached file for the debuggin
Dear All,
I want to learn MACRO's from basic so kindly give me some material for the
same.
Thanks & Regards,
K SAGAR
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, C
ular basis.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Tue, May 29, 2012 at 2:28 PM, SAGAR KASANGOTTUWAR <
> sagarkasangottu...@gmail.com> wrote:
>
> Dear All,
>
> I want to learn MAC
Dear friends,
I had done 500 share trading transaction now I want to know the short term
and long term capital gain.
I want a formula for auto averaging of share price.
If I do this thing manually then it will take 10hours or more.
Kindly help me if any solution availble for the same.
Thanks in
Congratulations Noorain,
All the best ...
You are the heart of this google group...
On Sun, Aug 5, 2012 at 10:30 AM, Aindril De wrote:
> Great Work Noorain!!
> Though I have been silent in this group for quite some time...
> However I keep following the posts.. almost everyday.. thx to great
>
Dear Friends,
I want combine the data from other worksheets to one specific worksheet so
kindly give me the fastest way to do same task.
Note. I HAVE NEAR ABOUT 200 worksheets which I WANT to combine.
THANKS IN ADVANCE,
Regards,
CA KSAGAR
--
Join official facebook page of this forum @
http
>> "A").Value)) Then
>> >>
>> >> '---
>> >> nRows = nRows + 1
>> >> Sheets(dSheet).Cells(nRows, "A").Va
& Click Edit
> Links & Select All then Update Value & Refresh All Sheets.
>
> Regards,
> Kuldeep Singh
>
>
> On Sat, Aug 18, 2012 at 12:00 AM, SAGAR KASANGOTTUWAR <
> sagarkasangottu...@gmail.com> wrote:
>
>> Dear Kuldeep,
>>
>> But if
Dear Ameresh,
Kindly tell me how we can put scroll in excel like you have done in
attached worksheet...
Thanks & Regards,
CA KSAGAR
On Tue, Aug 21, 2012 at 3:26 PM, अनिल नारायण गवली
wrote:
> Dear Amar
> Your formula is right
> if you want only the highlighted color then on filter field click o
N REFER MY SHEET LOGIC..
>
> Regards
> Amresh
>
> On Tue, Aug 21, 2012 at 3:42 PM, SAGAR KASANGOTTUWAR <
> sagarkasangottu...@gmail.com> wrote:
>
>> Dear Ameresh,
>>
>> Kindly tell me how we can put scroll in excel like you have done in
>> attache
Dear Hilary,
I want to make dashboard for share accounting and calculations for income
tax.
Kindly help me for the same.
Thanks & Regards,
KSAGAR
On Mon, Aug 27, 2012 at 5:40 PM, NOORAIN ANSARI wrote:
> Nice Creativity HilaryThanks to sharing with us.
>
> On Fri, Aug 24, 2012 at
Dear Hilary,
Can you give some material for understanding DOMAIN area.?
That will help me a lot...
Thanks & Regards,
Sagar Kasangottuwar
On Tue, Aug 28, 2012 at 1:13 PM, wrote:
> **
> Hi KSAGAR
>
> If one doesn't have an understanding of the domain area you can&#
ainansari.com>noorainansari.com<http://www.noorainansari.com>
> http://
> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com>
>
>
> On Tue, Aug 28, 2012 at 10:01 AM, SAGAR KASANGOTTUWAR <
> sagarkasangottu...@gmail.com>
Hi Lucky,
You can use text to column fuction and put delimited from @. Then you can
manually replace com/net etc.
Please seperate the if two mail addresses in one cell.
Regards,
KSAGAR
On Tue, Aug 28, 2012 at 4:40 PM, David Grugeon wrote:
> Hi Noorain
>
> It seems easy enough to create a UDF
Dear Noorain,
Congratulations
Regards,
CA KSAGAR
On Tue, Sep 4, 2012 at 3:42 PM, Kal xcel wrote:
> Brother,
>
> I think, beside your achievement I also achieved something……….that is..
>
> I got a really nice person called “NOORAIN ANSARI”.
>
> Till date whenever I faced any problem in
Dear Noorain,
I am not able to run the programme and showing compile error (Method or
data not found) after running.
Thanks & Regards,
KSAGAR
On Thu, Sep 6, 2012 at 12:07 PM, Kiran Kancharla wrote:
> Hi,
>
> thanks a lot your quick responce..
>
> thanks,
> kiran
>
> On 9/6/12, NOORAIN ANSARI
ck once again, if does',t work revert me.
>
> On Thu, Sep 6, 2012 at 1:22 PM, SAGAR KASANGOTTUWAR <
> sagarkasangottu...@gmail.com> wrote:
>
>> Dear Noorain,
>>
>> I am not able to run the programme and showing compile error (Method or
>> data not fou
workbook for more clearity.
>
>
> On Tue, Jul 31, 2012 at 10:18 PM, SAGAR KASANGOTTUWAR <
> sagarkasangottu...@gmail.com> wrote:
>
>> Dear friends,
>>
>> I had done 500 share trading transaction now I want to know the short
>> term and long term cap
Folder.Files
> Workbooks.Open MyFile
> ActiveWorkbook.Password = "abc"
> ActiveWorkbook.Save
> ActiveWorkbook.Close
> Next
> End Sub
>
>
> On Thu, Sep 6, 2012 at 1:59 PM, SAGAR KASANGOTTUWAR <
> sagarkasangottu...@gmail.com> wrote:
>
>> Dear Noorain,
Dear all,
Any stock management macro in excel then Please give me the same.
Thanks & Regards,
Sagar Kasangottuwar
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate th
ement macro in excel then Please give me the same.
>
>
>
> Thanks & Regards,
>
> Sagar Kasangottuwar
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ members already BANNED for viol
Congratulations Noorain...
Best Regards,
sagar
On Tue, Sep 11, 2012 at 7:26 PM, David Grugeon wrote:
> Loveufe2001
>
> I suggest you post your question in its own thread and try to give a
> bit more of an explanation of what you are doing Also use a suitable
> heading.
>
> On 11 September 2012
nctionality as u require) to be
> in ur macro.
>
> regards
> prince
>
> On Tuesday, September 11, 2012 11:04:42 AM UTC+5:30, ca_k...@yahoo.co.inwrote:
>>
>> Dear all,
>>
>> Any stock management macro in excel then Please give me the same.
>>
>
Dear Paul,
How can we create a list of the 15 report files in a sheet?
Kindly explain the same with example that will help a lot.
Thanks & Regards,
Sagar
On Wed, Sep 12, 2012 at 5:46 PM, dguillett1 wrote:
> As Paul said, there is a better way. Provide a file.
>
> Don Guillett
> Microsoft Exce
Thanks Rajan...
Its great...
On Sat, Sep 15, 2012 at 10:47 AM, Ashish Bhalara
wrote:
> Its very nice Addon, excellent job.
>
>
> On Fri, Sep 14, 2012 at 7:35 PM, Rajan_Verma wrote:
>
>> *Its Wow **J***
>>
>> * *
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
Dear All,
I am facing problem of auto updation values. Ex. I have put the formula in
c3 but when I update value of linked cells then that will not updating in
c3.
Kindly help me on the above matter.
Thanks & Regards,
Sagar
--
Join official facebook page of this forum @
https://www.facebook.
book with group.
>
>
> On Tue, Sep 25, 2012 at 3:50 PM, SAGAR KASANGOTTUWAR <
> sagarkasangottu...@gmail.com> wrote:
>
>> Dear All,
>>
>> I am facing problem of auto updation values. Ex. I have put the formula
>> in c3 but when I update value of linked ce
Dear Don,
I am also cannot see the link...
Whenever I click it will go to GOOGLE
Kindly give the solution ...
Thanks ...
Sagar
On Mon, Sep 24, 2012 at 12:43 PM, Paul wrote:
> Hi Don,
>
> Is there an address that contains your solution as it does not display in
> either of the below URLs
Congrats Rajan
On Wed, Oct 3, 2012 at 10:36 AM, Karan Singh wrote:
> Congrats dude!
>
>
> Karan Singh
>
>
>
>
> On Wed, Oct 3, 2012 at 10:24 AM, Aamir Shahzad
> wrote:
>
>> Congrates Rajan
>>
>> Aamir Shahzad
>> On Wed, Oct 3, 2012 at 9:50 AM, Kuldeep Singh wrote:
>>
>>>
>>> Congratulations
Dear,
I need password for those files.
Thanks.
Sagar
On Thu, Nov 24, 2011 at 4:50 PM, Surbhi Agarwal <
surbhi.agarwal0...@gmail.com> wrote:
> Hi,
>
> These files need password. Please tell me the password.
>
> Thanx
> Surbhi
>
> On Thu, Nov 24, 2011 at 4:18 PM, jmothilal wrote:
>
>> Herewith i
Congrats Mr. Rajan;
Regards,
K Sagar
On Thu, Jan 5, 2012 at 1:16 PM, Subhash Yadav wrote:
> Congrats.
>
> On 1/5/12, Venkat CV wrote:
> > Congrats...Rajan& All...
> >
> > --
> > *Best Regards,*
> > *Venkat *
> > *Chennai*
> > *My Linked in profile <
> http://in.linkedin.com/pub/venkatesan
Dear Priyanka,
You can use Remove duplicates in Excel 2010 and 2007. Select your data and
Alt+A+M.
You will found only unique data.
Regards,
Sagar
On Tue, Oct 30, 2012 at 1:10 PM, Pravin Gunjal wrote:
> *Very nice solutions given by both of you. Thanks.*
> *
> *
> *Regards*
> *Pravin Gunjal
Congratulations Rajan
On Wed, Nov 7, 2012 at 6:17 PM, Karan Singh wrote:
> Congrats dude!!
>
>
>
> Karan Singh
>
>
>
>
> On Tue, Nov 6, 2012 at 5:51 PM, neeraj chauhan > wrote:
>
>> congratulation Rajan sir.
>>
>>
>>
>> On Tue, Nov 6, 2012 at 5:36 PM, Govind Mori wrote:
>>
>>> Congrats Raj
Dear Excel experts,
I want one macro which can spit varios sheets of one excel file to related
other excel file.
I have one excel file where 10 sheets are available ex. a, b, c, d and I
have files for same sheets ex. a, b, c, d.
So I want to transfer a, b, c, d sheets to a, b, c, d file.
Kindly
quot;\" & wks.Name & ".xlsx"
>
> ActiveWorkbook.Close
>
>
> Next
>
> End Sub
>
>
>
> On Mon, Jul 22, 2013 at 5:22 AM, Sagar Kasangottuwar <
> sagarkasangottu...@gmail.com> wrote:
>
>> Dear Excel experts,
>>
>>
Dear Experts,
I have 100 worksbooks which contains worksheet (i.e. Profitability) so I
want to consolidate all the worksheets in one workbook. This worksheet data
is linked from other worksheets so I want that data in as it is in
consolidated workbook.
Kindly help me in this VBA.
Thanks & Regard
help you or you want through it, *
> http://www.wikihow.com/Consolidate-in-Excel*
> *
> *
> *
> *thanks *
>
>
> On Mon, Oct 28, 2013 at 12:32 PM, Sagar Kasangottuwar <
> sagarkasangottu...@gmail.com> wrote:
>
>> Dear Experts,
>>
>> I have 1
ups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Sagar Kasangottuwar
> *Sent:* Monday, October 28, 2013 1:06 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Macro for consolidate worksheets from
> various workbook to specific workbook
; *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Sagar Kasangottuwar
> *Sent:* Monday, October 28, 2013 5:20 PM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Macro for consolidate worksheets from
> vari
Dear Experts,
I want to make one VBA for handling the stock of shares with price in FIFO
method so kindly help me on the this matter.
And If you have any VBA for maintaining the stock of share the please
provide me.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=
44 matches
Mail list logo
