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
will 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 100 worksbooks which contains worksheet (i.e. Profitability) so I
want
@googlegroups.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
** **
Dear
.?
** **
*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
various workbook to specific
Sub
On Mon, Jul 22, 2013 at 5:22 AM, Sagar Kasangottuwar
sagarkasangottu...@gmail.com wrote:
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
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.
Congratulations Rajan
On Wed, Nov 7, 2012 at 6:17 PM, Karan Singh karan1...@gmail.com wrote:
Congrats dude!!
Karan Singh
On Tue, Nov 6, 2012 at 5:51 PM, neeraj chauhan neerajchauhan...@gmail.com
wrote:
congratulation Rajan sir.
On Tue, Nov 6, 2012 at 5:36 PM, Govind Mori
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 art...@hotmail.com wrote:
Hi Don,
Is there an address that contains your solution as it does not display in
either of
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 @
sample workbook 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 cells then that will not updating
in c3.
Kindly
Thanks Rajan...
Its great...
On Sat, Sep 15, 2012 at 10:47 AM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
Its very nice Addon, excellent job.
On Fri, Sep 14, 2012 at 7:35 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Its Wow **J***
* *
* *
*Regards*
*Rajan verma*
*+91
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 dguille...@gmail.com wrote:
As Paul said, there is a better way. Provide a file.
Don Guillett
Congratulations Noorain...
Best Regards,
sagar
On Tue, Sep 11, 2012 at 7:26 PM, David Grugeon da...@grugeon.com.au 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
(functionality 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.
Thanks Regards,
Sagar Kasangottuwar
--
Join official facebook page
Of *SAGAR KASANGOTTUWAR
*Sent:* 11 September 2012 11:05
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Stock management software in excel
** **
Dear all,
Any stock management macro in excel then Please give me the same.
Thanks Regards,
Sagar
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 thread
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 srkira...@gmail.comwrote:
Hi,
thanks a lot your quick responce..
thanks,
kiran
On 9/6/12,
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 found) after running.
Thanks Regards,
KSAGAR
On Thu, Sep 6, 2012
a sample 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 capital gain.
I want a formula for auto averaging of share
ActiveWorkbook.Save
ActiveWorkbook.Close
Next
End Sub
On Thu, Sep 6, 2012 at 1:59 PM, SAGAR KASANGOTTUWAR
sagarkasangottu...@gmail.com wrote:
Dear Noorain,
Please find attached herewith screen shot.
On Thu, Sep 6, 2012 at 1:53 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Wht error
Dear Noorain,
Congratulations
Regards,
CA KSAGAR
On Tue, Sep 4, 2012 at 3:42 PM, Kal xcel kalx...@gmail.com 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
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, resp...@gmail.com wrote:
**
Hi KSAGAR
If one doesn't have an understanding of the domain area you can't design
://www.noorainansari.com
http://
http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com
On Tue, Aug 28, 2012 at 10:01 AM, SAGAR KASANGOTTUWAR
sagarkasangottu...@gmail.com wrote:
Dear Hilary,
I want to make dashboard for share accounting
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 da...@grugeon.com.au wrote:
Hi Noorain
It seems easy
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 noorain.ans...@gmail.comwrote:
Nice Creativity HilaryThanks to sharing with us.
On
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, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Dear Amar
Your formula is right
if you want only the highlighted color then on
THEN 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
attached worksheet...
Thanks Regards,
CA KSAGAR
On Tue, Aug 21, 2012
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 the location of any code is change then linking will not showing
correct results
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 @
*-
--
*From:* SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Fri, August 17, 2012 10:11:33 AM
*Subject:* $$Excel-Macros$$ combining data in one worksheet from other
worksheets
Dear Friends,
I want combine the data
Congratulations Noorain,
All the best ...
You are the heart of this google group...
On Sun, Aug 5, 2012 at 10:30 AM, Aindril De aind...@gmail.com wrote:
Great Work Noorain!!
Though I have been silent in this group for quite some time...
However I keep following the posts.. almost everyday..
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 MACRO's from basic so kindly give me some material for the
same.
Thanks Regards,
K SAGAR
--
FORUM RULES
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,
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 debugging the error 1004 so kindly give
the solution for the same.
Thanks Regards,
Sagar Kasangottuwar
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 1004 at the time of Crl. + A command
** **
Dear all
Excel
SalesAid Software
dguille...@gmail.com
*From:* SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com
*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 the problem in MS
congratulations
On Thu, Mar 15, 2012 at 11:39 AM, jmothilal gjmothi...@gmail.com wrote:
Congratulation Noorain.
Mothilal.J
Universal Computer\
Vellore -2
On Thu, Mar 15, 2012 at 11:36 AM, Dilip Pandey dilipan...@gmail.comwrote:
Congratulations Noorain
Keep up the good work
Congrats Mr. Rajan;
Regards,
K Sagar
On Thu, Jan 5, 2012 at 1:16 PM, Subhash Yadav scy2...@gmail.com wrote:
Congrats.
On 1/5/12, Venkat CV venkat1@gmail.com wrote:
Congrats...Rajan All...
--
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile
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 gjmothi...@gmail.com wrote:
39 matches
Mail list logo