+ Reply to Thread
Results 1 to 6 of 6

Two views of the same information

  1. #1
    Registered User
    Join Date
    03-30-2005
    Posts
    13

    Two views of the same information

    i have a table in excel that has the headers in column A, and each subsequent column is another record. (unfortunatly, the person who created and uses this sheet wants it set up like that.)

    i need to use this spreadsheet as the data source for a mail merge. what i did was paste special into a new sheet with the transpose option checked.

    is there a way for me to set up soem formula so that when new information is entered/edited in the first sheet, the second one updates as well? i tried using the = function, but that is not fillable across the sheet. any suggestions?

  2. #2
    Forum Contributor
    Join Date
    06-21-2004
    Posts
    106
    Quote Originally Posted by SirSFZ
    i have a table in excel that has the headers in column A, and each subsequent column is another record. (unfortunatly, the person who created and uses this sheet wants it set up like that.)

    i need to use this spreadsheet as the data source for a mail merge. what i did was paste special into a new sheet with the transpose option checked.

    is there a way for me to set up soem formula so that when new information is entered/edited in the first sheet, the second one updates as well? i tried using the = function, but that is not fillable across the sheet. any suggestions?
    Yes, the formulas will not fill across like it will for down. Try this: use the transpose function = TRANSPOSE(<arrary>) and copy/fill the worksheet with what you need. You will not get you answer quite yet, though. Highlight the entire section of formulas, go into the formula bar, and press control+enter+shift; this will make it an array. I believe the help menu has an example you can play with. Good luck.
    I hope this works, and I hope you can convince your manager to change the format. Columns have a limit of 256 and that isn't much when storing data.

  3. #3
    Registered User
    Join Date
    03-30-2005
    Posts
    13
    i hate to be a pain, but apparently the Help function on the computers in my company is disabled!?!?! could you walk me through this? i'm having trouble getting it to transpose, and creating the array.

    let's call the sheet with the information Sheet1 and the new, transposed one Sheet2.

    Thank you so much for your help.

  4. #4
    Forum Contributor
    Join Date
    06-21-2004
    Posts
    106
    http://office.microsoft.com/en-us/as...093191033.aspx

    Here is a link to the help file that you are looking for.

    I just learned what an array formula does. If you dont' know it...I would recommend skimming it; it is very helpful.

    If you are still confused....you can send me your file to via private message.

  5. #5
    Forum Contributor
    Join Date
    06-21-2004
    Posts
    106
    Pls check your private message and shoot me an email. I have created a simple excel tutorial for you that may help.

  6. #6
    Registered User
    Join Date
    03-30-2005
    Posts
    13
    e-mail sent...

    much thanx.

+ 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