The discussions
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...
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...
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...
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...
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 ...
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...
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 ...
If function for date ranges
I need to know how to do an if function: If D2 is >= 9/1/2008 and E2 is
Formula help to add columns that contain text
I want to add the total of Column A (going to be text) and Subtract Column D if there is an "x". How do I do that formula? Anyone able to help? Exa...
Hi all can you help me with the formula i require below
Im looking for a formula that will look at a number in row b and if that number is 1 will add 1 day from the date in row c and put it in row e, and if...
Excel - creating reminder pop up based on criteria
Hello, may you please help me in creating a reminder to pop up for every 5 hours once for a cell range having text equal to "pending" I was able t...
Help: return day of the week
SolvedHello, I have checklist sort of form that I am printing every month to let them sign for task everyday. from C3 - AG3 it is numbered 1-31 and un...
Excel - repeat rows to a specific number of times
SolvedHello, Hi Does anybody know how I can repeat rows in a spreadsheet (or into another spreadsheet) by n number of times specified in the cell in...
How to copy sheets from one work book to other
Dear Team. My query is Iam having two workbook in d drive as 1.xlsx and 2.xlsx i want to copy two sheets from 1.xlsx and paste in 2.xlsx ...
Macro to add down a column
Hello all, I need a macro that will sum numbers down a column until it gets as close to 8 as possible. ex: 1 .5 .5 4 3 .5 3 2 so a ...
Nested formula with 'or' statement
Hi, I have formula IF(ISBLANK(A3)," ", C3-TODAY()), which works absolutely fine but and i want to include another argument on it so that if value in ...
Sumproduct gives me error
Hi, I am using the below formula, but it gives me error. Any ideas why is that? I really should work same as the countif formula but instead it giv...
Find text in one cell, add different in another cell
Please be aware, I don't have much hair on my head to begin with and really don't have much to pull out either.. I'm frustrated. I've tried every ...
