pasting, memory loss
Eliminate Pivot Table Annoyances
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: pasting, memory loss

  1. #1
    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

     
    Aladin,

    how do I get this back into excel ?

    {"top left",1,2,3,4,5,6,7,8,"top right";1,2,3,4,5,6,7,8,9,10;2,3,4,5,6,7,8,9,10,11;3,4,5,6,7,8,9,10,11,12;4,5,6,7,8,9,10,11,12,13;5,6,7,8,9,10,11,12,13,14;6,7, 8,9,10,11,12,13,14,15;7,8,9,10,11,12,13,14,15,16;8,9,10,11,12,13,14,15,16,17;9,10,11,12,13,14,15,16,17,18;10,11,12,13,14 ,15,16,17,18,19;11,12,13,14,15,16,17,18,19,20;12,13,14,15,16,17,18,19,20,21;13,14,15,16,17,18,19,20,21,22;"bottom left",15,16,17,18,19,20,21,22,"bottom right"}

    thanks
    Chris

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,797
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    Chris,

    Copy it, activate a cell (in a sufficiently large, unused range), go to the formula bar, type =, paste it, and enter.

    Go to cell where all this is, select a big enough range, hit control+shift+enter. Copy the selection and do Edit|Paste Special >Values. Clear the cells that contain errors.

    Aladin

    On 2002-03-09 06:05, Chris Davison wrote:
    Aladin,

    how do I get this back into excel ?

    {"top left",1,2,3,4,5,6,7,8,"top right";1,2,3,4,5,6,7,8,9,10;2,3,4,5,6,7,8,9,10,11;3,4,5,6,7,8,9,10,11,12;4,5,6,7,8,9,10,11,12,13;5,6,7,8,9,10,11,12,13,14;6,7, 8,9,10,11,12,13,14,15;7,8,9,10,11,12,13,14,15,16;8,9,10,11,12,13,14,15,16,17;9,10,11,12,13,14,15,16,17,18;10,11,12,13,14 ,15,16,17,18,19;11,12,13,14,15,16,17,18,19,20;12,13,14,15,16,17,18,19,20,21;13,14,15,16,17,18,19,20,21,22;"bottom left",15,16,17,18,19,20,21,22,"bottom right"}

    thanks
    Chris
    [img]/board/images/smiles/icon_smile.gif[/img]

  3. #3
    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

      
    got it

    thanks Aladin, much appreciated


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
  •  

 

 
DMCA.com