The discussions
Conditional formatting to colour cell based on text in another
Hi, I have a workbook tracking submission of work ideas. In column C I have the date received. In column J I have status (approved, rejected, pendi...
Excel
Hello, Function SpellNumber(amt As Variant) As Variant Dim FIGURE As Variant Dim LENFIG As Integer Dim i As Integer Dim WORDs(19) As String ...
Conditioning formatting
HI All, we have mandatory annual training requirements and I have a spreadsheet which records the date training has been completed. we have seve...
Date formula
HI I want to set the formula for excel for when I insert date in cell ex. 1dec2013 then I will select any empty cell date change in to 31dec2013
If command across multiple cells
Hi Guys, I can successfully use if command with text on a single cell, however I want the true or false outcome to be based on multiple cells. T...
Find and extract text from a cell content
I need to search a cell for content and extract and display a portion of the cells content. How do I do this? Here are more specifics. lets say...
Date function using if_ else statement
My requirement is while writing a function using if statement : In a range of cells in say: P10: P20, containing dates, I want to writ...
Require formula
I want to type only 1 in excel cell but require to come 100 and the same that 2 for 200, 3 for 300, 10for 1000, 50 for 5000, 100 for 10000 and so on. ...
Excel if argument
Dear All, I'm trying to use IF argument in a excel document for a calculation. But it is not working. I'm using more than 8 IF argument. My excel i...
How to move data to different sheets
I need to enter data into several different sheets and then would like some of the data to transfer automatic to a log sheet so I can then sort it. C...
Moving data from rows into columns for every
SolvedHello, I have data in a single column and would like to transpose it into a row for every three rows with a space delimiter, for example; The colum...
Excel vba
Hi, I have a VBA data entry user form where in 200 people will be updating it and updating different excel sheets and will be saving it. All the d...
Comparing columns
I have a list of 77 names in column B and need to compare them to a list of 156 names in Column C- My objective is to determine if any names in column...
Excel macro: combine selected rows
SolvedHello, I have source data in Excel looking like this: CustomerID SalesMonth SalesAmount 12345 Jan 15...
Excel if statement for dates
Hello, I was wondering if there was a way that I could set an if statement that would change the color of box to red if it's 2 months ahead of tod...
How to use recorded macro in different cells
Hello, Kindly help me to resolve this issue, I want to insert data in 4 different cells each i run my macro sample data: Sub Insert() '...
Excel fiasco
I'm trying to auto create salary slips. I have a list with the information ect of the employees and have created the first payslip in the next sheet. ...
Conditional fomatting with range values
Here is my scenario: Column A has ranking from 1 to 5. Column B has zone/ classification from 1 to 7. Column C has ratings. These ratings are bas...
Combine rows using condition
Hi, I Have spreadsheet like this: Col A Col B 02003SM TB4 02003SM TB5 02006SM TB1 07017SM C461 07025SM C462 07128SM C479 07139SM ...
Conditional formatting multiple rows in excel
Hello Community, I need to create conditional formatting in Excel separately for a number of rows (e.g. high lighting highest and lowest values in ea...
Varible column (a,b,c etc) within a formula
I have a sheet 1 with raw data inserted. Each Sheet 2,3,4 within the same workbook has another spreadsheet that needs to read the raw data from sheet...
Help with a formula please!
Hi. New to this but it seems like a good forum. I NEED HELP PLEASE! I will try to explain my dilemma. In Excel if there is a specific day/date in a ce...
How to learn macros
Dear All Please suggest how to learn macros
Conditional formatting with multiple drop downs
I have a spreadsheet that has multiple drop downs. I'm trying to get Excel to highlight errors made in one column if a particular option is chosen ba...
Copy worksheet misc data in sheet 1 to new row in master sheet 2
Hi, I'm a complete newbie to Excel macros.. Sheet 1: Sheet 1 is my work sheet where i manipulate data. Upon completion of fine tuning the data, ...
Vlookup across multiple values to return only one
Bit of a long one to explain, but im sure there is a quick answer. I have a barcode scanner which is used to input data. This data goes into column...
Need help with sorting and copying from multiple worksheets
I need to copy a report from several sheets, Workbook 1 First i Have a report Sheet with a fixed header in the first several rows A Sequence of O...
If...allow text
A1 has a drop down list with HM01 and Off Spec, B2 = text depending what is selected from the list in A1. So B2 =if(A1"HMO1",'DISHCODES'!B3).....whe...
Compare 2 lists of names
Hello, I have 2 lists of names with last name and first name. However, one on list there is a comma and a middle initial on the other there is jus...
Auto populate sheet 2 basis data on sheet 1
Hi I have raw data on sheet 1 one of the column is "group name". Data is related to 150 groups, however I need data for only 24 groups. Is it possi...
Sum ifs function in excel
SolvedIs it possible to have a criteria range for a range of dates and have it add for a date less that the specified criteria? 11/1/...
Invoice no
SolvedHello, After Long period i came here to ask some thing to my friends that is i want to raise the invoice as per the cell value i have given some e...
How to change text in a cell based on another cell
I am working on an asset tracking sheet and I want to use conditional formatting to change the text in one cell based on the text in another. Refe...
Worksheet problem in excel 2003
I have a worksheet that I have a yes,no drop down menu. I then have 4 cells below that, that currently have conditional formatting to them that change...
Delete worksheet from list macro
Hi All, I am trying to delete some worksheets within a workbook from a list containing the names of worksheets to be deleted, listed in column B2:B...
Bank reconciliation
SolvedHi Am trying to automate bank reconciliation Any ideas as what the code is. In the work book i have 12 worksheets for receipts and 12 worksheets ...
Tally problem
dear all i want to create a bill in tally erp9 and when i enter the date suppose 24/11/13 then cursor can't go on next text and if i enter 2/11/13...
Column combinations
I have a table that has numerous columns. I need to calculate the total number of units used when the combinations of Cells A and B Appear. For exampl...
Adding a day to the date
I need a formula to add a day to the date. For example, today is Nov 22, 13; I want to add one day to have Nov 23, 13 in another cell. I saw a number ...
Vba macro to calculate values in cell(s) from multiple sheets
Greetings to the greatest trouble shooting team we have around, I am stuck in a situation where I have multiple sheets in a workbook, say this work...
Macro for linking two workbooks, comparing one document id with
SolvedHello, I need help in creating a macro for linking two workbooks, comparing document ID's in one workbook with the status of that Document ID's in ...
Skip a value
suppose a1 a2 a3 = john,michel, robert, respectively and b1,b2,b3=10,9,10 then from values of b cell i wanted to print name in g cell who have corres...
Comparing multiple columns for list of items
Dear experts I have list of names with multiple words in column A List of names with multiple words in column B List of names with multiple w...
How to delete a line from excel cell
SolvedDear all How to delete a line from every cell in a column??
Running a macro permanently
Hello, I have copied and edited a Macro to a workbook to save a certain cell as the file name. The problem is that you have to click on Macros fin...
2010 if function help
SolvedI'm looking to combine a IF function for one cell with a date function in another. The aim is to have something like this: =IF(A1=2099,"James Jones...
Conditional statement
i want to create a conditional statement to formulate below if A1=>0 then equal the value, then if it is blank then get the value or number from A2...
Need a cell value to change automatically based on a future date
Hello, I need to submit weekly reports on the number of students in classes (currently enrolled, graduated, etc.) The problem I have is that sometime...
Iam trying a lot to make the formula succes, but its not helping
SolvedHello Ther!! Iam trying a lot to make the formula succes, but its not helping all people ther Kindly help me on the below formula it gives resu...
Formula to move appropriate data to new sheet
Hey everyone, I wanted to attach my spreadsheet but no such luck. Essentially, I have a spreadsheet with people's certifications. I have one col...
