mobile

  1. Y

    Formula to make list shorter

    Hi guys, I was wondering if somebody could help me with the following. I have three columns, if somebody dials 93xxxxxxxx numbers the rate wil be charged 0.1575, and if someone dials 9320xxxxx the rate will also be charged0.1575. In this case i want to delete the row with the prefix 9320...
  2. S

    Turn a workbook with macros/vba coding into a mobile app

    Hi All, Could anyone please point me in the right direction as to how to change a workbook I have into a mobile app. The workbook has 14 worksheets within it and loads of vba. I have it on OneDrive at the moment as their are numerous users all at the same time. I wish to make this more user...
  3. H

    Excel file opening in sheets mobile not updating

    Ok I found the solution I'm just posting hoping that if someone else has the same problem they find this. I have an excel file that I use on my mobile (which opens it in sheets) that was refusing to update to the new version. I had verified that the updated version synced to g.drive from my...
  4. K

    Button Selection

    Hi all. I have a user form with two buttons for a selection by the user. It is either the one or the other. You can not select both. If you select Mobile then the word "Mobile" is to be in cell M1. If you select In Shop then the text "In Shop" is to appear in cell M1. If no button is selected...
  5. W

    Checking long string for list of keywords and extracting only the keyword if exists

    Hi Team Can anyone help me please? I have a long string in column A. What I am trying to do is check for a list of words (need wildcards) (the word or words will only appear (if at all) once) and if the word(s) exists, copy that word to a separate column, say B. So check for say, "book"...
  6. M

    Delete a specific text in Raw Data

    I have a set of raw data I export everyday. When I export the data, all the raw data is on 1 column. I have a row that says "2 tickets" and need to delete the "ticket" and "tickets" text before I can add to my access database. I only want the numbers to be intact. I do not care of the...
  7. D

    VBA: Filter before union

    Hi, I am creating a union for later use (export to CSV). Is there a way to filter the columns before the union WITHOUT copying and pasting to a new sheet. So... With sh.ListObjects("MasterData") Set rngToSave = Application.Union(.ListColumns("FATHER'S MOBILE").DataBodyRange, _...
  8. X

    Spreadsheetconverter for mobile view

    Hallo, gerne in deutsch, ich kann aber auch in Englisch schreiben. Ich suche die Möglichkeit, mit Excel über Web mit Scrollbalken zu erstellen. Leider finde ich hier keine Möglichkeit zu. Die Webseite wird auch immer viel zu groß dargestellt. Das Ganze soll als mobile Version angezeigt werden...
  9. C

    Show cell value based upon data contained in column below

    Hey all, I'm trying to work out the best formula to use for the below requirements. I have my sheet below, I'm looking to show the top field (row 1), if there is any amount within the corresponding columns below, into a new column. What formula am I best working with? This could extend to 20+...
  10. S

    Need help on Power Pivot Measures

    Hello Every one, I have created a power pivot report based on the following tables Table No.1 <colgroup><col><col></colgroup><tbody> Product Name Group Laptop Electronic Television Electronic Washing Machines Electronic Refrigerator Electronic Mobile Phones Electronic Table...
  11. F

    Delete Rows Between two Columns

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

    Transpose row to column but with different issue

    Hey Forum, <tbody> Name1 Email1 Mobile1 Name 2 Mobile 2 Name 3 Email 3 Mobile 3 Mobile3 </tbody> The above data has 3 as well as 2 values i need to transpose Name Mobile Email where some email has no data(blank column) Some has duplicate Mobile number like in above...
  13. A

    Pivot tbl. calculated field - sum of two "regular" fields but only if Field1 matches certain value?

    Hi all, I have a pretty simple problem - I wish to create a calculated field in my pivot table. This calculated field needs to SUM two fields, that already exist in the data source, but with a little twist. Here is an example which will make this much more clear. Source data: <tbody> Market...
  14. G

    Indirect (Substitute) - limit on references?

    Hello all. I am using the formula =INDIRECT(SUBSTITUTE($B$10, " ", "_")) to pull a list of advisors based on the manager name that appears in a dropdown cell(B10). The list is on a separate sheet in the same workbook. The manager names are listed horizontally and the advisors under them are...
  15. M

    VBA to select first item in a pivot filter then save copy as

    i have a mobile usage table and i created a pivot table with a mobile number filter on the top to show the usage for each mobile number, what i am trying to do is to create a macro to start from the first number in the filter then save copy as in a folder with a cell reference in the same sheet...
  16. R

    Code generation formula

    <tbody> S NO CODE NUMBER MOBILE NUMBER REFERING NUMBER 1 6375871156 2 3 </tbody> Hi good morning, I need your help for making the above chart as smart. I am giving a offer to my customers, who are purchasing mobile phones in our shop. I want to give a unique offer code...
  17. R

    longest prefix match

    Needs help in order to match longest prefix, As an example I have an excel which contains prefix list like below; Column A contains regions and Column B contains prefix. Destination Prefix Afghanistan 93 Afghanistan - Mobile - Afghan Telecom 9375 Afghanistan - Mobile - Awcc 9370 Afghanistan...
  18. C

    Export Specific Fields from Outlook 2016 to Excel 2016

    Hi, I have tried several scripts (and modified them) but I seem to be missing something. I would like to export, from a specified folder in Outlook, specific body items. This is from the body: SM Form 2018-05-11 11:19 AM was submitted by Guest on 5/11/2018 11:19:03 AM (GMT-05:00) US/Eastern...
  19. L

    Splitting phone numbers out into different cells

    Hello! Bit of advice needed as I'm running out of hair to pull! I have a column which contains a landline number, a mobile number, or in some cases both. I need to strip these out into separate columns. The common identifier for each example is the word at the start of the cell. If the cell...
  20. G

    dlookup

    Hi . I have 2 tables , mobile number is the relation shipped data one to many. first table has client data name, surname etc second table has mobile number and visit details i have a form for 2nd table and i put 2 labels . I need when i put the mobile number (afterupdate vba) first label caption...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top