date:20100401

$$Excel-Macros$$ Re: duplicating data

2010-04-01 Thread David Byrne

Hi Lynn,

Your description is a little too vague to allow a solution.

Can you supply a few sample lines from each of the two sheets, and the
result you want to see?

David

On Apr 2, 2:13 am, Lynn  wrote:
> I have 2 excel worksheets, both are in different formats. Both will
> contain the same data but spread across different parts of the
> worksheets.
>
> if I have filled in the data for 1 worksheet, how can i automate this
> data to be filled into the other worksheet?

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Filtering in Excel

2010-04-01 Thread Dipika Mallya

Hi thanks for pointing out the bug, its http://anonomi.com/iname

Also if the topicstarter can provide the raw data it would be helpful
is cusotmizing acc. to need. Now it is like working blind. Any in
depth solution pls free to contact in link.
On 4/1/10, rf1234 rf1234  wrote:
> Hello Dear,
> I have checked your provided link.It is showing spam free
> e mail registration.
>
>
> http://anonomi.com/about/
>
>
>
> Now for the topic asked before.
>
> Shimmy you can try dependent list.Reply me if you are new
> and want more information.
>
>
>
>
> Hope it Will Help
> Happy to Help
> :)
> Shyam
>
>
>
>
>
>
>
>
>
> On Thu, Apr 1, 2010 at 4:19 PM, Dipika Mallya 
> wrote:
>> write in here: http://anonomi.com/DM
>>
>> yourorgname.net/branch/div/emplmgr/mgr/smgr/jmgr/sup/sub
>>
>> in excel format.
>>
>> On Wed, Mar 31, 2010 at 6:36 PM, Shimmy  wrote:
>>>
>>> Hello EXCEL_lent people.
>>>
>>> I am working for an emerging organisation/company. I would like to
>>> create a spreadsheet in Excel for my rganisation in which different
>>> components and their activities will be filtered like in the said
>>> spreadsheet like this:
>>>
>>>
>>> There is one organisation, with 9 components.
>>> Each component has three Division.
>>> Each Division has 6 Senior Managers.
>>> Under every Senior manager there are 3 Emerging managers.
>>> Under every emerging manager there is 2 supervisors.
>>> And under every supervisor there are 15 staff members.
>>> Can someone help me create a filter for this
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our Facebook Group @
>>> http://www.facebook.com/group.php?gid=287779555678
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,800 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>> To unsubscribe, reply using "remove me" as the subject.
>>
>> --
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about
>> the learning and support from the group.Let friends and co-workers know
>> they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
>
>
> --
>
> Thanks Regards
> Shyam
> Software Engineer
> ''
> When one door of happiness closes, another opens;
>  but often we look so long at the closed door that we do not see the
>  one which has been opened for us.
> - Helen Keller
> ''
> Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
> aber oft schauen wir so lange auf die geschlossene Tür,
>  dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
> ''
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><

Re: $$Excel-Macros$$ duplicating data

2010-04-01 Thread Deepak Rai

Hi,

You can use cell referencing for this. Please share a sample file for more
help on this.

Regards,

Deepak

On Thu, Apr 1, 2010 at 8:43 PM, Lynn  wrote:

> I have 2 excel worksheets, both are in different formats. Both will
> contain the same data but spread across different parts of the
> worksheets.
>
> if I have filled in the data for 1 worksheet, how can i automate this
> data to be filled into the other worksheet?
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> To unsubscribe, reply using "remove me" as the subject.
>



-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Sum Product use in Macro

2010-04-01 Thread Rajesh Nair

Hi Friends,

Can Sum Product use in Macro
Is it Possible to get some examples?
I am in trouble
Please help me.

Regards,
Rajesh. Nair

--

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Sum Product use in Macro

2010-04-01 Thread Rajesh Nair

Hi Friends,

Can Sum Product use in Macro
Is it Possible to get some examples?
I am in trouble
Please help me.

Regards,
Rajesh. Nair

--

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ duplicating data

2010-04-01 Thread Lynn

I have 2 excel worksheets, both are in different formats. Both will
contain the same data but spread across different parts of the
worksheets.

if I have filled in the data for 1 worksheet, how can i automate this
data to be filled into the other worksheet?

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ need help

2010-04-01 Thread rf1234 rf1234

Hello Dear
You can automate your excel workbook,according to need u can write code.
If you are new then you can try to download from net.


Some of the example are available here.
http://www.excel-business-solutions.com/free_download.htm


