Excel Forum
-
time calculation formula Closed
Hello, what is the formula to calculate time between two different dates and times Thanks
-
date function Solved/Closed
i want to know how to create a date series in an excel.. for eg if i enter the date in A1 as 1.12.2013 how to create automatically in the A2 as 2.12...
-
list dependant drop down menu Closed
Hello everyone, I have a worksheet with two columns (A and B) of data. I'm trying to populate a second worksheet (column A) using a drop down box t...
-
Applying conditional formatting to multiple cells Closed
Hi all, I've actualy already done what I needed to do, but as this is a very sensitive document I would like to know WHY it worked, just to be sure...
-
Formula to highlight cell based on data value over 2 cells Closed
Hi Guys and Girls, I'm am trying to improve a current spreadsheet I'm using where I am collating movement times in and out of a location. I want...
-
Conditional formatting to colour cell based on text in another Closed
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 Closed
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 Closed
HI All, we have mandatory annual training requirements and I have a spreadsheet which records the date training has been completed. we have seve...
-
Formula Closed
i
-
Remove duplicates and merge rows Closed
A B C D E 2000 Mary 123 street1,street2 2000 James 123 street2 2000 Mary 123 street1 2.8...
-
Date formula Closed
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 Closed
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...
-
Writing a macro that copies data from multiple worksheets to one Closed
I have a workbook that has over 580 different worksheets, and I need to copy a certain section from each worksheet onto a "master" worksheet. The data...
-
Find and Extract text from a cell content Closed
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...
-
Nested If logic is not working Closed
Please tell me what's wrong in below formula: =IF((AND((HLOOKUP(A1,$A$1:$F$2,2,0)="Yes"),(HLOOKUP(G1,G1:L2,2,0)="Green"))),"Compliant",IF((AND(AND((H...
-
Date Function using if_ else statement Closed
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 Closed
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. ...
-
How can I add blank line to the record using macro Closed
Hi There, I am having difficulties with macro, I would like to have macro which checks the records in each row and if they do not match than it add...
-
Returning Text from Excel Closed
I have customer names located in Column B Rows 12-56; I have dates that they returned letters to me in column J rows 12-56. My question is what is...
-
how to auto copy/past info from one cell . Closed
Hi , I am trying to create a sheet that when i press a name it will ask me to where i want to copy it in a different sheet. For example If i pre...
-
Transfer data between sheets in excel Closed
I currently have a sheet that sorts my data by customer, such as Part#, Qty ordered, Qty Shipped, Due date and so on. I would like to be able to trans...
-
Script :Scan Excel Sheet for Validity Date & Send Reminder Mails Closed
Hello, I have a training manager in Excel that has different training records of about 100 employees. Each training has a certain validity. The re...
-
Excel IF argument Closed
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 Closed
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 Solved/Closed
Hello, 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...
-
Transfer data from one workbook to another. Closed
Hello, I am having a problem with the getting the form to transfer data. The post previously placed on this forum is not resolved. Please help me ...
-
Excel VBA Closed
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...
-
copy rows with date as criteria Closed
Hi i have a workbook with 3 sheets. sheet 2 has data that changes constantly and column A has the date entered when the change was made. sheet 3 ne...
-
Macro to sort worksheets by a value in a cell, least to greatest Closed
I need a macro to sort my worksheets by the value in their cell "J65", least to greatest. The formula in cell "J65" is: =Sum(J35-H62). It is a USD...
-
how to check replicated data Closed
Hello, I have a set of data ranging from column A to AW. They are shown in several sheets and there are 289 items in each sheet. Since the data wa...
-
Change Cell Data by Format Conditioning Closed
I need to how to used format conditioning to change a cell's data Example If Cell A1 = "F", then A3 background is Green (this is normal Format Con...
-
Combine Multiple Rows into One Row Closed
Hello, I am in need of major help with a large spreadsheet that have over 500 rows. I need to take multiple rows and combine them into one row. ...
-
Comparing columns Closed
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 Solved/Closed
Hello, I have source data in Excel looking like this: CustomerID SalesMonth SalesAmount 12345 Jan 15...
-
Print if Statement ??? Closed
I would like to build a inventory spreadsheet that prints a requisition. ie: Qty reuired : Stock # : Description : etc So the list is 4-5000 i...
-
Excel If statement for dates Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
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! Closed
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 Closed
Dear All Please suggest how to learn macros
-
Conditional Formatting with Multiple Drop Downs Closed
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...
-
Macro to create Worksheets from a main file Closed
Hey guys, Nice work going on here,have been a regular follower. I seem to have come across a problem with my MACRO for excel. I have a Excel ...
-
Copy worksheet misc data in sheet 1 to new row in Master Sheet 2 Closed
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 Closed
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 Closed
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 Closed
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...
