The discussions
Macro:- deleting rows on condition for selected no of col.
Hi. I have an excel for which i require to delete rows if there is "n" found in the row. But i want this row to get deleted for only a particular n...
Chg background color of any cell in range based on another cell
Hello, I am trying to maintain a spreadsheet of races and personal bests for runners. My runners are in rows. The races and Mile Split times are...
Automatically transfer data from one sheet to another
Solved/ClosedHello, I have a workbook with 2 worksheets. Sheet 1 has about 400 line items. I would like to be able to select certain line items on Sheet 1 and ...
Calculate total total hours per client
SolvedHi, I have a spreadsheet in which employyees time are entered on a daily basis along with the client they worked for. The spreadsheet calculates ...
How to change row color based on percentage??
Hello, Starting in cell "AB10" I have a value in percentage, if the percentage is below 20% I want the entire row to be yellow fill, if below 10% ...
Building a reporting tool
Hi Guys, This is my first time on this forum but it won't be my last. I am pretty functional with excel but lack VBA/macro skills but I am in the p...
Enter current date and time with shortest cut
Hi, I'm using a tracking sheet for incoming couriers everyday, and would like to log each item as they come with current date and time. I've been u...
Convert values in 1 cell to rows
Hello, I have an excel in which there are multiple values in 1 cell separated with comma. i want all the values in cell to be converted in to d...
How to count date cells for monday of this week
SolvedHello, I would like to count the number of cells with date = to MONDAY of this current week and also MONDAY of the following week within a defined...
Xlsm vs xlsb
Hello everyone, I've been reading up on the two different file formats and discovered a large variance in opinions. XLSB, being binary, apparently ...
Excel help: if function using or, how to make false disappear!
So I'm writing an excel formula based on Award placings in a race using the IF and OR function. I have the formula correct but I don't want anything t...
Copy a row and paste it down 119 times
Hello, I am using Mac Excel 2011 and I am quite new to Excel Marco. For the purposes of organizing research data, I need help with creating VBA c...
Auto generate the seller sales report
SolvedHi! I create a sales report and I set up total 6 worksheet Worksheet 1 I named it Price list ... is a Data for my sales report. and I set a co...
Formula to increment date by seven days.
SolvedHello Everyone, In a work sheet, I have an invoice date (say column A) and a due date (say column H) with the due date being seven days after the ...
Automatically transfering rows from one sheet to another
SolvedHi, I was wondering if anyone could help. I've created a spreadsheet to track all contracts complied within our department. I have a "Contract Sta...
If function with date addition
SolvedHello, I'm having trouble finding an answer as to how I can add 5 more days in my condition. I have 4 columns: one for an Order date (A2)...
Dealing with 'today()' formula in excel vba code
SolvedHi Everyone, I have this VBA code in a Excel sheet (specifically in the Module) which does the following: - finds the empty cell in range "B:B" -...
Macro needed to delete rows with certain condition.
Hi, I have about 169,000 lines of items to go through and I'm trying to figure out a macro to delete every row that contains the word "Discontinue...
Excel > macro for defined range dates
SolvedHello, I've a question that I have starting date in Column "E3" Sheet 1 and ending date in Column "F3" Sheet 1. I want a macro that insert dates i...
Macro or vb code help on moving data from one sheet to another
Hello, Would request you to please help on the following query I have. I have an Input sheet which has data entered in Column A to F like name, emp ...
Find second empty cell/row and start pasting from it
I've already did a lot of research and couldn't find a solution. I'm trying to find the second empty cell/row (or other especified cell) in a column a...
Excel place a vaue in a cell if a number is in a certain range
I need to setup ranges and place a number associated with-in that range. 150 300 450 600 750 900 This data is from column M. I need to b...
Formula compare two different cells containing the scores of tes
Hello, I am trying to create a formula that will compare two different cells containing the scores of two tests. A student can only get PASS remark ...
Static dates
Hello, I'm new to the abilities of excel and would appreciate any help. I'm trying to create a worksheet where when any data is entered in column A ...
How to copy data based on criteria met
SolvedHelp! I am totally stuck and this is probably a very simple fix. I have two sheets "Priority Accounts" and "ACN Dashboard". I need to move data i...
Excel 2010 vba date formula
Solved/ClosedHi, I am trying to get a formula setup so when you click on a cell in excel it automatically enters the date. I am using the formula below which wo...
Copy values in row to columns in spaces
SolvedHello, I am a beginner in VBA, and would mcuh appreciate some guidance on transposing data in a row to a column via VBA. My row data is as foll...
Copying data from one data sheet to another automatically excel
Dear Excel Gurus, What I want excel to do is, if a name put in a certain category on sheet one, then it automatically get copied into another sheet w...
Conditional formatting
SolvedSuppose I have date in Column A (from A1 to A100) and in Column B (from B1 to B100), Both data are numerical. If the data in Column A is greater than...
Movind data from one cell to another via a macro
Hello all-- I am in need of someone's valued assistance. Here's the story: I have an excel spreadsheet that contains address data in Cell B6 & B...
Removing " false " value in "if&quo
Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(C13="",IF((K13>="06:00"+0)*(K13="...
Excel 2010 code that clears content of a cell on open
Hi I am looking for code that clears content of a cell based on a value when the workbook opens. I have several sheets in the workbook with varied...
Conditional formating of row based on other cells
Hello, I am trying to format cells A7-E7 based on the relationship between C6 and C5. Ideally they would be coloured on a scale between green and y...
Specific data from one worbook to another (excel 2010).
SolvedHello there, I have two workbooks, one is an accounting spread sheet (named Cash Book) and the other has an Invoice Template (sheet 1) and Invoice...
If then formula using a date
Hi, I'm trying to create a formula where if the date falls on or after 08/01/2012 the value returned is .0464 and if its before 08/01/2012 the value r...
Excel 2007 custom filter problem
Solved/ClosedHello, I have been using Excel 2003 to sort phone numbers easily, using the custom filter and 'begins with' for example on numbers starting with 123. ...
Multiple columns using countifs
I have a column such as a1 --- 'Vendor' ----> (Win/Loss) column N ...
Comparing excel columns - help asap please!
Hello, I need help, please! I have two worksheets (C & Q). Each worksheet contains four columns, each column has different information(A=Date, B=Mis...
Run vba automatically when criteria is met
I want to be able to run a macro automatically when criteria is met.. If any cell in column A is change to "re-let" run "rowformat" macro can an...
Time calculation
SolvedHello, dear all please I need a help for formula to calculate the duration ( hours ) between two dates for example : A1 ---> 1-8-2014 1...
Conversion of multiple column into single column
Hello, I have a date set in the following format 1 3 5 7 2 4 6 8 I want this in the format 1 2 3 4 5 6 7 8 Please help m...
4 conditional formats
I am attempting to add 4 conditional formats; First in red the 'cancel' - already done Secondly all things that complete on today's date in blue - d...
Duplicating macro
Hi I currently have the below macro to duplicate rows for me but I want it to show the data in 2 columns instead of nderneath each other. EG OV...
How to convert number into text in excel
Hello, Thanks for the nice solution. I have a problem and that's what should I do if the number is bigger than 999,999,999? Configuration: Wi...
Formula that i can get a total for d7, if d7= d4 + (c6*d7)
Solved$1,613.00 (Cell D4) (C6) Hours ___ $175.00 (D6) TOTAL (D7) Can any one tell me a formula that i can get a total for D7, if D7= D4 + (C...
Simple if function
Hello, I have a column reading random dates (dd/mm/yy) and the column next to it has to read "Y" or "N" depending on whether the date is before or...
How to copy data in cell ranges to another worksheet "if"
I have a source worksheet that is named "AVDistribution" and has several columns and rows of data and I have additional worksheets in the same workboo...
Conditional formatting between
Hi Ppl have conditional formatted a range of cells with numbers, to turn green if numbers are BETWEEN numbers in Column A and Column B but Proble...
Auto copying in excel
Suppose I have account in say 5 different banks and I have made one excel sheet for each showing date wise transactions. The sheet contains the follow...
Comparing unsorted data across separate files
I need an automated way to compare the 2 sheets to make sure no equipment gets missed for ordering. I have to compare an order for equipment against ...