Results 1 to 4 of 4

generate sheet automatically on the basis of auto filter on specific column

Threaded View

  1. #1
    Registered User
    Join Date
    08-16-2011
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    28

    generate sheet automatically on the basis of auto filter on specific column

    sir,
    i want to generate sheet automatically from existing sheet applying auto filter on specific column. i attached the sample which 3000 rows actually i have more than one lac rows so i have to put filter on sub_div column and then copy and paste to another sheet and give the name of sheet like F21. i want to do automatically this please provide vba code or function for this

    thanks
    manoj
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Creating sheets automatically basis on auto filter
    By tanmanoj in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-08-2014, 08:53 AM
  2. Replies: 1
    Last Post: 03-20-2014, 09:35 AM
  3. [SOLVED] Basis on 1st column automatically select input for 2nd column from another worksheet
    By AasifKhan in forum Excel Formulas & Functions
    Replies: 27
    Last Post: 03-19-2014, 08:43 AM
  4. [SOLVED] Formula to generate third column value on the basis 2 different columns value
    By Manish_Gupta in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-20-2014, 01:52 AM
  5. How to Auto-Generate a duplicate tab on a daily basis
    By jpv5 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2012, 03:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1