+ Reply to Thread
Results 1 to 3 of 3

How do I transfer specific rows & columns to another sheet if my Quantity in Column is >=1

  1. #1
    Registered User
    Join Date
    03-13-2017
    Location
    Tampa, Florida
    MS-Off Ver
    2016
    Posts
    2

    How do I transfer specific rows & columns to another sheet if my Quantity in Column is >=1

    Good evening.

    New member, so please forgive me for my ignorance.

    I am trying to find out how I can transfer particular columns (A, B, C, and F) and rows (varies) to another sheet if my Quantity is equal to or greater than 1 all while keeping my formulas intact on each sheet.

    Thank you in advance for any information or assistance you can provide me with.

    Respectfully,

    JJREIS
    Attached Files Attached Files
    Last edited by JJREIS; 03-13-2017 at 04:48 PM.

  2. #2
    Forum Expert
    Join Date
    05-20-2015
    Location
    Chicago, Illinois
    MS-Off Ver
    2016
    Posts
    2,103

    Re: How do I transfer specific rows & columns to another sheet if my Quantity in Column is

    Welcome to the board!

    Try the formula below in A2 of Sheet1. It should be array-entered (confirm with Ctrl + Shift + Enter instead of the regular Enter), then fill right and fill down:

    =IFERROR(INDEX(Quotation!$A$2:$F$60,SMALL(IF(Quotation!$A$2:$A$60>=1,ROW($A$2:$A$60)),ROW(1:1))-1,MATCH(A$1,Quotation!$A$1:$F$1,0)),"")

    It should automatically update as you change your quotation sheet.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-13-2017
    Location
    Tampa, Florida
    MS-Off Ver
    2016
    Posts
    2

    Re: How do I transfer specific rows & columns to another sheet if my Quantity in Column is

    CAntosh,

    Thank you!

    This worked perfectly!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using a Userform to transfer data to individual worksheets in specific columns and rows.
    By Ortz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2016, 07:00 PM
  2. Replies: 12
    Last Post: 09-29-2015, 08:00 AM
  3. [SOLVED] Copy rows with specific text in specific column into specific sheet
    By Valemaar in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-22-2014, 03:23 PM
  4. Replies: 0
    Last Post: 04-11-2013, 05:33 PM
  5. Replies: 1
    Last Post: 11-20-2012, 10:01 PM
  6. [SOLVED] Transfer Rows with specific color from Multiple Sheets onto one sheet
    By bukejr in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-19-2012, 09:49 AM
  7. Macro to search ID number in sheet 1 and transfer quantity into sheet 2
    By obgle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2012, 11:27 AM

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