Please have a view of files,template which are uploaded by admin.






Hope it Will Help
Happy To Help
:)
Shyam






On Thu, Apr 1, 2010 at 4:51 PM, Dipika Mallya  wrote:
> yes. what do you want to automate.
>
> On Wed, Mar 31, 2010 at 11:47 PM, Shilpa Rao  wrote:
>>
>> HI
>> any automation tools getting graphs in excel or any other automation tools
>> in excel to get report or any free softwares to get report automated.
>>
>> On Sat, Mar 20, 2010 at 2:47 PM, yogananda muthaiah
>>  wrote:
>>>
>>> Hi,
>>>
>>> Kindly specify your requirements for automating the reports.
>>>
>>>
>>> Regards
>>> Yogananda.Muthaiah
>>> Ph : 9731237267
>>>
>>> On 3/19/10, Shilpa Rao  wrote:
>>> > Hi,
>>> >
>>> > Do we have any tools to automate financial reports?
>>> >
>>> >
>>> >
>>> > --
>>> > Regards,
>>> > Shilpa
>>> >
>>> > --
>>> >
>>> > --
>>> > Some important links for excel users:
>>> > 1. Follow us on TWITTER for tips tricks and links :
>>> > http://twitter.com/exceldailytip
>>> > 2. Join our Facebook Group @
>>> > http://www.facebook.com/group.php?gid=287779555678
>>> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>> >
>>> > To post to this group, send email to excel-macros@googlegroups.com
>>> >
>>> > <><><><><><><><><><><><><><><><><><><><><><>
>>> > HELP US GROW !!
>>> >
>>> > We reach over 6,800 subscribers worldwide and receive many nice notes
>>> > about
>>> > the learning and support from the group.Let friends and co-workers know
>>> > they
>>> > can subscribe to group at
>>> > http://groups.google.com/group/excel-macros/subscribe
>>> >
>>> > To unsubscribe from this group, send email to
>>> > excel-macros+unsubscribegooglegroups.com or reply to this email with
>>> > the
>>> > words "REMOVE ME" as the subject.
>>> >
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our Facebook Group @
>>> http://www.facebook.com/group.php?gid=287779555678
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,800 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscribegooglegroups.com or reply to this email with the
>>> words "REMOVE ME" as the subject.
>>
>>
>>
>> --
>> Regards,
>> Shilpa
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers kn

Re: $$Excel-Macros$$ Filtering in Excel

2010-04-01 Thread rf1234 rf1234

Hello Dear,
I have checked your provided link.It is showing spam free
e mail registration.


http://anonomi.com/about/



Now for the topic asked before.

Shimmy you can try dependent list.Reply me if you are new
and want more information.




Hope it Will Help
Happy to Help
:)
Shyam









On Thu, Apr 1, 2010 at 4:19 PM, Dipika Mallya  wrote:
> write in here: http://anonomi.com/DM
>
> yourorgname.net/branch/div/emplmgr/mgr/smgr/jmgr/sup/sub
>
> in excel format.
>
> On Wed, Mar 31, 2010 at 6:36 PM, Shimmy  wrote:
>>
>> Hello EXCEL_lent people.
>>
>> I am working for an emerging organisation/company. I would like to
>> create a spreadsheet in Excel for my rganisation in which different
>> components and their activities will be filtered like in the said
>> spreadsheet like this:
>>
>>
>> There is one organisation, with 9 components.
>> Each component has three Division.
>> Each Division has 6 Senior Managers.
>> Under every Senior manager there are 3 Emerging managers.
>> Under every emerging manager there is 2 supervisors.
>> And under every supervisor there are 15 staff members.
>> Can someone help me create a filter for this
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>> To unsubscribe, reply using "remove me" as the subject.
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 

Thanks Regards
Shyam
Software Engineer
''
When one door of happiness closes, another opens;
 but often we look so long at the closed door that we do not see the
 one which has been opened for us.
- Helen Keller
''
Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
aber oft schauen wir so lange auf die geschlossene Tür,
 dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
''

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Can Sum Product use in Macro

2010-04-01 Thread André D'Avila

Hello
As i dont like to use FormulaR1C1
i usually use :
activecell.formula = "=SUM(.)"
or as my excel is not english i use
activecell.formulalocal = "=soma()"
soma = sum in my local language understand?
you can decide what is better for you
Regards.
André Luiz D'Avila.
2010/4/1 rf1234 rf1234 

