experience

Hi Is There anyone with experience of the software XLS Padlock (copy protect ). I am looking for a good way to copy protect my worksheet. Or is there any other software to use. Best regards Bengt

Hi everyone, I'm going to post a link to a question I asked in the Excel subreddit. I will also paste the original question here, but note that a discussion ensued which brought me here. Please read the comments to see where myself and u/gravy_boot managed to get to, before we got stuck. OP...

MP3 files have imbedded metadata that I would like to edit. I have between 35K and 40K files that I would like to edit one or two fields in each. I would also like to export to an Excel database a selection of fields: Title, Artist, Comment and so on. I can open each individual file in File...

Hi Guys, I am struggling to figure this one out. I have an excel workbook which I am running a Macro which takes the active page and attaches this to an e-mail. This is fine and works as it should however I then need to attach the same sheet as a PDF to the same e-mail. Is this even possible...

I'm sure there is a more efficient way to write this formula. I'm hoping my Excel Brain Hive and help. I've attempted to break it up in lines. =if (AND(M3="Low",N3="Low",O3="Entry/Lower Level"),"No Change",(AND(M3="Low",N3="Medium",O3="Entry/Lower Level"),"No...

Hey Team, <tbody> Experience V1 V2 Mobile No: Experience V3 v4 v5 Mobile No: Experience V6 Mobile No: Experience V7 v8 v9 Mobile No: </tbody> I want to delete Values between "Experience" to "Mobile:", ie v1, v2 , v3, v4 ....... Problem is , some has...

Hi Guys, I m new to VBA ode and created a tool where I have code linked to a active x control button that clears certain cells in my xslm workbook. The problem I am having is the tool is running slowly once the button is clicked. Private Sub CommandButton13_Click() If MsgBox("Do you want...

I need to learn Vlookup and Pivots in a hurry! Any recommendations would be greatly appreciated. I’m just a basic user of Excel with not much function experience. Please help!

Hi All, I've never been let down here, and today will be no exception. The Goal: I have a macro running that will Save a workbook, Save As a workbook with a unique file name in the same path, then roll through each worksheet to copy & paste values, and then roll through each worksheet to...

Hi all, I am doing work around assessing our staff skills and how competent/ confident they are for each skill. The information is broken down on individual worksheets for each location but I also want particular information to copy through to a master sheet. Is this possible? Below is how...

I am trying to extract a character + number combination then turn it into a date. For example: aa23 = 1/23/2001. The difficult part is my data is sometimes presented as 11aa23y or LYAA23. The key pattern is always 2 letters followed by 2 numbers. I need to extract that, then convert it using a...

This error is happening when I link Salesforce to Access, I had it working and now I keep getting this error -7711 which I looked it up and it is saying there is a data issue? Anyone have experience with this?

So I'm having a problem sorting data in a pivot table based on a "delta" formula outside pivot table; e.g. outside is % Delta, Inside pivot is all other data Dimension Question 2016 2017 % Delta My Work Experience 84.8% 87.3% 3% My Work Experience 86.0% 87.8%...

I am currently using, Office 2003, but I would imagine other versions do similar things. When I install Office, I choose to not be a part of the "Office Customer Experience Program" but then I still get the following icon in my Windows 7 Taskbar Notifcation Area.... Microsoft Office Word...

Hello, I have been developing an excel model that has become a bit slow in running certain calculations. This is a 10 tab model without anything too complex, and I was wondering if anyone with experience would be able to help me optimize this model so that is runs a bit quicker. I would be...