mobile

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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