> Hello Dear
> Definately you can any formula in macro.
> R1C1="Your Formula"
>
>
>
>
>
>
>
>
>
>
> Hope it Will Help
> Happy To Help
> :)
> Shyam
>
>
> On Thu, Apr 1, 2010 at 5:10 PM, pushpender nath 
> wrote:
> > Hi Rajesh
> > We can use any formula in Macro.
> >
> > Pushpender Nath
> >
> > On Thu, Apr 1, 2010 at 1:56 PM, Rajesh Nair  wrote:
> >> Hi Friends,
> >>
> >> Can Sum Product use in Macro
> >> Is it Possible to get some examples?
> >>
> >> Please help me.
> >>
> >> Regards,
> >> Rajesh. Nair
> >>
> >> --
> >>
> --
> >> Some important links for excel users:
> >> 1. Follow us on TWITTER for tips tricks and links :
> >> http://twitter.com/exceldailytip
> >> 2. Join our Facebook Group @
> >> http://www.facebook.com/group.php?gid=287779555678
> >> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >>
> >> To post to this group, send email to excel-macros@googlegroups.com
> >>
> >> <><><><><><><><><><><><><><><><><><><><><><>
> >> HELP US GROW !!
> >>
> >> We reach over 6,800 subscribers worldwide and receive many nice notes
> about
> >> the learning and support from the group.Let friends and co-workers know
> they
> >> can subscribe to group at
> >> http://groups.google.com/group/excel-macros/subscribe
> >>
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> > 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
> >
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
> >
> > We reach over 6,800 subscribers worldwide and receive many nice notes
> about the learning and support from the group.Let friends and co-workers
> know they can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
> >
>
>
>
> --
>
> Thanks Regards
> Shyam
> Software Engineer
>
> ''
> When one door of happiness closes, another opens;
>  but often we look so long at the closed door that we do not see the
>  one which has been opened for us.
> - Helen Keller
>
> ''
> Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
> aber oft schauen wir so lange auf die geschlossene Tür,
>  dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
>
> ''
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> To unsubscribe, reply using "remove me" as the subject.
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA M

$$Excel-Macros$$ Re: filter & print to PDF (or similar)

2010-04-01 Thread David Byrne

Hi,

You are correct in your visualisation.

If you care to send me a sample of (dummy?) data I will send you back
a solution.
Please specify if you REALLY want distinct files for each member, or
would be happy with a sheet foe each member.

Regards

David


On Mar 30, 9:22 am, holt  wrote:
> I hope that this request is posted in the correct group and someone
> can assist.
>
> A simple spreadsheet with 2 worksheets. The first is a predetermined
> list of 100 members names whilst the second contains a number of
> columns containing various pieces of information relating to the
> members. For simplicity, the headings are 'member' & 'information'.
> The 'members' column selects from drop down list, validated by the
> list on the first worksheet. New information is added onto the last
> row and I have an active filter so at any given time i can filter
> based on the member to show what information relates to them (possibly
> running to many items)
>
> What I would like to do is include a print facility that, with the
> click of button / macro run, would run through the members list (sheet
> 1) then filter (based on sheet 2) & print individual members
> information to a PDF (or similar) with the file title being that of
> the member. I'd end up with 100 members documents.
>
> This is the simple version as, in reality, the 2nd sheet runs to many
> columns and i realise that i may end up with a number of files
> containing nothing if there is no members information present.
>
> I can visualise what i want to do but I'm totally new to VBA Macros
> and may have offered a solution to a work colleague that i don't
> really know how to achieve.
>
> Thanks

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Re: Median in Pivot Table

2010-04-01 Thread David Byrne

Hi,

This is another example of where Pivot Tables are not always the best
solution.

Send an example of the data and I will find a solution.

David

On Mar 16, 4:24 am, "Rahul Gandhi."  wrote:
> Guys,
>
> Can anyone help me to Get the Median Value in Pivot Table.
>
> Actually I am working on huge data and I have to send the any types of
> analysis which is based on Median Values.
>
> Please try it your end.
>
> Regards
> Rahul Gandhi.
> 9711772297

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Re: Pivot table on horizontal data

2010-04-01 Thread David Byrne

Hi,

It may be that a Pivot Table is not the best solution to your problem.

Send the example, your sample report, and let me try an alternative.

David

