The discussions
Locking a range based on a value of a cell
SolvedHello, first I would like to thank every one working at kioskea my issue is , I want to lock a set of cells ( A2:M2) if the cell M2="app" and ...
Removing duplicate data
A call for urgent help to anyone out there. In capturing data from archived files I saved this both on my laptop as well as on a plugged in memory ...
Require help to count number
Solved1652 1646 1650 1658 1622 1651 1659 1582 1599 1606 1611 1657 1745 1937 1936 1648 1666 1656 1636 if i type like this in diffrence cel...
Grater then , less then with number range multiple
Solvedif the numbers cell A110 means the cell B1 have to calculate the C1 cell and if A1 20 means the cell D1 have to calculate ...... please let clear...
Relative worksheet reference in formula for chart data ranges?
Hello, I am working on a project and was hoping for some help any and all excel wizzes if you have the time. Does anyone know how or if one can re...
Converstion of xls file to xlsx format
Hi I had recovered my lost xls format file and tried to open it with excel 2010 version. how can i view it in the new version. Is it possible to tran...
Excel "if then" formula
SolvedI am looking to create a "If Then" formula for Excel that can put an "X" in the cell if the date I am reffering to (Cell A6) is 0-5 days, next cell 6-...
Comparing three columns and giving back specified values
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
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
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...
SolvedI 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
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
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...
Step by step help creating a link
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 ...
Less than/greater than
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...
Automate excel to shift data so the values in two rows match?
SolvedHello! 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
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
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
SolvedHi. 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
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
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?
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
I kindly needed help on developing a workplace using database format for entering my medical equipment such as specification, model, serial numbering ...
Vba code worksheet with a list of 67 competencies and 3 criteria
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
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
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
ClosedHello 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
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
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 blank rows based on the value in a cell.
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
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
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
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
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
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
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
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/ClosedI'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
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
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
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
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
how do i down load software free soft ware from this site.
Excell automatic filters
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
SolvedHello, 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
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
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
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 ...
Help comparig data in two different excel spreadsheets
Hi. Im a little overwhelmed. i have one spreadsheet that i keep that has my 125 contracts and task orders on it. example: row 1 contract number ro...
Multiple processors for excel
I work with very large spreadsheets in Excel on a Mac and I often have to wait for Excel to execute things like sort and fill. I'm hoping too solve...
