+ Reply to Thread
Results 1 to 6 of 6

Horizontal data to vertical in separate worksheets

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

    Horizontal data to vertical in separate worksheets

    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 Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    Hi, and welcome to the forum.

    Can you upload an example workbook with examples of before and after requirements. It's always easier if we can see the problem in its context.

    Rgds

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

    Horizontal data to vertical in separate worksheets of the same file

    I would want the data appearing horizontally in column C row 3 of the left tab to appear vertically in column A and starting with row 3 of the right tab. I would prefer a formula as opposed to copy, paste special , values, and also check off transpose. Is a formula possible that I could simply come down in the far right tab?
    Attached Files Attached Files

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    Hi,

    in A3 and copied down
    Please Login or Register  to view this content.
    To eliminate the 01/00/00 for blank cells, either use conditional formatting, testing for zero and set the font colour to white, or use the following formula

    Please Login or Register  to view this content.
    HTH

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

    Thanks Richard

    Good Morning Richard,

    Apologize for the tardy post to say thanks. This worked greated for all of my reports. Many thanks and keep up the great work in assisting many of us.

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    Hi,

    Thanks for the feedback. Only too glad to help.

    Regards,

    Richard

+ Reply to 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