On Mar 19, 1:41 am, Ajay Varshney  wrote:
> Hi,
>
> Is there any way of creating pivot table on horizontal data? Means the
> headings are in the rows (instead of columns) and data is in horizontal form
> instead of vertical.
>
> I can't use copy and transpose option because of macros and functions in the
> workbook.
>
> --
> Regards,
> Ajay Varshney

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Re: Excel - sort with VBA problems

2010-04-01 Thread David Byrne

Hi,

Where does the macro stop?

David

On Mar 19, 7:24 am, scubagirl  wrote:
> Hi everyone,
> I have a program that generates Excel workbooks with multiple sheets
> of data , and a function that create a chart each time it's called,
> which happens 2 times per workbook. In order to make the chart, I have
> to sort the data first, which I've tried a few different ways. No
> matter which way I do it, get a "Run-time error '1004': Method 'Range'
> of object '_Global' failed" error on the line that does the sorting
> when this function is called the 3rd time (after the 2nd workbook is
> created).
>
> I think this is a result of having multiple workbooks and not checking
> to make sure which one the data in question is coming from, but the
> newest workbook is always the active one so I'm not sure why this
> matters. Any suggestions for how I can resolve this?
>
> Here is the code:
>
> Private Function CreateChart(sheet As excel.Worksheet, chartsize As
> Integer, _
>     sheet_name As String, chart_name As String, xaxis_label As String,
> yaxis_label As String)
>
>     Dim data_range As excel.Range
>     Dim i As Integer
>     Dim num_srs As Integer
>     Dim num_jrs As Integer
>
>     num_srs = tracker.NumSeniors
>     num_jrs = tracker.NumJuniors
>
>     'sort the data
>  Range("A2:B" & chartsize).Sort Key1:=Range("B2"),
> Order1:=xlAscending, Key2:=Range("A2"), _
>         Order2:=xlYes, Header:=xlNo, OrderCustom:=1, MatchCase:= _
>         False, Orientation:=xlTopToBottom
>
>     'calculate average and standard deviation
>     sheet.Cells(1, 6).value = "Average"
>     sheet.Cells(1, 7).value = "=average($B$2:$B$" & chartsize & ")"
>     sheet.Cells(2, 6).value = "Standard Deviation"
>     sheet.Cells(2, 7).value = "=stdev($B$2:$B$" & chartsize & ")"
>
>     'calculate CDF
>     For i = 1 To chartsize - 1
>         sheet.Cells(i + 1, 3).value = "=NORMDIST($B" & i + 1 & ", $G
> $1, $G$2, TRUE)"
>     Next
>
>     sheet.Columns.AutoFit
>
>     'choose the data range for the chart and add chart to new sheet
>     Set data_range = sheet.Range("B2:B" & chartsize, "C2:C" &
> chartsize)
>     m_workbook.Charts.Add
>
>     'format the chart
>     With m_workbook.ActiveChart
>         .ChartType = xlXYScatterLines
>         .SetSourceData data_range, xlColumns
>         .Location xlLocationAsNewSheet, sheet_name
>         .HasTitle = True
>         .ChartTitle.Text = chart_name & vbNewLine & "(" & num_jrs & "
> Junior Engineer(s) and " & num_srs & " Senior Engineer(s))"
>         .HasLegend = False
>         .HasDataTable = False
>         .Axes(xlValue, xlCategory).HasTitle = True
>         .Axes(xlValue, xlPrimary).AxisTitle.Characters.Text =
> yaxis_label
>         .Axes(xlCategory, xlPrimary).HasTitle = True
>         .Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text =
> xaxis_label
>         .Axes(xlCategory).MinimumScale = Round(sheet.Cells(2, 4), 0)
>         .Axes(xlValue).MaximumScale = 1
>     End With
>
> End Function

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Re: How to remove Invisible symbols in a cell.

2010-04-01 Thread rf1234 rf1234

Hello Dear
Try to select range what u want to format.then format cell then time
then desired fromat.





If you are looking this in VBA Macro.Then try to use this.

Option Explicit
Sub Macro1()
Worksheets("Sheet1").Range("F2:F65536").Select
Selection.NumberFormat = "[$-409]m/d/yy h:mm AM/PM;@"
End Sub





Hope It Will Help
Happy To Help
:)
Shyam

