Hi Vikas, Answer (a): Use the Shortcut *" Alt + ; "
Apply Filter ==> Select Data ==> Alt + ; ==> Copy ==> Paste* Rgds, Maries On Mon, Jun 20, 2011 at 12:00 PM, Vikas Agarwal <vikas....@gmail.com> wrote: > Hi All, > > I need help on two things: > > a) I have filtered data from a large range (say A1 to A200000). When in > copy and paste a formula in visible cells, excel 2007 throws error and > copies data in the entire range instead of only visible cells. How do i copy > and paste only in visible cells. > > b) Is there a way to create pivot from a column range eg: if my data is > employee names in various rows and year in column. Can i prepare a pivot > year-wise to see the results. > > > Rgds, > > Vikas > > 9820427939 > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel