Office Software Forum
- Excel (9,871)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
Recalculation of dates Solved/Closed
Hello, Hello, I'm trying to write a formula that will recalculate a date based on a fixed number of days. For example I have 2/1/19 in cell A42...
-
Sliding conditional formatting Closed
Hi everyone, I am currently stuck in Excel with the conditional formatting. I would like to apply a color to a cell in column A, row 1 based on a for...
-
IF function in Excel refrencing data from another cell Closed
I have a column which has names (these change on a daily basis). I have dates in another cell and I want a formula that says a3="IF the date in cell ...
-
Excel formula for copying data from one sheet to another Closed
Hello, I have 10 columns and 142 rows of name of person and their details, Is it possible when I edit data from the first sheet, it will automaticall...
-
How to create custom colors in PowerPoint Closed
Does anyone know how to create an additional colour pallet in PowerPoint? One of my clients has given me a template to modify and I've noticed that wh...
-
Send to via Access 2016 "wrong password" Solved/Closed
I have a customer using Access 2016 with a custom database written by someone else. They were using IMAP but are now on 365. Since this move whe...
-
Office 2007 installation stops Closed
Hello, I downloaded office suite package 2007 and I'm trying to install it but the installation stops and it's writing "it is not affected by an...
-
Mask cells in Excel Closed
Hello, I created a calendar / schedule under Excel with one month per sheet. Depending on the month. So for the month of February, for example, ...
-
AcroRd32.exe - No Disk Closed
AcroRd32.exe - No Disk "There is no disk in the drive. Please insert a disk into drive F:" Not sure what this means. Can't close message without r...
-
Autofill number from Column B based upon text in Column A Closed
Hello Is there a way to get excel to autofill a number on sheet 1 that comes from the column "B" on sheet 2; if the text in column "A" matches? ...
-
Microsoft download Closed
Hello, I need a link to download Microsoft office 2010. exe
-
Find and replace in Excel Closed
Hi, This question is related to Excel 365. I have Sheet1 that has two columns. I Just gave a sample of word abbreviations. It has around 800. ...
-
Conditional Formatting Columns Closed
Hello, I would like to know if there is a way to conditionally format a column. I want cells in column C to highlight if they are higher than the ...
-
Customising slides identity (Software) Closed
Hello, The company I work for is going through a merger and all of our presentation are going to be merged. I am aware of the edit master slide...
-
If function with printing tool Closed
I have 3 column " Nu, Item, QTY" I want to print the cell who has a qty with the same Nu sort. nu item qty 1 ...
-
Explanation of formula used on conditional formatting Solved/Closed
Hi, Could someone please be able to fully explain how the following formula works with regards to conditional formatting? =AND(start_of_range""...
-
Populate separate worksheets with data from main worksheet based on criteria met Solved/Closed
Hello, I'm making an accounting workbook and I've run into a problem. On the first sheet "Sales Log" I input all of the transactions that the...
-
Incorrect date while saving csv format Closed
Hello, I am trying to save a csv format of an excel sheet. My sheet has dates from 1 Dec'18 to 31 Jan'19. But when I save the csv file and reopens...
-
Picking data from a table Closed
Hello, I am going to apologise once again in advance as I am terrible at coming up with the right question when it comes to excel formulas hence why I...
-
Excel IF formula - Priority setting Closed
Good day I have this formula below but need to add another function to it. I have five cell (let say B,C,D,E,F) each with a selection option indica...
-
VBA comparing two files via rows and copy difference to third file Closed
Hello everyone! I'm new to VBA and need your help! I need two compare two files (File 1 and File 2). I need to compare rows in File 2 to rows in Fil...
-
Copy-paste some grid in excel Closed
Hi All I know this topic is quite old by now but. Haven't found the solution yet. I tried to copy-paste some grid in excell when i noticed. It wasn'...
-
Paste value on filtered cells Solved/Closed
Hello, i was trying to "pasted value" on a filtered cell. but it seems to be pasting it to all cells... im using a "=concatenate" on several cell...
-
Regarding all fields by selecting individual ID Closed
Hello, I have a JSON file it contains 100 IDs and all their details, but when I type ID I need to get entire details of that person from JSON file...
-
Office Enterprise 2007 setup cannot find Word.en-us\WordLR.cab Closed
Hello, here's is my problem. On setup, it says that setup cannot find Word.en-us\WordLR.cab. Please help. System Configuration: Windows / Chr...
-
Excel Cell Color change from another cell date fill up. Closed
For Example, 1 item due date is 10/Nov/18 & showing yellow color. when the next cell will in-house 9/Nov 18 than the previous date color will move fr...
-
Compare Excel sheets using Python Closed
Hello, Can you please solve this question.To compare two excel sheets and copy unlike data to a third sheet which is not deduplicated.Can you plea...
-
A combination of SUMPRODCUT/ISNUMBER with LOOKUP Closed
Hello all, hoping someone can help CELL (A) I have a question where, I have a column of data where there is a missmatch of data. CELL (B) I ha...
-
Background formatting from two values drawn from formulas Closed
Hi. I've created a table displaying prices from suppliers. On the end two columns I've added a formula to show the header of the colomn which holds t...
-
Duplicate line and decrease Id number Closed
Hi Does anybody know how I can repeat rows in a spreadsheet (or into another spreadsheet) by n number of times specified in the cell in that row w...
-
Conditional Formatting using dates/data in an adjacent cell Closed
Hello, I am creating a project status sheet where dates entered in an empty column (Column C) that are past the "planned start date" (column B, hol...
-
Copy and paste one cell into 48 and then repeat Closed
Hello, I've tried to piece together how to do this function and I feel like it's simple but I need help please! Here's the recording for 2 times. I...
-
Convert numbers to words Closed
Hello, I want to covert a number 276120 as Two Lacs Seventy Six Thousand One Hundred Twenty but Using above code i can convert the number as Two Hun...
-
Watermarks and Section Breaks Closed
Hello, I am trying to create a digital letterhead that has the ability to have multiple pages, but the watermark only on page 1. When additional p...
-
Inserting pictures from folder using macro Closed
Hello, I would appreciate if someone would help me. I never used macro until today and I searched for a solution but I just don't understand. Th...
-
Comparing two columns using partial match logic Solved/Closed
I need a bit of help please. I have 2 columns of data that I am doing a partial match compare (first 15 positions) using a formula in column AA. ...
-
Automaticly change currency format in cell Closed
Hello, I am an estimator in a company that does installation worldwide. We are quoting in many different currencies, and now have to manually make...
-
Copy & paste issue Closed
word properly copying, however pasting while word into incomplete being. (not entire text). just some letters receiving. some places no, word into pa...
-
How can I restore images that saved on Word File? Closed
Hello! Is there any way via which I can restore some images that I have saved on Word 2013? I have already used some manual methods Like Open and R...
-
Generate simplified data from RAW data Closed
Hello guys, i need help to create some magic from excel. I am a marketer for a F&B, and right now i am in the mid of trying to generate some preci...
-
Price of MS Office Word Closed
Hello, What is the price of the microsoft word 2013 after the initial 1-month trial?
-
Copy rows to rows on another worksheet if " ✔ " Solved/Closed
Hi everyone, Ultimate greenhorn here. I have just recently discovered the " Conditional Formatting " as well as VBA function on excel a week ago and...
-
Auto populate weekday from a separate date entry Closed
Hello, I am wanting to do two things: 1. In the first column I want to add in the date, in the second column I want it to automatically insert ...
-
VBA command button Solved/Closed
Hi Everyone, I need help creating the following: I want to create a CommandButton that when clicked it will check column "CB" for "YES" and will...
-
VBA - Button saves TextBox data in dif. Workbook Closed
Hi Everyone, I need some help creating a code that will allow me to save data input into a TextBox to a different Workbook called "FoundData.xlsm"...
-
Count total quantity by date into month Solved/Closed
Hello, Good Day~ Kindly help to correct the formula for below, I had wrote a formula that to calculate the quantity by month to the order date ...
-
How to use conditional formatting 30 day notice Closed
I have an excel document that I have set up some conditional formatting and use of icon sets. The only issue I am having, is programming the 30 day a...
-
Not implemented error message in Outlook 2013 Closed
Hello, When I try to send an Email to my client suddenly an error message display: “Not Implemented Error Message in Outlook 2013”. There is issue...
-
Lookup or match Closed
Hi, I have a column in which I have a value I need to look up, then in same column anther value I need to find then return value in column that has an...
-
Copying specific cells Closed
Hello, I am trying to use a command button to copy information from specific cells in sheet 1 to a excel form I made in sheet 2. The cells are not...
