Office Software Forum
- Excel (9,871)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
office 365 product key Solved/Closed
Hello, Hello. How to activate Office 365 product key. I couldn't do it :)
-
Find text in multiple cells and return different text Closed
Hello, I am a teacher trying to find an alternative to manually entering data for single children and a way of simply analysing it. I have created a...
-
prn convert to pdf Closed
Hello, how is convert prn format file System Configuration: Windows / Chrome 60.0.3112.113
-
How to convert the Tamil Word doc to Tamil PDF?
Hello, How to convert the Tamil Word doc to Tamil PDF? Regards Jebasingh
-
Apply Conditional Formatting Across Several Cells Solved/Closed
Hello, I want to change the color of a row if there is text in column A of that row. I have the following equation: "=AND(ISTEXT($A$2))" ... and I h...
-
Formula for Outputting Value from Dropdown List Closed
Hello, I need assistance with finding a way to output the value of cell based on the text it's associated with in a drop down list. Below is a scre...
-
How to add Rows automatically based on Cell Value In Excel? Solved/Closed
Hi All, I have a requirement to add the Rows Based On Cell Value In Excel. Below I have attached the snapshot of the requirement details. I have two...
-
Generate app Password Closed
Hello, I am trying to generate an app password for Outlook Desktop but I keep getting the message: "Sorry, this feature is not available at pres...
-
populate values in textbox based on combobox ,optionbutton Solved/Closed
Hello, I have the items in column B in sheet1,2,3 and the prices in columns F,G for sheet1,2 and the prices for columns F for sh...
-
Running a macro in different cells Solved/Closed
Hello, I have a question. I recorded a macro to average a series of columns, highlight the averages row in a bold color. I would now like to run the ...
-
Computer crashed...I can't retieve microsoft to new computer Closed
The only info I received was my invoice when I purchased it. But I cannot retrieve it. Please help
-
How to extract text from column that got text Closed
Hello, I would like help on how to extract text from column which has text. Some column might not have text or blank, want to know how to extract th...
-
how to convert excel to pdf in tamil font Closed
Hello, how to convert excel to pdf in Tamil font
-
How to Speedup Formula processing Closed
I have been using this formula which macthes the List of Cells to Raw String and if match found then write same value. This function is working fin...
-
Absolute reference from another sheet is not working Closed
I have my First Sheet as an Index sheet with titles of topics and another neath each title i have my latest update which is pulled from another sheet ...
-
Generating invoice number automatic without repetition Solved/Closed
Hello, please I need help , I want VBA CODE to Generating invoice number automatic without repetition in my excel any time type in the next cell it...
-
Email sent undeliverable 550 error Closed
I receive emails through Outlook with out problems but get undeliverable messages with 550 error when replying and/or sending
-
Office 365 error was deleted message without beaing read Closed
hi I have office 365 when tracking the read receipt getting an error randomly not every time(was deleted without being read)
-
pasting a column into alternating rows in new column Closed
Hello, i have a column of ID numbers and a column of names next to it, I want to copy and past the names with their corresponding id in cell under the...
-
Macro to automatically update a master sheet from multiple sheets Solved/Closed
Hello, I have a file with a master sheet and 6 different individual sheets. Each sheet is considered a project. It includes person's information a...
-
Working with multiple worksheets in a workbook Solved/Closed
Hello, I am completely new to all of this so please bear with me. I am new to forums and how they work so I apologize in advance if this is a repeat ...
-
para hanging indent does not work Closed
Hello, In PP 365 I have text boxes and text placeholders. When I apply a hanging indent to paras in boxes or placeholders the paras format box says ...
-
Conditional formatting as text, unless cell is a certain col Closed
Hello, If I create a conditional formatting rule for column A to turn a color given work "General" How do I make it so that it turns "General" that...
-
Compare 2 columns if it matches all columns must go toSheet2 Closed
Hello, Thank you for putting the time aside to help me. There are 2 sheets, Summary and Journal. Step 1: In the Summary sheet, I added Column E to ...
-
Indirect Ref# error Closed
I use a formula to set the name of my sheet (using VBA to move data around) to a number based on a cell value. The value is always a number and if the...
-
master sheet to auto populate from multiple sheets Closed
hello! could someone kindly assist me with a formula or a macro that will auto populate/update the master sheet using information from sheets A-E. t...
-
Move rows to another sheet based on values in column A Closed
Hello, I am trying to have rows in sheet "KEY" automatically moved to sheet "INACTIVE DRIVERS" if the cell in column A is "Inactive". I have looked...
-
When I want a letter in CAPITAL ex: É, I got always ÉÉ Closed
Hello, for exemple "É" (Alt + 0201) I got always the double ÉÉ, and the second letter replaces any bouton. Ex: "E-X-P-É-D-I-É", I use the normal...
-
Convert Closed
Hello, Sir/madam how to convert 30-1-2009in words
-
How to lock in specific cells in a formula going down rows Solved/Closed
Hello, I am having an issue with easily repeating a formula I've made. the formula is =IF(AP2=Sheet2!K3,Sheet2!L3,IF(AP2=Sheet2!K4,Sheet2!L4,IF(...
-
Google Sheets Formula Closed
I need to search column D for "Text 1", then if its true, any row that has it, take the data in column B(same row) and enter it into another cell. for...
-
Counting and stop counting in a cell Closed
Hello, I need to create a formula for a cell involving number of days between dates. A2 - start date B2 - lead time C2 - end date D2 - showi...
-
Hello friends. Please help ! COUNTIF formula ? Solved/Closed
Hello friends. Please help ! I want a formula ( maybe COUNTIF? ) to count how many "W" and "D" and "L" are found per each range: "B3:B12", "D3:D12"...
-
Highlight cell if another cell contains specific text Closed
Hello, I have random text in cell C6 that I would like to highlight green if cell N6 has 'yes', red if cell N6 has 'no', and grey out if cell N6 h...
-
change cell color of all cells in my formula Closed
I often have huge spreadsheets where I have to add random cells together. In order to make sure I don't miss any cells, I want to change the color of ...
-
Excel formula to check if cell contains a date Closed
Hello, Hi, I am trying to write a formula to check if there is DATE value in a particular cell. If there is a DATE value, need to say "DELETED...
-
Automatically update one sheet from multiple other sheets Solved/Closed
Hello, I have a workbook with each office location having its own sheet to keep track of project information all with the same column headings. Co...
-
Create and populate sheets based on values in master list Closed
I have seen a few similar forms but cannot seem to achieve the functionality I'm hoping for. My workbook will have a master spreadsheet that is per...
-
Formula to compare 2 columns and count missing values Closed
Hello, I have an Excel spreadsheet where I want to compare values between two columns A and b and to see if any values are missing in column b. ...
-
Email notification when cells in a column are changed Closed
Hello, I am trying to set up a macro to send an email when a cell changes in a certain column in excel. I used a conversation in this forum that g...
-
Conditional format B1 based on a specific word in A1 & calc Closed
Hello, I would like to check how to use the conditional formatting to get a colored cell in B1 containing numbers (based on a "INC VAL" in Cell A1...
-
summing values based on matching column across sheets Solved/Closed
Hello, Hello, I would match data across sheets based on matching columns B then should add & summing the values to sheet summary under heade...
-
how to copy data after at a fixed cell Solved/Closed
Hello, I have the following data for which it needed to be copied on another sheet after a gap of 7 cells for each entry in Sr No. column. Li...
-
Keep Track of Customers Service Visits Closed
Hi All, I need help in keeping track in excel of the customers service visits. I have customers that are visited weekly, some twice a month, most of...
-
Comp. value in 2 columns against a list and disp. text in 3r Closed
Hello, I need some help as I cant figure out how to construct this. I have been using a combination of IFS, AND, & VLOOKUP functions but I cant se...
-
Excel formula for filling another cell Closed
I have four columns in excel. Column A is named "Date" while Column B is named "Day". Column B depends on the value in Column B and I got the Formula...
-
HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS Closed
In creating an excel app to calculate the aggregate for students in their exams as used by WAEC to determine the student aggregate in BECE . The Excel...
-
Conditional formatting in Sheets rows based on text in cell Closed
Hello, I have looked through some past answers and have not found a solution yet; I am trying to apply conditional formatting to a sheet where if te...
-
Code to move rows into another sheet based on certain values Closed
I found this lovely little script on this forum. It has worked flawlessly. I have a spreadsheet with multiple pages and I would like this code to work...
-
Macro: change cell color based on value in another cell Closed
Hello, I'm am trying to fix a spread sheet at work but what i need is a macro that i can run to do the following if the word Traffic appears in...