Results 1 to 6 of 6
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Copying specific account numers and values

    I have account numbers and values in Cols A & B respectively on sheet Data

    I would like to extract all the account numbers one row above 125915 and its value in Col B to Sheet "Input Vat" and all account numbers one row above 125925 and its value in Col B to sheet "Output Vat"

    I need VBA code to do this. There is +- 40000 rows of data each month, where I need to extract this data
    Attached Files Attached Files
    Last edited by HowardC; 2014-09-07 at 11:56.

  2. #2
    3 Star Lounger Supershoe's Avatar
    Join Date
    Apr 2014
    Location
    Austin, TX
    Posts
    252
    Thanks
    1
    Thanked 36 Times in 34 Posts
    Based on your example you should have said "BETWEEN" and you did not mention your excel version nor did you say that you do/do not need to preserve the original data.
    In any case use a macro with application.match to find the rows and then copy to the top/next available ??? row on the destination sheet.

    PLEASE BE VERY CLEAR WITH EXPLANATIONS. Your examples are good.

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Thanks for the help. Will be careful with explanations

  4. #4
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Formula to add Data

    I would like to set up a formula to give add the totals in Col J, for the following categories

    Expense Input
    Internal Internal
    Output Sales


    See Sample Data attached
    Attached Files Attached Files

  5. #5
    3 Star Lounger Supershoe's Avatar
    Join Date
    Apr 2014
    Location
    Austin, TX
    Posts
    252
    Thanks
    1
    Thanked 36 Times in 34 Posts
    You should NOT ask a different question in the tread of the 1st question. Anyway, I have attached a file for your question about copying data from one sheet to 2 based on criteria. It uses findnext.

    Look for sumproduct or sumif for your second question.
    Attached Files Attached Files

  6. #6
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Thanks for the help , much appreciated

Posting Permissions

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