+ Reply to Thread
Results 1 to 2 of 2

Copy data over based on reference and named range

  1. #1
    Registered User
    Join Date
    03-01-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    49

    Copy data over based on reference and named range

    Good Day Experts,

    I got a very technical sheet which needs your experience to work.

    Please open the attached file below to see the workbook.

    It has 3 different sheets. "RESULT", "INPUT" and "SWITCH"

    On "RESULT" Cell (O11) is where the person would put a Reference.

    This reference is then checked on the "INPUT" sheet column A.

    From the first cell it appears in Column A, until the last cell it appears in Column A should be the Row Range (Blanks included).

    But I want that range (Column A to G) to be copied to "Switch" sheet. Pasted in Cell A1 downwards.

    In the "SWITCH" sheet I have already given all the GREEN Cell formated areas a name - INFO.

    I want all the data in INFO to be inserted into "RESULT" sheet between row 18 and 19.

    I have colour coded most of the areas for you.. And added a button from which the Macro / VBA should run when clicked.

    I really hope you can help.. The solution has eluded me for more than a month...

    Thanks again.

    JEDEMEYER1
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    03-01-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    49

    Re: Copy data over based on reference and named range

    Any takers? It can't be that difficult can it?

+ 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. How to sort a named range based on a cell reference
    By numbanine9 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-12-2013, 12:15 PM
  2. Data Validation: Cell reference to Named Range
    By niceguy21 in forum Excel General
    Replies: 2
    Last Post: 11-07-2012, 10:41 AM
  3. Change data in Named Range using Cell for reference
    By iroc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-02-2011, 07:40 AM
  4. Finding a named range based on cell value and copy/paste to same sheet?
    By Simon Lloyd in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-11-2006, 06:25 PM
  5. Replies: 1
    Last Post: 03-21-2006, 06:40 PM

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