app

  1. E

    Excel for iPad Pro

    I’m looking to do some conditional formatting on the excel app for iPad Pro as in being able to autocapitalize and change fill color based on what letter is typed in to given cells. Is that possible on the app for excel? Does that require an Office 365 subscription? Any help would be...
  2. P

    Automatically Shorten Long Formula?

    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...
  3. M

    User Form automatically appears when opening Excel Online version

    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...
  4. P

    Show one result in colour

    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...
  5. R

    close another application vba

    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
  6. P

    UDFs coding

    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 &...
  7. K

    Counting values based on dates across two datasets

    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...
  8. H

    VBA to clear cells below header containing word

    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...
  9. D

    MS Excel App Not Working on Android Oreo

    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.
  10. CsJHUN

    Compare Spreadsheets 2016 (Desktop app)

    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...
  11. M

    Only calculate if a cell has an X

    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...
  12. D

    Take photo from camera app on Windows 10 tablet directly into Excel?

    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...
  13. J

    Saving the current state of excel web app.

    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...
  14. D

    VBA Code for background color (yellow)

    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...
  15. C

    As rows on Sheet1 increase, loading the app slows down...

    ...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...
  16. C

    Create excel file template that could be updated automatically like an app while raw data unchanged?

    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...
  17. R

    Add-in to feed Excel values into an iOS app

    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
  18. E

    Moving an excel model to software

    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...
  19. H

    Excel Android App HELP!

    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
  20. R

    Mobile App linked to Excel?

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top