+ Reply to Thread
Results 1 to 1 of 1

Copy cells from sheet to sheet as text.

  1. #1
    Registered User
    Join Date
    Bristol, UK
    MS-Off Ver
    Excel 2003

    Copy cells from sheet to sheet as text.

    Hi all,

    I have a workbook made up of 2 main sheets. The user fills in a userform and it saves the data to the sheet "DATABASE". No users are allowed to edit the data on this sheet and it is password protected so they can't even see it. Instead I have a "VIEWER" sheet which is a copy of "DATABASE" except without some of the columns. What I've just realised though is that the way I have written it the forumlas are copied across but for them to work one of the columns is missing. Is there a way that I can make it copy the numbers not the forumulas in the cells?

    This is the code I have used:

    (ViewAllBookings is the button on the main menu sheet.)

    Please Login or Register  to view this content.
    I was thinking that the best way would be to add a line specifiying that the copy is done as text so instead of copying: the following into column G
    (Q3 is the cell that isn't there) it would just copy the number 205.

    hope that makes some sense.

    many thanks,
    Last edited by zebra; 09-18-2009 at 08:06 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread


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