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

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Copying data that contains formulas and paste it a (excel 97)

    Author
    Topic
    #358502

    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

    Viewing 0 reply threads
    Author
    Replies
    • #535115

      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

      • #535117

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

        • #535164

          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?

          • #535168

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

    Viewing 0 reply threads
    Reply To: Copying data that contains formulas and paste it a (excel 97)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: