Office Software Forum
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
comparing three columns and giving back specified values Closed
I want search for strings I have in source(A) in both source(B) and source(C) and when it finds those documents give them the three revisions I ha...
-
Search and transfer data between workbooks Closed
Looking at reviews, I know this request will have a simple answer. I am new to Excel, and I need help on this spreadsheet. I have workbook open. On...
-
Moving data from one spreadsheet to another on Excel Closed
I really need to be able to set up a macro & formula so that once I pick an option from a drop down list on my work book, that will automatically plac...
-
Need help comparing dates... Solved/Closed
I have dates in one column, I want to enter a $0 value in another column if that date is >= 5 years in the past. Obviously, I'm a relative newbie with...
-
Free office software Closed
Hello, I would appreciate any information on the best free office download available to suit windows 8.1. Thankyou in advance for any assistance. G...
-
automatic copy on excel Closed
hi sir/mam, i want to automatic copy a data from sheet to another. all those qty on out column in big warehouse sheet must be copy to small warehou...
-
Excel 2003 Date format Closed
Hello, Excel 2003 Date format yymmdd I use Excel 2003 (because I like it) and use the International date format yymmdd (it is the shortest versio...
-
Step by Step help creating a link Closed
Good afternoon all, I would like to create a link in a cell that will create a new worksheet in the same workbook. I am new to VBA and Macros so I ...
-
If function with dates in one cell and numbers in other one Closed
Is it possible to use if function for following: I have dates in on cell and numbers in other one. Dates are for the whole month and numbers are betwe...
-
How do I make relative worksheet references?-excel 2010 Closed
How can I reference the current sheet in a formula for a chart data range?
-
Reference the current sheet in a formula for chart data ranges? Closed
How can I reference the current sheet in a formula for a chart data range? I am making a large number of graphs; each one references data on the sa...
-
Less than/greater than Closed
I need a formula that will allow me to show if any cells in a range have a greater value than 100,if so show "YES". If not, have cell remain blank. I...
-
Create a worksheet when information is typed in a cell. Closed
Hello, I am trying to have a new worksheet created (from a template) when I type information in a cell. For example, if I type Ellen McKay in ...
-
Auto Generate a new worksheet from list in another worksheet Closed
How can I automatically create and name worksheets in a workbook based on a list that exists in another sheet "Summary" in the workbook? The list begi...
-
Automate Excel to shift data so the values in two rows match? Solved/Closed
Hello! Please help me with this quandary for my internship. I would greatly appreciate it :) Here is my problem: I want to match ID numbers in two co...
-
Excel Auto-Data Transfer Closed
Hello, 1. How do you transfer a whole row of data into a new tab if an X is put in the first blank column of data 2. How do you move a whole row...
-
Restart Microsoft Office Closed
I have this MS Office Professional Plus 2010 and it needs activation key. I entered the activation key and it said the picture here. I don't know ho...
-
Copy X Row N Number of Times Solved/Closed
Hi. I need the formula to Copy X Row N No.of Times. For Example Col 1 Col 2 ABC 3 DEF 5 GHI 4 O...
-
copying data in excel -only figures but not formulas Closed
I would like to copy data from one worksheet to the other but do not want the formulas and calculations to pass from one worksheet to the other - just...
-
Need help for Combination macro Closed
Hi someone, Please help me out the following problem. I have 10 nos. of machine as A, B, C, D, E, F, G, H, I, J and K. Combined to 2, 3, 4, 5, 6,7 ...
-
Need to total a column with text in it? Closed
Hi I am looking to total a column that has specific text in it. e.g My column has the words Leave, Public Holiday or Sick in it so at the botto...
-
DATABASE FORMAT Closed
I kindly needed help on developing a workplace using database format for entering my medical equipment such as specification, model, serial numbering ...
-
Conditional formatting based on information in two sep. Cells. Closed
Hey guys. This is for Google sheets, but since its mostly the same, the answer should work. Heres my problem. I have a Data point in B3/B999. In D...
-
Vba Code worksheet with a list of 67 competencies and 3 criteria Closed
Hello, I have a worksheet with a list of 67 competencies and 3 criteria for each competency. A button is created on the same sheet such that upon c...
-
Who to identify least one in excel Closed
Hi, I have 10 Cells can be filled with between the text "L1" to "L20". In that we want find what is the least LXX text is . Someone can we help me ...
-
Macro Help Needed - Copy data row(s) from column into new file Closed
Hello and thank you in advance. I was trying to follow along with the answer given here, but I'm not well versed in macros. https://ccm.net/faq/213...
-
Change Date Format - dd/mm/yyyy HH:MM:SS to mm/dd/yyyy HH:MM:SS Closed
Hello all I have some 1000 cell of date format. which has " 13/05/14 16:53:59 " Excel not recognize as date.. How can I change.. Tried Format...
-
failed to activate Closed
I had a hard drive crash and reloaded all the software on a new disc. When I tried to reactivate Office 2010 it refused the product key in my box wit...
-
Running a Macro Automatically Closed
Hi Guys, I'm using the below code in VBA to hide and unhide colums in Excel. Sub Hide() If Range("A1") = "Summary" Then Columns("B:Z").Hidde...
-
Add an amount Closed
Hello, I am trying to make a spreadsheet with prices that has to do with transport. I have a cell, which I just add the number of km, and the pri...
-
How to change date format in excel from dd/mm/yy to mm/dd/yy? Closed
Hello, How to change date format in excel from dd/mm/yy to mm/dd/yy? It seems format cell option is not workin :(
-
add blank rows based on the value in a cell. Closed
Hello, How to add blank rows based on the value in a cell. Say if value in cell is 9, then 9 number of blank rows to be entered automatically....
-
Change the text colour based on the value in the cell Closed
Hello, I want to change the text colour if the value is between -10 to 5 to green and the value between 5 to 40 amber and value between 40 a...
-
Automatic data transfer Closed
Hello, I have two tabs in a work book, Materials and Hire. In materials I have column A - PO Number Column B - Job Number and Column C - Date I am...
-
Autofill cell with color based on deadline Closed
Hello, I would like to ask for help on a task I need to do dealing with dates and deadlines. I have "C" with the due date of the task and would li...
-
Microsoft Office Accounting 2008 Closed
Hello, Why do you need product key if Microsoft Office Accounting is a deleted product??? How do you get key? Configuration: Windows 7 / Mozil...
-
Need to pull data from particular cells and add to another sheet Closed
I've got about as far as I can with my limited knowledge of Excel so am searching for guidance, any and all appreciated. I have a sheet which measu...
-
Split of row data into different subsequent rows Closed
Dear Sir, I have query relating to split of data of one row into other subsequent rows upto certain number of characters till the width allowed to...
-
Using a different "From:" email address Closed
Hello, I have a Hotmail account that I use for my primary email address (myaccount@hotmail.com). I recently began doing parttime work for my ...
-
Excel returns FALSE sometimes.... why Solved/Closed
I'm using this formula to show the persons age based on date of birth. In some cases it works but in others it returns FALSE. If I change the date of ...
-
Date Formate Issue Closed
Dear Friends i have one column of Date in A1 cell issue is diffrent date formate in Column A1 and i want convert in one formate shap Expample is ...
-
Excel issue Closed
Hi, Please help me with this query asap!! I have data in 3 worksheets. have to compare C column of sheet 3 = MATCH ( data in A column...
-
Transfering data Closed
I have a charts with 2000 lines a colums of first names, a colums of last names, 3 address colums. I have a similar chart on a second sheet. Which...
-
Help with VBA Code to Copy and Paste Data Needed Closed
I want to create a worksheet and copy and paste rows with a specific value in Column A to a worksheet named for the value. The new sheet should have s...
-
how do i down load software Closed
how do i down load software free soft ware from this site.
-
excell automatic filters Closed
Dears kindly i need fourmala to do the following i have a sheet have column A & B& C A have 3 different value (type1 ,Tybe2 & Tybe 3 ) and each on...
-
Excel 2003 IF Function using Dates & Text Solved/Closed
Hello, I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell w...
-
ms office entreprise 2007 browse folder probl Closed
when am installing ms office entreprise 2007 it shows browse for folder ....i cant do anything plz tell me friends I already formated my system and do...
-
IF Function return FALSE Closed
Hello anyone, I need help on my formula. I use an IF formula but if the cell shown zero it returns false. the formula is like this =if(L7=0,0,...
-
Conditional Formatting: column A based on text values in columnB Closed
Hi, I am trying to figure out a way to use conditional formatting to highlight the cells in column A based on the specific text in column B. I ...
