Results 1 to 8 of 8

Macro to Filter & Extract Data to a New Workbook

Threaded View

foxluc Macro to Filter & Extract... 12-05-2011, 07:19 AM
JapanDave Re: Macro to Filter & Extract... 12-05-2011, 07:37 AM
foxluc Re: Macro to Filter & Extract... 12-05-2011, 07:42 AM
snb Re: Macro to Filter & Extract... 12-05-2011, 07:58 AM
foxluc Re: Macro to Filter & Extract... 12-05-2011, 08:06 AM
  1. #1
    Registered User
    Join Date
    06-09-2011
    Location
    EU
    MS-Off Ver
    Excel 2007
    Posts
    4

    Macro to Filter & Extract Data to a New Workbook

    Hi everyone,
    I'm stuck here, trying to write a macro that would filter data out of active worksheet and extract it into a new workbook. Please view attached file for reference.

    I need the macro to filter the data in Activesheet (which would be protected except for column C) and extract each row in which there's a record of items being sold (C<>B; D>0; F>0). The data in column C would be entered manually.

    Also it would be nice if at the same time the macro could copy entire column C and paste it into column B on sheet Stock (which would be hidden) so that the Items Left would represent new amounts of Items in stock. Anyway. this second feature is not of a top priority

    Thank you for your time, friends.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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