app

Is there an app or website to automatically search a formula and condense it if possible? I have a formula that when pasted into Google docs, takes up 14 pages. The formula runs about 75 times on my spreadsheet, and even though it functions as it should, changing a reference value makes for a...

I recently created an excel workbook that contains a user form that opens as soon as the app opens. This works fine on my desktop app but it appears to not be working when it opens in the excel online version. I basically have VBA code: Private Sub Workbook_Open() ufmTripSignup.Show End Sub...

HI we have some large rows of industry services and users. Basically the data is either 'Has Access' or 'No Access' and we pass this back and forth with the director as she decides and changes etc. I thought it may be helpful to have a colour a light yellow for each of the 'Has Access' since...

I have the following code to open an external app: ActiveWorkbook.FollowHyperlink Address:=("\\PublicI\\3.QGIS\MAPA.qgs"), NewWindow:=True What code can i use to close it? Thanks

Hi Mrexcel. I have several customised algorithms (>27) that relate with each other while others are stand-alone. My headache & heartache is how to code them as a Desktop App (as UDFs) because I need to use them nearly every 15 minutes. I would only need to import my variables to the App &...

Hi there, I’m hoping someone here can help with this. I have two sets of data that I want to match up. One set shows me when a person used an app: The other set shows me when the same people answered a survey (about the app): I need to know how to put these two sets of data together...

hello, New to excel VBA and could use some help. I am looking for a VBA to be able to use on a few different spreadsheets which will be automatically created from an android app that exports to a .csv file. After the csv file is created by the app, I need to be able to: A) clear all cells in...

Can anyone please assist me? The MS Excel app is constantly crashing upon updating my Google Pixel XL from Android Nougat to Android Oreo. Please help.

Hi guys, as may you aware there is an official Office app called ~. It's pretty amazing, and does exactly what i need. Before use of this i made some vba to done this. With that app you can export all the changes in 2 workbook but only the address of the cells. I would like to know is there any...

I have a chart that is populated, collecting data from each month of 2017 and I'd like to reuse this for 2018, but need to modify to cut down on the work. <tbody> App Month <tbody> Expected Uptime </tbody> Downtime Total Uptime x App1 Jan 737:15:00 10:00:00 727:15:00 x App2 Jan...

I'm completely clueless here! I do have some code to run the app from Excel and then user can use camera regularly, but how to save taken picture directly into Sheet? Sub RunCam() Dim SHRTCT As String Dim RNCMD As String SHRTCT = "C:\Users\Public\Desktop\yyyy.lnk" RNCMD = "RunDLL32.EXE...

Hi I would really appreciate some help. I have created a quiz in excel And have this set up as a webapp. It includes a leaderboard with name In column j and a score in column k.this leaderboard updates when Someone plays the quiz.so far so good. However the scores do not persist When the app is...

My first task at hand is to check whether or not Column’s E thru K is shaded "yellow" or not based on conditional formatting formula used [E2<>O2] =$E$2:$K$1206. So in separate column, I’m using Column AB2 as starting point to check if E (is yellow), AC2 if F (yellow) and so forth to identify...

...on 1/1/year of each year Sheet1 is blank, with only formulas in cols E& F. The app flies when opening it. Now - 09/28/17, Sheet1 has 890 rows of data from cols A:F. At this point in time, the app takes too long to finish loading. By EOY, I will have 1400 rows of data filled on Sheet1...

I have been having problems that once I add or remove cells on Workbook1, then I have to do the same thing on Workbook 2 and sometimes there are not only few cells added or removed. The problem is that I'm too lazy to do so cos there are so many look alike workbooks that i have to work on while...

Hi, does anyone have any knowledge of a decent add-in which can send values from an Excel workbook into an iOS app in real time? (I have Excel for iOS but it does not allow me to run another add-in that enables live feeds that I need) Many thanks

I would like convert a few of my excel models into a cloud based application so that multiple users can use the same models at different offices. These models store store data, update data points using a 3rd party add-in, and run a number of statistical formulas on the combination of data...

Help needed with this one please everyone.... Is there a way I can restrict cell access on the Android excel app? That's it! Thanks Pau

Hey all, I don't feel as this should be difficult, however I have had no experience in the app development field. I simply need to create a mobile app with a specific number of textboxes and when data is entered in them and a button is pressed, the data is transferred to a specific excel sheet...

Hello. I created a user form for data entry into excel which is then used to mail merge. I am in the mortgage and what started out 3 years ago as a simple mailmerge for a loan package has exploded into a huge 10 page detailed word document. I am reaching the end of the 250 column limit for...