Office Software Forum - solved topics
- Excel (9,800)
- Open Office (113)
- Outlook (643)
- PDF (334)
- PowerPoint (179)
- Word (2,187)
- Solved
-
Outlook 2007 is not sending mails Solved/Closed
Hello, Have a nice day. I migrate my data from one PC to another. The old one was having Windows XP operating system along with Outlook 2003 w...
-
Copy and insert rows n number of times in Excel Solved/Closed
I am trying to create a macro under Excel. My data is as follows: Col1 Col2 Col3 Col4 Col5 Col6 Col7 A1 1080 90 M 40 45 50 A2 999 90 M 25 ...
-
Shortcut to edit a cell without using F2 key Solved/Closed
Hello, I'm working in excel (excel 2010) and using a Logitech Bluetooth keyboard. Normally to edit a cell, I would select the cell and hit F2, bu...
-
Data in a hot key Solved/Closed
Hello, I want to put an email address in a hot key so I don't need to type it ever time I need to insert it. Thanks for your help in advance.
-
Conditional format if hyperlink Solved/Closed
Hello, In my workbook I have conditional format background color is green if there are a certain value in the cell. The text in the cell has font co...
-
Compare the words in 2 columns in Excel Solved/Closed
I gt two different excel file . So now my task is to compare the words in the entire columns in excel file 1 and excel file 2 , then output a new colu...
-
Excel forum within a range Solved/Closed
Good day I am looking for a formula PLEASE. Example Column A, Column B, Column C, Column D, Column E, Column F No, Start, End, ...
-
Convert wordpad document back to pdf Solved/Closed
Hello, i as sent a file and wheni went to open it it said open with word or internet i picked word and now its not what i wanted to have done beca...
-
Need to delete columns based on Column header Solved/Closed
Hello, I need to have an macro which will delete the columns from my excel based on the Column header. Exsample: I have the columns, Name...
-
Auto generation of code Solved/Closed
Hello, we facing issue in the auto generatation of vcode. it asking CUSTOMIZE HERE TO SUIT YOUR NEEDS . what code to be fill for this? kar...
-
Excel - A macro to create new workbook and copy data Solved/Closed
In the example below, I want to copy Column A starting from row 2 ie: "Age" till the value available ie: "Code and column B starting from row 2 ie: "2...
-
Excel - macro to create multiple sheets Solved/Closed
Hello, I have 16 sheets in excel. each of those represent a location (office) and they need to pull information from sheet1. This is for credit ...
-
Comparing columns and returning value Solved/Closed
Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: Column: A...
-
Import .pdf ...? Solved/Closed
Hello everybody, Thanks so much for this thread, it has been extremely helpful! I have used the basic code suggested by Trowa, and it works for...
-
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 ...
-
Formula Solved/Closed
I need some help with a formula, everything I try just doesn't work. I usually don't have this problem with Excel today is my day. I have a colum...
-
Conditional Formatting based on two cell values Solved/Closed
Hi There, I'm using Excel 2016 and am trying to apply a conditional format that searches cells in column A for the text "*DEMO*", and also has a c...
-
Copying cond. format for entire row based on 1 cell to other row Solved/Closed
I have conditional formatting for an entire row based on the value of 1 cell. For example: cell value>$A$2 = red, cell value
-
Drop down lists Solved/Closed
Hi All, i have a drop down list in excel and the data for the list in a sheet in the same workbook. If I copy the spreadsheet with the list to anot...
-
Removing False Value Solved/Closed
Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(G23=0,P15/Sum(D11:F11,IF(G23>0...
-
Copy rows to other sheets based on value in column Solved/Closed
All, I have an Excel file with three sheets: Sheet1 contains all my data. Sheet2 named "MACH" and Sheet3 named "FAB" I am looking for a way with a...
-
PDF file alwasy opening in Word Solved/Closed
Hello, What to do to disable my attachment file in pdf to open in Word application?
-
Trying to create a multi-column formula. Solved/Closed
Hello, I need help making a formula. I will do my best to describe. The letters (A-I) refer to separate columns. A-B=C to be divided by D the res...
-
Excel problem Solved/Closed
Hello, I want a formula in which, If I enter the number in cell, the name of that number should appear in adjacent cell. Ex: Emp No Name 1 ...
-
recover user id of irctc Solved/Closed
Hello, recover irctc user id , i forgot it , so help me Configuration: Windows / Chrome 53.0.2785.101
-
Excel find word in series of cells and add Solved/Closed
Hello, My colleague wants to has a spreadsheet with many columns and rows. The spreadsheet setup is something like this: Cells under column A ha...
-
Highlight one value in a dropdown menu of three responses Solved/Closed
Hello, I have a template where we are asking for responses with a drop down that includes Y, N, and N/A. We want to highlight all N answers in yell...
-
Code to move rows into another sheet based on certain values Solved/Closed
I'm having trouble figuring out how to do something! I have a sheet (Sheet1) with customer details on it (columns A-D will have data in). I want to be...
-
Excel formulla Solved/Closed
Hello, I want to split cell of available qty in to multiple cell according to requirement. Input Sheet -1 Material PO qty Req. Qty ...
-
Search a list of names at one time in excel Solved/Closed
Hi, I have a huge list of names (list A) which I need to search with another list of names (list B) and see if any name in list A is in list B . Is i...
-
If a cell contains any text then add a value (with dates) Solved/Closed
I am looking for help with a formula that will allow me to add up the number of times a certain date is a Monday. I am using =COUNTIF(A1:A30,"*Monday...
-
Macro to increase a cell reference by 11 Solved/Closed
Hi everyone I want a macro that on open will increase the cell reference in a cell by 11 each time the book is opened i.e. Cell C18 has =Sheet2!H2. T...
-
How do I change a word doc into PDF or similar file format Solved/Closed
Want to send off a resume and they do not accept my covering letter in Word format, how do I change it to PDF or similar please
-
conversion of DOB to full words Solved/Closed
Hello, Configuration: iPhone / Safari 4.0 I want to to convert dob to word like 5/6/2014 to fifth June two thousand fourteen please tell me...
-
Data auto change on multiple status in one column Solved/Closed
Hello again, Few days ago i am looking for a command that can use to change data status in one same column. Example : 'Activated' change to 'Expired...
-
Question on VBA code Solved/Closed
Hello, can someone explain this code to me? I have this file that has a macro button transferring all the information(KPI's to be exact) from a data...
-
Formula help - if cell contains a number, +1. Solved/Closed
Hi there, Just a simple one for you guys! I'm currently making a spreadsheet to tally up sickness days and occurrences. I currently enter how many s...
-
Covert date of Birth Solved/Closed
Dear Sir I want to convert date of birth in excel like below mentioned Example : 11/07/1982 then it should be reflect as Eleventh July Nineteenth...
-
Need help with Macro to generate Monthly Overview Solved/Closed
Hi all! I have been trying to build a Macro that allows me to generate a new worksheet with the information from a Master Sheet where i will key in t...
-
Conditional Formatting Solved/Closed
I am trying to format column 'O' if the value is greater than zero but where column 'P' does not include "SBNAS735" or "SBTDP443". Help! System Conf...
-
Transfer data from one sheet to another Solved/Closed
Hello, I require some assistance please. I looked at a few answers on this forum, but I am stuck as my VB keeps on giving errors. I wish to automa...
-
Date formats Solved/Closed
Hello, Can you tell me how to change the format from Sep-01-2015 to the format 2015-09-01? I have tried the format tab under the Date section and Cu...
-
Adding number of days in filtered excel sheet Solved/Closed
how to add number of days to columns in a filtered excel sheet
-
complicated auto populate possible or not and if so how. Solved/Closed
Hello, I'm using excel to schedule for my business, I have all the customer information on the first sheet and would like to auto populate the other s...
-
Copy row by x times where value x is cell value of the range Solved/Closed
I need to scan each value in a column A and use the value in that column to copy the current row x times to another sheet. The second sheet is to be u...
-
iso 27005 Risk Value Solved/Closed
Hi All, I have the following problem: I have two cells that have a text value which can either X or M or H X value is 0, M value is 1 and H value i...
-
copy a row from one worksheet to another, based on criteria Solved/Closed
Hello, I'm trying to copy rows from my "master" worksheet to another sheet based on criteria in column A. Can I do this? Please help, thanks...
-
I want to send 120 e-mail with 120 attachments Solved/Closed
Hello, I have excel file for salaries. In this file I have all the data for each employee (120 employees) including their e-mails as well. I want ...
-
Totaling Hours by Code Solved/Closed
I'm looking for some excel help please :) I have an excel sheet that I would like to have totals for employee hours, sorted by the code that is enter...
-
change data status in one same column Solved/Closed
Hello, i am looking for a command that can use to change data status in one same column. Example : 'Activated' change to 'Expired' when it due. ...
