Results 1 to 8 of 8

Need VBA to auto copy data from one sheet to specific on based of Staus

Threaded View

  1. #1
    Registered User
    Join Date
    06-04-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2003
    Posts
    3

    Need VBA to auto copy data from one sheet to specific on based of Staus

    I have an excel file with 06 worksheets. I fill data in 01 sheet "Data". I want that on the basis of 'Status column' on 'Data sheet' the data automatically copies to their respective sheets.

    Technology RBO ITEM Qty Estimated Value Customer Status
    Litho Sears Belly Bands 60,000 $6,000.00 abc Universe
    Litho Target-Threshold Belly Band 60,000 $5,000.00 abc Above Funnel
    HTL Target-Threshold HTL 60,000 $54,000.00 abc In Funnel
    FG Aeropostale Pico Patch 60,000 $54,000.00 def Best Few

    urgent help required to do this task.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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