$$Excel-Macros$$ Re: Problem with filters in Excel 2007

[aju chacko]

HI Mahesh Bisht,
 Please try to keep the cursor in data area instead
of column heading while you are copying the data,Also Microsoft has
announced a patch to solve this problem which I will give you shortly.
 AJU

On Tue, Oct 20, 2009 at 9:21 AM, Mahesh  wrote:

> Hi Friends,
>
> I m facing a problem while using Auto filter in Excel 2007
>
> When i use filter and copy the data from 1 sheet to another sheet the
> hidden cell are also copy from 1 to another sheet.
>
> Please help to solve this
>
> --
> With Love,
> Mahesh Bisht
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Problem with filters in Excel 2007

[Manoj S Negi]

Hi Mahesh,

Please note the solution of your problem as follows..

After applying filter just select the desired data, which you want to copy,
& than click the option "Select visible Cells" and than copy and
paste.



*for option "Select visible Cells" go to office button and than click excel
option, >> click Customize,>> than there is drop down "Choose commands
from".
Select "All Commands" in above said drop down and after than just add the
option "Select Visible Cells" in your quick Access Toolbar. The quick Access
Toolbar is available in top & left of the sheet (for reference pic mentioned
below).
*

*

Unfeigned Regards
Manoj S Negi
Skype - manojsnegi
*

> On Tue, Oct 20, 2009 at 9:21 AM, Mahesh  wrote:
>
>> Hi Friends,
>>
>> I m facing a problem while using Auto filter in Excel 2007
>>
>> When i use filter and copy the data from 1 sheet to another sheet the
>> hidden cell are also copy from 1 to another sheet.
>>
>> Please help to solve this
>>
>> --
>> With Love,
>> Mahesh Bisht
>>
>>
>>
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Problem with filters in Excel 2007

[Mahesh]

Hi Aju,

Thanx for ur suggestion, but i m copying the cells not column

And i m w8ing for the patch

Mahender Bisht

On Thu, Oct 22, 2009 at 8:42 PM, aju chacko  wrote:

> HI Mahesh Bisht,
>  Please try to keep the cursor in data area instead
> of column heading while you are copying the data,Also Microsoft has
> announced a patch to solve this problem which I will give you shortly.
>  AJU
>
> On Tue, Oct 20, 2009 at 9:21 AM, Mahesh  wrote:
>
>> Hi Friends,
>>
>> I m facing a problem while using Auto filter in Excel 2007
>>
>> When i use filter and copy the data from 1 sheet to another sheet the
>> hidden cell are also copy from 1 to another sheet.
>>
>> Please help to solve this
>>
>> --
>> With Love,
>> Mahesh Bisht
>>
>>
>>
>
> >
>


-- 
With Love,
Mahesh Bisht

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Problem with filters in Excel 2007

[Manoj S Negi]

Hi Mahesh,

Please note the solution of your problem as follows..

After applying filter just select the desired data, which you want to copy,
& than click the option "Select visible Cells" and than copy and
paste.



*for option "Select visible Cells" go to office button and than click excel
option, >> click Customize,>> than there is drop down "Choose commands
from".
Select "All Commands" in above said drop down and after than just add the
option "Select Visible Cells" in your quick Access Toolbar. The quick Access
Toolbar is available in top & left of the sheet (for reference pic mentioned
below).
*


*

Hope it will help you.


Unfeigned Regards
Manoj S Negi
Skype - manojsnegi*

On Fri, Oct 23, 2009 at 9:09 AM, Mahesh  wrote:

> Hi Aju,
>
> Thanx for ur suggestion, but i m copying the cells not column
>
> And i m w8ing for the patch
>
> Mahender Bisht
>
> On Thu, Oct 22, 2009 at 8:42 PM, aju chacko  wrote:
>
>> HI Mahesh Bisht,
>>  Please try to keep the cursor in data area
>> instead of column heading while you are copying the data,Also Microsoft has
>> announced a patch to solve this problem which I will give you shortly.
>>  AJU
>>
>> On Tue, Oct 20, 2009 at 9:21 AM, Mahesh  wrote:
>>
>>> Hi Friends,
>>>
>>> I m facing a problem while using Auto filter in Excel 2007
>>>
>>> When i use filter and copy the data from 1 sheet to another sheet the
>>> hidden cell are also copy from 1 to another sheet.
>>>
>>> Please help to solve this
>>>
>>> --
>>> With Love,
>>> Mahesh Bisht
>>>
>>>
>>>
>>
>>
>
>
> --
> With Love,
> Mahesh Bisht
>
> >
>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Problem with filters in Excel 2007

[Mahesh]

Hi Manoj,

Thanx for your suggestion,

But when i m clicking on all commands, its given my error.

Please help..




On Fri, Oct 23, 2009 at 2:13 PM, Manoj S Negi <
manojsnegi.uttranc...@gmail.com> wrote:

> Hi Mahesh,
>
> Please note the solution of your problem as follows..
>
> After applying filter just select the desired data, which you want to copy,
> & than click the option "Select visible Cells" and than copy and
> paste.
>
>
>
> *for option "Select visible Cells" go to office button and than click
> excel option, >> click Customize,>> than there is drop down "Choose commands
> from".
> Select "All Commands" in above said drop down and after than just add the
> option "Select Visible Cells" in your quick Access Toolbar. The quick Access
> Toolbar is available in top & left of the sheet (for reference pic
> mentioned below).
> *
>
>
> 
> *
>
> Hope it will help you.
>
>
> Unfeigned Regards
> Manoj S Negi
> Skype - manojsnegi
> *
>
>
> On Fri, Oct 23, 2009 at 9:09 AM, Mahesh  wrote:
>
>> Hi Aju,
>>
>> Thanx for ur suggestion, but i m copying the cells not column
>>
>> And i m w8ing for the patch
>>
>> Mahender Bisht
>>
>>   On Thu, Oct 22, 2009 at 8:42 PM, aju chacko wrote:
>>
>>> HI Mahesh Bisht,
>>>  Please try to keep the cursor in data area
>>> instead of column heading while you are copying the data,Also Microsoft has
>>> announced a patch to solve this problem which I will give you shortly.
>>>  AJU
>>>
>>> On Tue, Oct 20, 2009 at 9:21 AM, Mahesh wrote:
>>>
 Hi Friends,

 I m facing a problem while using Auto filter in Excel 2007

 When i use filter and copy the data from 1 sheet to another sheet the
 hidden cell are also copy from 1 to another sheet.

 Please help to solve this

 --
 With Love,
 Mahesh Bisht



>>>
>>>
>>
>>
>> --
>> With Love,
>> Mahesh Bisht
>>
>> >>
>>
>


-- 
With Love,
Mahesh Bisht

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Problem with filters in Excel 2007

[aju chacko]

HI mahesh,
 The patch I mentioned is aivilable in following web site
http://support.microsoft.com/kb/948944  .
Please download and install this patch,If again problem persits you have to
install office service pack 1 & 2

aju v chacko

On Fri, Oct 23, 2009 at 3:09 PM, Mahesh  wrote:

> Hi Manoj,
>
> Thanx for your suggestion,
>
> But when i m clicking on all commands, its given my error.
>
> Please help..
>
>
>
>
> On Fri, Oct 23, 2009 at 2:13 PM, Manoj S Negi <
> manojsnegi.uttranc...@gmail.com> wrote:
>
>> Hi Mahesh,
>>
>> Please note the solution of your problem as follows..
>>
>> After applying filter just select the desired data, which you want to
>> copy, & than click the option "Select visible Cells" and than copy and
>> paste.
>>
>>
>>
>> *for option "Select visible Cells" go to office button and than click
>> excel option, >> click Customize,>> than there is drop down "Choose commands
>> from".
>> Select "All Commands" in above said drop down and after than just add the
>> option "Select Visible Cells" in your quick Access Toolbar. The quick Access
>> Toolbar is available in top & left of the sheet (for reference pic
>> mentioned below).
>> *
>>
>>
>> 
>> *
>>
>> Hope it will help you.
>>
>>
>> Unfeigned Regards
>> Manoj S Negi
>> Skype - manojsnegi
>> *
>>
>>
>> On Fri, Oct 23, 2009 at 9:09 AM, Mahesh  wrote:
>>
>>> Hi Aju,
>>>
>>> Thanx for ur suggestion, but i m copying the cells not column
>>>
>>> And i m w8ing for the patch
>>>
>>> Mahender Bisht
>>>
>>>   On Thu, Oct 22, 2009 at 8:42 PM, aju chacko wrote:
>>>
 HI Mahesh Bisht,
  Please try to keep the cursor in data area
 instead of column heading while you are copying the data,Also Microsoft has
 announced a patch to solve this problem which I will give you shortly.
  AJU

 On Tue, Oct 20, 2009 at 9:21 AM, Mahesh wrote:

> Hi Friends,
>
> I m facing a problem while using Auto filter in Excel 2007
>
> When i use filter and copy the data from 1 sheet to another sheet the
> hidden cell are also copy from 1 to another sheet.
>
> Please help to solve this
>
> --
> With Love,
> Mahesh Bisht
>
>
>


>>>
>>>
>>> --
>>> With Love,
>>> Mahesh Bisht
>>>
>>>
>>> --
>>> With Love,
>>> Mahesh Bisht
>>>
>>> >>>
>>>

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Problem with filters in Excel 2007

[Mahesh]

thanx a lot..




On Fri, Oct 23, 2009 at 8:56 PM, aju chacko  wrote:

> HI mahesh,
>  The patch I mentioned is aivilable in following web site
> http://support.microsoft.com/kb/948944  .
> Please download and install this patch,If again problem persits you have to
> install office service pack 1 & 2
>
> aju v chacko
>
>
> On Fri, Oct 23, 2009 at 3:09 PM, Mahesh  wrote:
>
>> Hi Manoj,
>>
>> Thanx for your suggestion,
>>
>> But when i m clicking on all commands, its given my error.
>>
>> Please help..
>>
>>
>>
>>
>> On Fri, Oct 23, 2009 at 2:13 PM, Manoj S Negi <
>> manojsnegi.uttranc...@gmail.com> wrote:
>>
>>> Hi Mahesh,
>>>
>>> Please note the solution of your problem as follows..
>>>
>>> After applying filter just select the desired data, which you want to
>>> copy, & than click the option "Select visible Cells" and than copy and
>>> paste.
>>>
>>>
>>>
>>> *for option "Select visible Cells" go to office button and than click
>>> excel option, >> click Customize,>> than there is drop down "Choose commands
>>> from".
>>> Select "All Commands" in above said drop down and after than just add the
>>> option "Select Visible Cells" in your quick Access Toolbar. The quick Access
>>> Toolbar is available in top & left of the sheet (for reference pic
>>> mentioned below).
>>> *
>>>
>>>
>>> 
>>> *
>>>
>>> Hope it will help you.
>>>
>>>
>>>
>>> Unfeigned Regards
>>> Manoj S Negi
>>> Skype - manojsnegi
>>> *
>>>
>>>
>>> On Fri, Oct 23, 2009 at 9:09 AM, Mahesh wrote:
>>>
 Hi Aju,

 Thanx for ur suggestion, but i m copying the cells not column

 And i m w8ing for the patch

 Mahender Bisht

   On Thu, Oct 22, 2009 at 8:42 PM, aju chacko wrote:

> HI Mahesh Bisht,
>  Please try to keep the cursor in data area
> instead of column heading while you are copying the data,Also Microsoft 
> has
> announced a patch to solve this problem which I will give you shortly.
>  AJU
>
> On Tue, Oct 20, 2009 at 9:21 AM, Mahesh wrote:
>
>> Hi Friends,
>>
>> I m facing a problem while using Auto filter in Excel 2007
>>
>> When i use filter and copy the data from 1 sheet to another sheet the
>> hidden cell are also copy from 1 to another sheet.
>>
>> Please help to solve this
>>
>> --
>> With Love,
>> Mahesh Bisht
>>
>>
>>
>
>


 --
 With Love,
 Mahesh Bisht


 --
 With Love,
 Mahesh Bisht



>
> >
>


-- 
With Love,
Mahesh Bisht

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---