On Thu, Apr 1, 2010 at 8:20 AM, Dipika Mallya  wrote:
> try the inbuilt custom reformatter method.
>
> with regards,
> DM
>
> On Wed, Mar 31, 2010 at 5:35 PM, nike  wrote:
>>
>> Hi Paul Willekens,
>> some of the cells are followed by " mm/dd/ hh:mm"(24Hrs )  format
>> some of the followed by "mm/dd/ hh:mm AM/PM" i want "mm/dd/
>> hh:mm AM/PM".
>>
>> thx for u r sugesstion and i tried below customize from cell Format
>> menu.
>>
>> thanks in adv.
>> Mynampat (Nike)
>>
>>
>> On Mar 31, 2:36 am, paulwillekens 
>> wrote:
>> > Hi Nike,
>> >
>> > Maybe I do not see the problem, but let me focus on the solution...
>> >
>> > Just select the columns or range of data cells and specify the cell
>> > properties... special format e.g.  mm/dd/ hh:mm or whatever you
>> > preference is...
>> >
>> > Good luck
>> >
>> > Paul Willekens
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>> To unsubscribe, reply using "remove me" as the subject.
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 

Thanks Regards
Shyam
Software Engineer
''
When one door of happiness closes, another opens;
 but often we look so long at the closed door that we do not see the
 one which has been opened for us.
- Helen Keller
''
Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
aber oft schauen wir so lange auf die geschlossene Tür,
 dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
''

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><>

Re: $$Excel-Macros$$ Track changes macro

2010-04-01 Thread rf1234 rf1234

Hello Dear
If your workbook is in share mode,you can trace the authenticate user,who has
made the changes...


Just try to
check:
Worksheets("Sheet1").OnEntry

If true then report or save the log with user name and machine id.

I am just giving idea,for full programe it will take time.








Hope it Will Help
Happy To Help
:)
Shyam

On Thu, Apr 1, 2010 at 4:50 PM, Dipika Mallya  wrote:
> can you elaborate unauthroised access /
>
> On Thu, Apr 1, 2010 at 12:04 AM, seema mba  wrote:
>>
>> Hello Master,
>>
>> I have got a macro to track changes made in excel sheet. But the changes
>> are tracked in sheet1 of the same work book. I want a macro which keeps the
>> track of changes, in a different workbook and not the same workbook. In
>> short instead of keeping the log of changes in sheet1 of the same workbook,
>> I want to keep the log of changes in a separate workbook. As & when I make
>> sum changes in workbook X, it should be tracked in a different workbook Y.
>> Or else if someone could help me do it in a different way. When a file is
>> shared among different users, the track of changes made can be obtained by
>> clicking on track changes option in excel. It gives an option to display all
>> the changes in a separate sheet named history. A macro that can save this
>> history sheet in a separate workbook might help to solve the problem.
>> Hope to get some help on this. I work on a shared file where many people
>> do unauthorised changes due to which all people working on the file have to
>> suffer. The problem is, once a file is unshared we loose the history of
>> track changes.
>> Plsss help.
>>
>> Regards,
>>
>> Seema
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 

Thanks Regards
Shyam
Software Engineer
''
When one door of happiness closes, another opens;
 but often we look so long at the closed door that we do not see the
 one which has been opened for us.
- Helen Keller
''
Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
aber oft schauen wir so lange auf die geschlossene Tür,
 dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
''

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><>

Re: $$Excel-Macros$$ Can Sum Product use in Macro

2010-04-01 Thread rf1234 rf1234

Hello Dear
Definately you can any formula in macro.
R1C1="Your Formula"










Hope it Will Help
Happy To Help
:)
Shyam


On Thu, Apr 1, 2010 at 5:10 PM, pushpender nath  wrote:
> Hi Rajesh
> We can use any formula in Macro.
>
> Pushpender Nath
>
> On Thu, Apr 1, 2010 at 1:56 PM, Rajesh Nair  wrote:
>> Hi Friends,
>>
>> Can Sum Product use in Macro
>> Is it Possible to get some examples?
>>
>> Please help me.
>>
>> Regards,
>> Rajesh. Nair
>>
>> --
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes about
>> the learning and support from the group.Let friends and co-workers know they
>> can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links : 
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @ 
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about 
> the learning and support from the group.Let friends and co-workers know they 
> can subscribe to group at 
> http://groups.google.com/group/excel-macros/subscribe
>



-- 

Thanks Regards
Shyam
Software Engineer
''
When one door of happiness closes, another opens;
 but often we look so long at the closed door that we do not see the
 one which has been opened for us.
- Helen Keller
''
Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
aber oft schauen wir so lange auf die geschlossene Tür,
 dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
''

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Filtering in Excel

2010-04-01 Thread Dipika Mallya

write in here: http://anonomi.com/DM

