Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: Transpose Links from individual sheets to master sheet

  1. #11
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    as soon as I hit "post" I thought of something

    we can still achieve what you want with "randomly"-named sheet tabs....

    it will just mean a spare column somewhere.

    Give me a shout, with the names of your sheets you decided on (or expect to have)

    [they don't need to have those 1,2,3s in them, although if they do, that would be fab]



    _________________
    Hope this helps,
    Chris



    edit.... it'll still work when the sheet names are changed in 3 weeks time too..

    [ This Message was edited by: Chris Davison on 2002-04-24 12:46 ]

  2. #12
    Board Regular
    Join Date
    Apr 2002
    Location
    Wivenhoe, England
    Posts
    912
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for trying Chris. Can anyone else help?

  3. #13
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


  4. #14
    Board Regular
    Join Date
    Apr 2002
    Location
    Wivenhoe, England
    Posts
    912
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks Chris but I need to be able to rename sheets. Can anyone help with some VBA? Cheers.

  5. #15
    New Member
    Join Date
    Dec 2008
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Transpose Links from individual sheets to master sheet

    Dear Inabeth,

    check out

    http://exceltip.com/st/Copying_Formu...ences/127.html

    It basically says that you have to know the 1Row1column cell and the lastRowLastColumn cell and the number of rows and columns.

    You highlight the opposite, so if your original data is 3columnsx2rows, you need to highlight the area you want to put the information with 2columnsx3rows. Then click "=" sign and type TRANSPOSE, hit CTRL-A, enter the 1strow1stcolumn:lastrowlastcolumn, then hit CTRL-SHIFT-ENTER.

    AND THAT'S IT!!!

  6. #16
    Board Regular
    Join Date
    Apr 2002
    Location
    Wivenhoe, England
    Posts
    912
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Transpose Links from individual sheets to master sheet

    Cripes, six and a half years have passed since my last post on this. Have forgotten why are asked this Q but I'll have a look at the link.
    Thanks

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •