Results 1 to 7 of 7

to take info from sheet1 to sheet2 from horizontal to vertical.

Threaded View

  1. 11-02-2015, 12:48 PM #5
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    30,687

    Re: to take info from sheet1 to sheet2 from horizontal to vertical.

    Why do you have to change the formula: you only enter a new S/N

    =VLOOKUP($B$2,sheet1!$A$3:$AA$1000,ROWS($A$1:A2)

    will handle 1000 rows in Sheet1. Change 1000 to whatever you need.
    Last edited by JohnTopley; 11-02-2015 at 05:54 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how do i fill vertical colums with info from horizontal info
    By dmccue in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-26-2014, 04:45 PM
  2. [SOLVED] copy data from sheet1 to sheet2 based on column (A) sheet1 and column (C) sheet2
    By AWITCHER in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-13-2014, 03:20 PM
  3. [SOLVED] Add or remove info to two lists in Sheet1 and Sheet2 and difference between two lists
    By alipezu in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-01-2014, 12:28 AM
  4. match data of sheet1 and Sheet2 ColumnA, if matched copy columnB of sheet1 to sheet2
    By annielle_09 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  5. Info input by hand on sheet1 to sheet2 automatically
    By loled in forum Excel General
    Replies: 9
    Last Post: 07-03-2013, 09:04 AM
  6. transfering info from sheet1 to sheet2 and have them lined up nicely..
    By loled in forum Excel General
    Replies: 2
    Last Post: 07-01-2013, 08:30 AM
  7. sheet1 info on sheet2, totaled by weeks, by customer, by site id
    By chestersneakers7 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-16-2013, 01:42 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1