yourorgname.net/branch/div/emplmgr/mgr/smgr/jmgr/sup/sub

in excel format.

On Wed, Mar 31, 2010 at 6:36 PM, Shimmy  wrote:

> Hello EXCEL_lent people.
>
> I am working for an emerging organisation/company. I would like to
> create a spreadsheet in Excel for my rganisation in which different
> components and their activities will be filtered like in the said
> spreadsheet like this:
>
>
> There is one organisation, with 9 components.
> Each component has three Division.
> Each Division has 6 Senior Managers.
> Under every Senior manager there are 3 Emerging managers.
> Under every emerging manager there is 2 supervisors.
> And under every supervisor there are 15 staff members.
> Can someone help me create a filter for this
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> To unsubscribe, reply using "remove me" as the subject.
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Can Sum Product use in Macro

2010-04-01 Thread pushpender nath

Hi Rajesh
We can use any formula in Macro.

Pushpender Nath

On Thu, Apr 1, 2010 at 1:56 PM, Rajesh Nair  wrote:
> Hi Friends,
>
> Can Sum Product use in Macro
> Is it Possible to get some examples?
>
> Please help me.
>
> Regards,
> Rajesh. Nair
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ need help

2010-04-01 Thread Dipika Mallya

yes. what do you want to automate.

On Wed, Mar 31, 2010 at 11:47 PM, Shilpa Rao  wrote:

> HI
> any automation tools getting graphs in excel or any other automation tools
> in excel to get report or any free softwares to get report automated.
>
>
> On Sat, Mar 20, 2010 at 2:47 PM, yogananda muthaiah <
> yogananda.mutha...@gmail.com> wrote:
>
>> Hi,
>>
>> Kindly specify your requirements for automating the reports.
>>
>>
>> Regards
>> Yogananda.Muthaiah
>> Ph : 9731237267
>>
>> On 3/19/10, Shilpa Rao  wrote:
>> > Hi,
>> >
>> > Do we have any tools to automate financial reports?
>> >
>> >
>> >
>> > --
>> > Regards,
>> > Shilpa
>> >
>> > --
>> >
>> --
>> > Some important links for excel users:
>> > 1. Follow us on TWITTER for tips tricks and links :
>> > http://twitter.com/exceldailytip
>> > 2. Join our Facebook Group @
>> > http://www.facebook.com/group.php?gid=287779555678
>> > 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>> >
>> > To post to this group, send email to excel-macros@googlegroups.com
>> >
>> > <><><><><><><><><><><><><><><><><><><><><><>
>> > HELP US GROW !!
>> >
>> > We reach over 6,800 subscribers worldwide and receive many nice notes
>> about
>> > the learning and support from the group.Let friends and co-workers know
>> they
>> > can subscribe to group at
>> > http://groups.google.com/group/excel-macros/subscribe
>> >
>> > To unsubscribe from this group, send email to
>> > excel-macros+unsubscribegooglegroups.com or reply to this email with
>> the
>> > words "REMOVE ME" as the subject.
>> >
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>> To unsubscribe from this group, send email to excel-macros+
>> unsubscribegooglegroups.com or reply to this email with the words "REMOVE
>> ME" as the subject.
>>
>
>
>
> --
>  Regards,
> Shilpa
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Track changes macro

2010-04-01 Thread Dipika Mallya

can you elaborate unauthroised access /

On Thu, Apr 1, 2010 at 12:04 AM, seema mba  wrote:

> Hello Master,
>
> I have got a macro to track changes made in excel sheet. But the changes
> are tracked in sheet1 of the same work book. I want a macro which keeps the
> track of changes, in a different workbook and not the same workbook. In
> short instead of keeping the log of changes in sheet1 of the same workbook,
> I want to keep the log of changes in a separate workbook. As & when I make
> sum changes in workbook X, it should be tracked in a different workbook Y.
> Or else if someone could help me do it in a different way. When a file is
> shared among different users, the track of changes made can be obtained by
> clicking on track changes option in excel. It gives an option to display all
> the changes in a separate sheet named history. A macro that can save this
> history sheet in a separate workbook might help to solve the problem.
> Hope to get some help on this. I work on a shared file where many people do
> unauthorised changes due to which all people working on the file have to
> suffer. The problem is, once a file is unshared we loose the history of
> track changes.
> Plsss help.
>
> Regards,
>
> Seema
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Re: Please help In seperating alphabets and numbers from a cell

2010-04-01 Thread Dipika Mallya

