Hi Vikas, Ans For 1 Question Please Select Data after Filter & Press Ctrl+Alt+L then Copy & Paste
For 2nd Question Please send sample data Thanks & Regards Anil Kumar 9999113784 On Mon, Jun 20, 2011 at 1:00 AM, 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 > -- Thanks & Regards Anil Kumar -- ---------------------------------------------------------------------------------- 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
