I have a spreadsheet that depends on two cells and produces a ratio but it only produces an exact ratio but I need it to be a rough ratio. Example: Cell Q31=500 cell S31=1482 The result = 1482:500 in cell ...

I have used =INT(B5-A5)&” Days “&HOUR;(MOD(B5-A5,1))&” Hour “&MINUTE;(MOD(B5-A5,1))&” Minutes” to find the days, hours and minutes between 2 dates. Now I need to find the average of all the days, hours and minutes. I’m having a hard time coming up ...

HI i have more than 10,000 customer uk phone numbers in one excel sheet column A. spent no. of hours to create database from bills and phone lists. i need only mobile phone numbers. Example numbers starting with: 07 are mobile ...

I have a spreadsheet with 10 worksheets on it, 1 for each supplier with the same standard layout on each: Column A: Product Code Column B: Product Name Column C: Cost Price Column D: Sales Prices I use these individual spreadsheets ...

I have a Word doc with numerous links to an excel sheet. Although all settings are checked to auto-update links on the Word doc when it loads, and the popup even comes on the screen upon load of the Word ...

I have a Word 2010 document that contains several symbols (greater-than-or-equal to, less-than-or-equal-to, etc) that I’ve inserted using the Symbols menu/dialog box. They look fine on screen and in the PDF version, but when I print the document, all the ...

BRENDAN June 24, 2017 at 19:04:45 I have this macro to clear data from cells so the sheet can be reused these are all unprotected with no formulas in them Worksheets(“good one protected”).Unprotect Password:= Range(“C5:O11”).Select Selection.ClearContents Range(“F16:H20”).Select Selection.ClearContents Range(“K18:L20”).Select Selection.ClearContents

Hi, I had a VB script in Excel 2010 working but for some reason it has become curropt and i’m getting the run-time 13 error message. I have pasted the script below. Please can you help? Option Explicit Private Sub Workbook_Open() Dim objExcel Dim objWorkbook

is there a simple way to automatically sort without using macros

I created a multi-page form in MS Word 2010. I then drafted a short macro that inserts the date and time into the form and then moves the cursor to the first open field. I want to put a shortcut ...