Great point Paul,

@Abhi

To add to Paul's Excell insight with a working example,

Suppose two functional links.
http://j.mp/gate2010csit
http://j.mp/gate2010cs
exist

Does your function need to identify the csit link from the cs link or not.

Regards,

DM
http://anonomi.com/iname
http://anonomi.com/DM

On Wed, Mar 31, 2010 at 2:24 AM, paulwillekens <
paul.johan.willek...@gmail.com> wrote:

> Hi Abhidha,
>
> Please specify what the result is you look for...
> is it jdsdnc versus 2123 versus asdd ... or only extraction of the
> number 2123 ?
> is it iofruif versus 68732 versus fnw ... or simply 68732 ?
> do digits appear separated by alphabetical characters on some
> occasions or never?
>
> As soon as I get that cleared out, I'll send you the routine you
> need...
>
> Greetings,
>
> Paul Willekens
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> To unsubscribe, reply using "remove me" as the subject.
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Data Import

2010-04-01 Thread Dipika Mallya

On.Count >1l goto next worksheet.

On Thu, Apr 1, 2010 at 11:44 AM, Mahesh  wrote:

>  Dear All,
>
> Need ur expat advise...
>
> I got around 20 text files in a day,which had 13 to 15 columns separated by
> "|" this sign. each file contains around 15 lacs or more line items.
>
> when i import that text file in excel 2007, it takes the first 10 lacs
> records; rest does not come.
>
> Need ur help to solve this,
>
> I want that rest records should move to next sheet of the same workbook.
>
> --
> With Love,
> Mahesh Bisht
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

Re: $$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric String

2010-04-01 Thread rf1234 rf1234

Hello Dear
Syntax would be as follows...

=SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE(
SUBSTITUTE( SUBSTITUTE( SUBSTITUTE(A2,"1",""),"2",""),
"3",""),"4",""),"5",""), "6",""),"7",""),"8","")





You guys are doing fine job,to giving the helping hand.








Hope it Will Help
Happy to Help
:)
Shyam

On Thu, Apr 1, 2010 at 1:04 PM, Dave Bonallack
 wrote:
> Hi,
> You could try using the formula provided for finding the numbers only, then
> use that result with the SUBSTITUTE function substituting the numbers with
> ""
> Regards - Dave.
>
> 
> Date: Wed, 31 Mar 2010 11:03:55 +0530
> Subject: Re: $$Excel-Macros$$ Tip of The day:Extract Number FROM
> Alphanumeric String
> From: ca.mod...@gmail.com
> To: excel-macros@googlegroups.com
>
>
>
> Dear All
>
>
> if there is a coloum containg mix of nos and alphabets
>
> like ram12
> moh12345an
> 132shyam
>
> we need only alphabets what can we do
>
> like ram
> mohan
> shyam
>
>
>
> Here we can seprate only nos. but what can we do if we want alphabets
> sepreately.
>
> Help in this query.
>
> Thanks in advance
>
> Regards
> LKModi
> 9309243685
>
>
>
>
>
>
>
>
>
>
> On 3/30/10, rf1234 rf1234  wrote:
>
> Dear All,
> Attached is the macro to extracting the numeric value from alphanumeric
> string.
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> --
>
> Thanks Regards
> Shyam
> Software Engineer
> ''
> When one door of happiness closes, another opens;
> but often we look so long at the closed door that we do not see the
> one which has been opened for us.
> - Helen Keller
> ''
> Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
> aber oft schauen wir so lange auf die geschlossene Tür,
> dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
> ''
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> To unsubscribe from this group, send email to
> excel-macros+unsubscribegooglegroups.com or reply to this email with the
> words "REMOVE ME" as the subject.
>
>
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> 
> Find out now. Link all your email accounts and social updates with Hotmail.
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
>

$$Excel-Macros$$ Re: Help......................

2010-04-01 Thread paulwillekens

Hi Abdul,

Just send in your spreadsheet, so we can see it with our own eyes and
then work on a solution

Greetings

Paul Willekens

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Can Sum Product use in Macro

2010-04-01 Thread Rajesh Nair

Hi Friends,

Can Sum Product use in Macro
Is it Possible to get some examples?

Please help me.

Regards,
Rajesh. Nair

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Help......................

2010-04-01 Thread worawat kh

Hi Rasheed ,

You have to go to toolbar
Tool --- > Option --- > Calculation and select "Automatic" .

may be can help

Worawat
~ Blog ~ 1 
~ Blog ~ 2 


