Results 1 to 4 of 4

User inputs number on sheet 1 and multiple cells (from sheet 2) are shown on sheet 3

Threaded View

  1. #1
    Registered User
    Join Date
    03-29-2014
    Location
    Alabama
    MS-Off Ver
    Excel 2010
    Posts
    19

    User inputs number on sheet 1 and multiple cells (from sheet 2) are shown on sheet 3

    I would like to enter a number on sheet 1 (A1) and have the data from sheet 2 displayed on sheet 3.

    For example. If I enter a 1 in cell A1 on sheet 1. I would like only cell A1 of sheet 2 appear on sheet three.

    If I enter a 2 on sheet 1 (A1) I would like cells A1 and A2 appear on sheet three (without the need for filling down).

    If I enter a 3 on sheet 1 (A1) I would like cells A1-A3 appear on sheet three without having to manually fill down on sheet 3....and so on.

    I have attached a spreadsheet as an example. I have no problem getting the first row to appear on sheet 3 using an IF statement but I'm not sure how to have multiple rows appear with multiple if statements and without having to fill down.

    Thanks.
    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. Replies: 2
    Last Post: 06-11-2014, 11:14 AM
  2. Replies: 5
    Last Post: 09-08-2013, 10:09 AM
  3. [SOLVED] Worksheet Activate when user selects sheet NOT when sheet is created from a template sheet
    By y0rk1e72 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-26-2012, 02:47 PM
  4. Replies: 3
    Last Post: 05-03-2012, 11:01 AM
  5. Cell Total shown Sheet to Sheet
    By macgilgamesh in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 10-08-2005, 10:06 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