The discussions
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...
Auto generate invoice number save and clear
I'm new to this site. I'm using excel 2013, I want a macro to auto generate invoice number, at the same time when I save it should copy and clear th...
If... then
Greetings all, I hope I can explain this correctly as this is my first time asking questions on a public forum. All me to set the stage. A = ...
Format fill colour based on another cell
SolvedHi I would like to format my excel page so that the rows alternate between two fill colors based on whether two cells are equal or not. Here is an ex...
Calculating text to result certain text result
hi, if I enter S into cells a1 & b1 & c1 I need cell D1 to result 'CO'. if either cells a1,b1 or c1 has NYS entered into either cell or all 3 cells I ...
Transfer cell data from one workbook to another workbook
SolvedI am using two workbooks to track account spending for quarterly reporting. Workbook 1: Day Expenses Workbook 2: Monthly Expenses WB1: I have fo...
Question about my if statement
Hello, I have an excel file with portions of addresses and i want to take the city state and zip code and put it in a separate cell. For that i u...
Date format change in excel
SolvedHi, I have an excel worksheet with a date column in the format m/d/yyyy h:mm:ss AM/PM. How can I change it to the format d/m/yyyy h:mm? I tried the '...
Applying conditional formatting to rows that vary
I need to have AA turn red when the date is out of window of AB and AC. I have dates in column AB and AC the dates are all different in each row. I...
Date formate
i have 2 date formate example 06/11/2004 07-01-2004 and i want 1 formate and i useing this function =text(CellAddress,"DD/MM/YY") and text(...
Numerical value is range of cells has a text value
Hi guys, This is for a holiday rota. if any sell has a 'h' in it I would like to total up the h's in a cell at the end as a numerical value of how ...
Sum range if 2 conditions met
Hi, I have arrange of numbers which I would like to sum in a certain cell, only if a column contains certain text and another column contains another ...
How to freely download softwares?
Hello, Please help me in downloading IDM, Mavis typing and Adobe reader free of charge. Thank you!
Classic menu for word 2010 or 2013?
SolvedCan you clarify? Will "Classic Menu for Word" work for Word 2013 or just for 2010? I see both on your download page.
