Office Software Forum
- Excel (9,813)
- Open Office (114)
- Outlook (643)
- PDF (334)
- PowerPoint (181)
- Word (2,187)
-
using formula for conditional formatting Closed
Hello, Excel 2013 I need to add an if formula that creates conditional formatting and I get the basics of it but my formula is not working It's ...
-
Need to know the excel macro Closed
Hello, I have a data like this which I would like to know the macro function. Row column A 1 123 2 456 3 789 Am curr...
-
Excel False cell Closed
Hello, I need help removing the FALSE statement in the cell? =IF(N14=TRUE,CONCATENATE("Need a copy of the Trust Agreement"," If the trust i...
-
formula that searches in a row for a cell/column that contains Solved/Closed
Hi. It would be greatly appreciated if someone could assist me with the following formula in excel: I would like a formula that searches in a ro...
-
convert pdf file Closed
how i convert pdf file in excel file is in marathi language
-
Removing a returned value of FALSE in Excel Closed
Hello, Here is my formula. Please tell me how I can eliminate the FALSE value for cells that don't fall within the date range (e.g. cells with dat...
-
Cannot sent or receive messages windows 7 Closed
Good day We trying to sent and receive emails but cannot do that can you help us please outlook Thanks Configuration: Windows / Mozilla ...
-
Verifying VIN Closed
I have two Excel Worksheets, ie, Mobile Equipment List, and USDOTALLBasics. Both contain the Vehicle Id Numbers. Is there a way to compare and confi...
-
Auto populate based on matched data from other sheet Closed
hi, Newbie here.. Was wondering if this could be achieved thru vba as have tried using formulas and vlookup thru matching criteria and it takes fore...
-
Error in VBA Solved/Closed
Hey, So I Have the following code: Sub GesamtlisteAenderung(ByVal Target As Range) Dim x As Integer If Intersect(Target, Columns("B:...
-
Automatically transfer data from one sheet to another Closed
Hello, I have never done anything like this and i just watched a video that got me the first two correct columns in the second sheet but i am unable...
-
Macro Help - Pasting Closed
I am trying to write a macro for updating workbooks for of my accounts. Basically I have a master sheet of some data for all accounts and need to copy...
-
Extracting data from sheets added everyhour Closed
is there a way to extract data from sheets i add? like if i have data from multiple hours but i put all the data in one book but in different hours is...
-
Macro within Open Office Calc Closed
I am having trouble with making a code do what I want. I am trying to get a workbook with multiple sheets working in this way. if I have a main sheet ...
-
Replace function in Macro Solved/Closed
Hello, I would like to request that in the range D11 to D510 if "-" or " -" or "- " this found then it would be replace with " ". Please do it ...
-
VBA copy based on list to specific directory. Closed
Hi, I am attempting to copy a file with names from an excel list and copy them to a specific directory using VBA. I am using rizvisa1's code from http...
-
Securing a Excel Workbook Solved/Closed
Hey! I Need to save a Workbook strictly as a Template where the peolple at work can't screw it up. I'd like to have it so that they can open my...
-
Copying function using VBA Solved/Closed
Hello, I have a Problem that desperately Needs to be fixed: I am trying to create a Participant List, and in order to Keep it "clean", am using ...
-
Compare 2 columns on 2 sheets for value of cell Closed
I have tried several different formulas and cannot seem to get it right. I have a work book with 2 sheets. I am trying to populate column E of she...
-
how to recover previous version of an excel file already saved Closed
Hello, how to recover previous version of an excel file already saved Configuration: Windows 7 / Mozilla 11.0
-
Copying number over from last sheet and adding to it Closed
Hello, I'm trying to figure to if it's possible to do the following: I have an excel doc with monthly spreadsheets and I would like a number to be...
-
tranfering of data Closed
how do i add symbol in cells in sheet 2 if there is data in cells in sheet 1. example: i have data in A2 in sheet one. i want to add a * in A2 in shee...
-
Extract rows of data and paste to new worksheets based on locati Closed
Hello Fellow Excel Users: Please help if you can. I have a difficult problem that I hope someone could please help me with. I have a worksheet of...
-
Office Home and Student Excel Closed
I have read everything. Been asked to submit my first question three times. This doesn't bode well. Third time typing same question. I have used exc...
-
Macro that will delete rows based on greater than current date Closed
Hello, I want a macro that will delete rows that are greater that the current date so if today is 2016-05-05 I want it delete all rows with somethin...
-
copy the number matched to another column Closed
Hello, I want help from world.i want to copy the list of number to other column which are match in original column. Start no 974314567 copy the ...
-
VB & pdf files Closed
Hello, Overall goal to open pdf files, copy information to excel sheets & close pdf files. From reading material on web it might be easier to conv...
-
How to watermark PDF online? Closed
Hello, How to watermark PDF online without the need to install any software? Configuration: Windows 7 / Chrome 50.0.2661.87
-
Excel 2010 - "file is corrupt and cannot be opened" Closed
Hello, We're upgrading to Office 2010 and having some fun issues with old and new .xls files. Current issue is that many .xls files (as opposed...
-
Dell Inspiron 1545 system/admin. password Solved/Closed
Hello, my friend bought a Dell Inspiron 1545 at an estate sale.It has the system/administrator password enabled. I'm hoping someone can try to generat...
-
make a new worksheet and copy rows Closed
Hello, I have a worksheet of data and I would like to copy all rows in the worksheet to new worksheets based upon location. To elaborate, I ha...
-
How to build a auto updating Training Tracker. Closed
Hello, I am trying to make a primary spreadsheet for a personnel training tracker, I have over 50 people and 30+ different training items. with f...
-
Graphs comparison in excel Closed
Hello, Is it possible to compare graphs in two excel files using macros? If not, is there any other option to do this? Kindly help.
-
Pulling Data from a note field in excel Closed
Hello, I wrote a formula to look through a note text field for a certain phrase and pull a YES. What I need to do is actually pull whatever number...
-
copy formulas from one sheet to another all at once Solved/Closed
Is it possible to copy formulas from one sheet to another all at once? I have a worksheet that I would like to use as a template and I'm having to cop...
-
Excel Formulas and Functions Closed
I have an excel form where the user types a customer name to find if it exists in another data sheet. If it exists, a function should retrieve it to a...
-
Comparing data in multiple columns to another sheet Closed
Hello, In Excel 2010, I have a sheet of names and addresses that I would like to compare to a new report of names and addresses to find any names th...
-
Vacation tracking help Closed
Hello, How do i make a cell increase by 40 every 180 days from known date... Configuration: Windows 7 / Chrome 50.0.2661.94
-
Macro move next column to next row? Closed
Dear All, introducing my name is John and im new here. Ive data like below A B C D 1 John Willy Dian...
-
forget password Closed
Hello, i have for get password,plz can you help me out regarding this matter. Configuration: Windows XP / Chrome 49.0.2623.112
-
Macro that create a new workbook for each unique value in column Closed
Hi, In the example below, I would like a macro that creates a new workbook based on the names in column A and copies only data relevant to that nam...
-
Number format a cell based on the text in another cell Closed
Hello, I want to conditionally format a cell to change the number formatting to a percentage or currency based on the text in another cell. Fo...
-
Want to increment a Alphanumeric value in a range of cells Closed
Hello, I have Alphanumeric value in range of cells example from B2 to b28 number will be like H000000000000100 I want to increment the last four...
-
MS excel question Closed
Hello, I am having a name list in column A and category list in column D and I want to list names of same category in column G in another worksheet....
-
Percentage conversion in excel Closed
Hello, Kindly assist me on How to find a formula for calculating a problem like this one below; Cell A1 (Assignment 1Out of 20) Cell B1 (Assignm...
-
sum of two max out of n number Closed
Hello, mam /sir how to sum of two max out of n number Configuration: Windows 7 / Chrome 49.0.2623.112
-
want to know how to convert date into words(english) in excel Closed
Hello i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April Two Thous...
-
Excel Doubt - IF Formula Solved/Closed
Hi, Im stuck in an if question. I have 3 colums. In the first one I have a number, in the second column a have "yes" and in the third column I w...
-
Conditional Formatting Closed
Hello, Want to apply conditional formatting for specific text but not able to do so. Below is the case:- I have two texts - 1. "N" & 2. "NA"...
-
Automatic Data transfer Closed
I have a master data sheet that one column in the sheet that represents a sub set of the data. When I add information to the master sheet, I want the ...