The discussions
Function formula date and text
SolvedGood day I am looking for help with a function formula PLEASE. Example Decleration Start Date 2016.02.17 Last inv_ Inventory_ Decl frm 1...
Spellnumber vba in excel
SolvedHello, I alreadly use spellnunber but the problem is it does not convert incorrect for my currency. Present Situation =SpellNumber(1,100,000) =...
Conditional formatting on an entire row
SolvedHello, I want an entire row to turn red, only when one cell in that row is less than 0. I tried highlighting the whole row with the formula =A12
Copy rows from sheet 1 to sheet 2 if rule is met
SolvedHi I have a contact list I need to extract data from. Full contact list is sheet 1 Names are in A2:A12948 Internal phone numbers in B2:B12948 ...
Formula
SolvedHi please I am looking for a formula to get difference between 2 sheets example sheet 1 sheet 2 ndc quantity nd...
Need cell value copy to defferent -2 work sheets within a excel
SolvedHello, hi all i need to maintain a MIS on daily basis. in this, i need to enter same values multiple times on individual worksheet within a excel...
Excel function to check neighbour cells match for all
SolvedHi, I need to check if (each) cell in column A is having a match in column B, Example as below: Column A is phone numbers list, column B is mes...
To change cell value automatically
SolvedHello everyone here, this is my first question in this forum. In Excel 2013, If I type 1 in cell A1, then it should automatically change as Apple in s...
Help with if statement / vlookup (i think)
Solved/ClosedI work for a planning company where we submit lots of applications to do with housing. Different application types have different lengths until decisi...
Help w/if statement
SolvedHello, Let us say I have 3 columns, column A is home email, column B is work email, and column C is other email. On column D, I want to return th...
Macro help
SolvedGreetings fellow users! I am in need of some assistance: Recently, I have created a macro in which I need to copy 100+ variables from one sh...
Vba single click to get current date
SolvedHello, I'm brand new to VBA and the code that bhargav posted on Feb 6, 2013 10:48AM worked perfectly to get current time in a range of cells with ...
How to compare two excel sheets with varying data
SolvedHello, Before I start let me just say Thanks in advance. So I am looking for an ongoing updated answer. Every 3 months we receive a new price lis...
Cell = yes or other text return value
SolvedHello, I'm using IF statements to return a value for the specifc answer supplied for the question and then adding up all the questions for the t...
How to check % value in excel and macro using vbscript?
SolvedWant to check a cell with % percentage format matches the value in Vbscript code. Sub ChangeColor() Dim lRow Dim myVar lRow = Range("AC" & Row...
Formula to copy rows a set number of times
SolvedHello, I have a delivery manifest that shows the amount of products coming in, descriptions etc. that we use to produce barcode labels. Unfortunatel...
Vba using subroutines - help please
SolvedOk guys, I have a problem (well more than one, but Im not sure I should mention those on this forum!). Im in the process of writing an Excel macro ...
Date format nightmare
Solvedsolved with this: Because it is not a date to excel. 1. Select the column in which there was date 2. Goto data and choose text to column 3....
Excel sum value...
SolvedDear I would like to know how to do the below mentioned formula I have tried but not resulted. Excel - Sum value in column when cells contains ...
Formula help
SolvedCan someone please help me with this formula =IF(G2="1",VSC410, IF(G2="2",VSC450, IF(G2="3",VSC470))) What i am trying to do is : if G2 has the...
Conditional formatting based on year
SolvedGuys, I come again cap in hand with another plea for help on a sort of finished project, but I want to make it better. I have some conditional f...
Extracting rows from excel
SolvedHi there, I have an excel sheet with a very large data. I want to extract different rows and write them in to different sheets of the same excel (or ...
Column to vlookup
SolvedI am trying to write a formula that will give me the value in a cell, it needs to come from two sources. I must be able to locate the column based on ...
Disable a cell in excel using vb code
SolvedHello, I am looking for a VB code to disable a cell based on the value of another cell in excel. Example:- Need to disable Cell B1/C1/D1 based o...
User friendly code for admission no
SolvedHello, I would like to request to Code for Admission No Range is started from B11 to B510 If user enter a123456789 or a-123456789 it always conv...
If one cell g4 has value 12345 then cell f4 will have....
SolvedI need help with a basic excel formula. Please :) If cell G4 equals 12345 then cell F4 equals USXX but also if cell G4 equals 54321 then cell F4 w...
Auto copy row from one sheet to another via info in first cell
SolvedHello everyone, hope you all had a great New Year. I am in the process of exporting a BOM out of Inventor and then opening it with Excel. Once I ha...
Excel filter/macro
SolvedHello, Thank you in advance for any time/help you can offer! I'm working on a contact list in Excel and I need to be able to filter my contacts i...
Columns & rows help
SolvedHello all, In short, here is what I need help doing: I would like to take 15 items in one column and transfer them into a row in another spread...
Formula if you have credit in one column, debit in next column
SolvedHello, what is the formula if you have credit in one column, debit in next column and balance in 3rd column. Many thanks R Horner Configurat...
How to re/name a cell if another cell contains x
SolvedHello, Apologies if this is a simple question but having some trouble figuring it out. I have say 1000 rows of data and I need to label them all...
Strike through when entering date
SolvedHello, In excel I have a row of information in six different cells. The first cell and last cell have a date format. When I enter the last d...
Place new code to working code
SolvedHello, I would like to request that some line of code (marks as bold) I have to place in the Working Code which is given below that I cannot figure...
Hello, where am i going wrong with this formula?
Solved=P10+ROUND(SUM(O10*O10*M10*0.7854)/10000,3),IF(M10>11.8,"CNB",P10) The final result in cell AV10 must be the value in cell P10 plus ROUND(SUM... [H...
I want to build intelligent excel
SolvedTask is: For example I have list of different fruits in cells in separate rows Apple Pear Plum I want the data to be copied to third cell,...
Extracting multiple date from master sheet to new sheets
SolvedHi I run a sports tipping site and I want to extract data from my master sheet to make other sheets. I.e in sports cloumn I have multiple sports and w...
Specific price depending on the words in 2 cells? please help
SolvedHello, I am using excel 2008 for Mac, i need help with the following: example: A1 has a drop down box of 3 choices, apples, pears and peaches ...
Excel 2013 has stopped working
SolvedHello, Every time I'd open Excel 2013 under Windows 8, it would crash instantly, leaving me a message: "Excel 2013 has stopped working". I looked ...
Find data and copy dynamic range
SolvedHello all, I would like to find text in one column and copy the range values which is adjacent to the text searched. I've attached the sample...
Resize the range
SolvedGreetings, I would like to resize the range without keeping the starting position. I've attached the image In the above example, while usin...
Using the if function for dates
SolvedHello, I am trying to figure out in Microsoft excel 2010 the appropriate IF formula to use. I am trying to calculate the number of working days th...
Help writing a if formula
SolvedHello, I need to write an IF formula for excel. Cell A2 will either say ''receive'' or ''deliver''. This formula works IF(A2=''receive'',1,2);...
Help with a formula
SolvedPlease help !! Looking to calculate totals based on the following... Entering the formula in the following field K4 I have rows (B4 thru B18) e...
Formula to add 1 with if statement
SolvedHi, Here's the breakdown of what I'm trying to do: The formula is going in cell 'Y28' and I'm attempting to do two different things: 1) I want...
Not pasting values in excel file
SolvedHello, I would like to know that I have a Excel Macro Enabled File. it has macros, sheet vba code, modules and user forms code and no merging...
Coping formulas to next row using a macro
SolvedHello, I am trying to make a macro to copy a formula to the next row in a spreadsheet. Then paste the absolute values back into the original row. I...
Add a restriction to a column
SolvedHello, Can you please help me out, I'm stuck. I have to restrict the numbers 03 in a column that must contain 11 characters ( the number should st...
Conditional formatting through macro
SolvedHello, I would like to request that how Conditional Formatting would apply through Macro and the Conditions are Range is E11 to E510 if Colum...
Sum values from one column if another column equals x
SolvedHello, Is there a formula that can calculate the sum of cells from one column if the value in another specific cell equals x (or not blank)? I tried...
Transfer worksheet
SolvedHello, How can I transfer an excel worksheet into another excel file. And when transferred I won't have to modify anything. Right now i'm cutting a...
