I deleted merged cells - and all rows dissappeared - help!
I now only have row 2 and 3 (the headlines), and the area below is just grey (now row-numbering or anything, just grey void..) - how to get back the main part of my sheet? As far as I know, I havent hidden or deleted the rows, but they dissappeared when I tried to delete five columns with a shared merged cell on top of above them. Thankful for help!
Preventing document to be saved by other users?
I have created a daily "pass on" for supervisors to fill out per their request. This is a macro enabled document automated with buttons. The supervisors are not very tech savvy and continue to "file-save" document overwriting my original (I do have a backup but I really don't want to continuously reload the backup for every supervisor's shift, 3 shifts per day 7 days a week). I have a save as command in one of the VBA buttons, it is not necessary for the supervisors to save over my master copy. This is located on a network drive and they all have access to it. Is it possible for me to restrict the supervisors access on the document to save. If they do a 'save as' I cannot prevent that but I am just wanting to eliminate them from 'File-Save'. They don't all seem to understand when I stress just to press the macro buttons, but they want it automated so the buttons must stay. They 'file-save' then press the macro buttons...facepalm. Is there another way to go about this other than restricting access? Maybe a VBA to lock the document from 'file-save' without being a read only copy since the VBA buttons don't work with a read only version of the document. Below is the document. Advice is welcomed.
Help with if function to deleted characters if met criteria
Hi guys, I'm working with a data set where have a lot of website links. The thing is that most of the links are personalized. For example https://this/testing?wvideo=9gpspqefxd What I need is to delete all the characters after the question mark (?) so that I would look like this: https://this/testing I've already figured out the function to delete that which is =LEFT(A1,FIND("?",A1)-1). However, in the list, of websites, there are also links that don't have the question mark (?), therefore, when I apply the formula to all cells, the ones that don't have the (?) show me as #VALUE! I thought of using an IF function but I've been struggling to make it work. This is the formula: =IF(M2="?","(LEFT(M2,FIND("?",M2)-1))","M2") It is supposed to find in A1 the character (?), and after the condition is met, it should do the rest but doesn't work. I appreciate it if you can help me. Thank you!
