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.)
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
=IF(ISERROR(VLOOKUP(Q3,BACKGROUND!J:M,4,FALSE)=TRUE),"",VLOOKUP(Q3,BACKGROUND!J:M,4,FALSE))
(Q3 is the cell that isn't there) it would just copy the number 205.
hope that makes some sense.
many thanks,
Z
Bookmarks