Closed Thread
Results 1 to 2 of 2

Help with creating formula (data going from horizontal to vertical)

  1. #1
    Registered User
    Join Date
    07-29-2008
    Location
    united states
    Posts
    12

    Help with creating formula (data going from horizontal to vertical)

    Good Morning All,

    I am working with 2 worksheets. Worksheet 1 is named 08 billings and worksheet 2 is named 08 $ X Job. Worksheet 2 needs to reference various cell values from worksheet 1. I would prefer to use a formula as opposed to paste special, select values, and check the transpose box. Here is my scenario:

    Worksheet 1 has data in row 55 starting with column C and ending with column AZ. I am trying to move the data in row 55 from worksheet 1 into a column A of worksheet 2. I have several instances where I will use a different row but remain selecting columns C - AZ in worksheet 1. The data is appearing horizontal in worksheet 1, and my goal is to get it to appear vertical in worksheet 2. Any assistance would be greatly appreciated.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    Hi Friedric,
    I am closing this thread as it is a duplicate of this thread.
    Please check on forum rules again
    Cheers

Closed Thread

Thread Information

Users Browsing this Thread

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

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