2010/3/31 Abdul Rasheed 

> hi fellows
> i hit a prob in excel sheet ... on change of figures, formula does not
> updated automatically.. i have to get in the cell by pressing F2 and then
> enter... its so pathetic... n wanna permanent solution.
> is there any1 to help me out.
> regards
>
>
> --
> Regards,
> Abdul Rasheed
>
> Confidence never comes if we have all the answers, Be ready for all the
> questions... .Be bold to face the world
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Moo Moo'
MyBlog
http://ExcelBeginner.BlogSpot.Com  >>> Excel Tip
http://MySTTAtrtip.BlogSpot.Com >>>My trip picture

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

RE: $$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric String

2010-04-01 Thread Dave Bonallack


Hi,

You could try using the formula provided for finding the numbers only, then use 
that result with the SUBSTITUTE function substituting the numbers with ""

Regards - Dave.
 


Date: Wed, 31 Mar 2010 11:03:55 +0530
Subject: Re: $$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric 
String
From: ca.mod...@gmail.com
To: excel-macros@googlegroups.com


 
 
Dear All
 
 
if there is a coloum containg mix of nos and alphabets
 
like ram12
moh12345an
132shyam
 
we need only alphabets what can we do
 
like ram
mohan
shyam
 
 
 
Here we can seprate only nos. but what can we do if we want alphabets 
sepreately.
 
Help in this query.
 
Thanks in advance
 
Regards
LKModi
9309243685
 
 
 
 
 
 
 
 


 
On 3/30/10, rf1234 rf1234  wrote: 
Dear All,
Attached is the macro to extracting the numeric value from alphanumeric string.














--

Thanks Regards
Shyam
Software Engineer
''
When one door of happiness closes, another opens;
but often we look so long at the closed door that we do not see the
one which has been opened for us.
- Helen Keller
''
Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres,
aber oft schauen wir so lange auf die geschlossene Tür,
dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller
''

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe from this group, send email to 
excel-macros+unsubscribegooglegroups.com or reply to this email with the words 
"REMOVE ME" as the subject.




-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
 
We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
  
_
Link all your email accounts and social updates with Hotmail. Find out now.
http://windowslive.ninemsn.com.au/oneinbox?ocid=T162MSN05A0710G

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Data Import

2010-04-01 Thread Mahesh

 Dear All,

Need ur expat advise...

I got around 20 text files in a day,which had 13 to 15 columns separated by
"|" this sign. each file contains around 15 lacs or more line items.

when i import that text file in excel 2007, it takes the first 10 lacs
records; rest does not come.

Need ur help to solve this,

I want that rest records should move to next sheet of the same workbook.

-- 
With Love,
Mahesh Bisht

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

To unsubscribe, reply using "remove me" as the subject.

$$Excel-Macros$$ Re: duplicating data

Re: $$Excel-Macros$$ Filtering in Excel

Re: $$Excel-Macros$$ duplicating data

$$Excel-Macros$$ Sum Product use in Macro

$$Excel-Macros$$ Sum Product use in Macro

$$Excel-Macros$$ duplicating data

Re: $$Excel-Macros$$ need help

Re: $$Excel-Macros$$ Filtering in Excel

Re: $$Excel-Macros$$ Can Sum Product use in Macro

$$Excel-Macros$$ Re: filter & print to PDF (or similar)

$$Excel-Macros$$ Re: Median in Pivot Table

$$Excel-Macros$$ Re: Pivot table on horizontal data

$$Excel-Macros$$ Re: Excel - sort with VBA problems

Re: $$Excel-Macros$$ Re: How to remove Invisible symbols in a cell.

Re: $$Excel-Macros$$ Track changes macro

Re: $$Excel-Macros$$ Can Sum Product use in Macro

Re: $$Excel-Macros$$ Filtering in Excel

Re: $$Excel-Macros$$ Can Sum Product use in Macro

Re: $$Excel-Macros$$ need help

Re: $$Excel-Macros$$ Track changes macro

Re: $$Excel-Macros$$ Re: Please help In seperating alphabets and numbers from a cell

Re: $$Excel-Macros$$ Data Import

Re: $$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric String

$$Excel-Macros$$ Re: Help......................

$$Excel-Macros$$ Can Sum Product use in Macro

Re: $$Excel-Macros$$ Help......................

RE: $$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric String

$$Excel-Macros$$ Data Import

28 matches

Site Navigation

Mail list logo

Footer information