Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Copying data that contains formulas and paste it a (excel 97)

    Hello again,


    What I'm trying to do is very simple..I want to copy data from
    1 sheet to another sheet1..lets say..I want to copy data from
    Sheet1 and paste it in Sheet2..The problem is some of the data
    contain formulas..Is there any chance when I paste it, it will show
    as text..thanks
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Copying data that contains formulas and paste it a (excel 97)

    Copy the data as usual. Paste the data using the menus edit>paste special... (or right click in the cell and choose paste special...), and in the dialog box click the values option.

    Tony

  3. #3
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying data that contains formulas and paste it a (excel 97)

    Thanks Tony..You are awesome..regards.it works like a charm

  4. #4
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Copying data that contains formulas and paste it a (excel 97)

    Have you considered linking to the data in the first sheet, so that if your numbers change on the first the second would automatically be updated?

  5. #5
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Copying data that contains formulas and paste it a (excel 97)

    Thanks for the ideas..but I've already thought
    of it.Its not suit for my task.regards

Posting Permissions

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