Excel Forum - solved topics
- Solved
-
combine of column Solved/Closed
Hello, How can we show value of more than two column in a single column but in two rows. please reply at the urgent.
-
Comparing two excel worksheets Solved/Closed
please, I need a macro code that can actually compare two worksheets and flag up the differences using same color to show the dissimilar rows. Be...
-
conditonal format a because of values in another cell Solved/Closed
Hello, i am trying to figure out how i can format a cell to show green when above a figure and red when below the figure simple i know but here co...
-
Function Formula Date and Text Solved/Closed
Good 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hi 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 Solved/Closed
Hi 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 Solved/Closed
Hello, 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 Solved/Closed
Hi, 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 Solved/Closed
Hello 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/Closed
I 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 Solved/Closed
Hello, 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 Solved/Closed
Greetings 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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? Solved/Closed
Want 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 Solved/Closed
Hello, 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 Solved/Closed
Ok 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 Solved/Closed
solved 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... Solved/Closed
Dear 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 Solved/Closed
Can 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 Solved/Closed
Guys, 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 Solved/Closed
Hi 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 Solved/Closed
I 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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.... Solved/Closed
I 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 Solved/Closed
Hello 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...
-
Macro to rename sheets based on cell value in another sheet Solved/Closed
I am attempting to rename 5 sheets in a workbook based on values from a sheet titled Raw Data Information. The first sheet should be named based on '...
-
Excel Filter/Macro Solved/Closed
Hello, 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 Solved/Closed
Hello 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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...
-
Excel help Solved/Closed
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 date to the far ri...
-
Hello, where am I going wrong with this formula? Solved/Closed
=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 Solved/Closed
Task 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 Solved/Closed
Hi 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 Solved/Closed
Hello, 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 ...
-
Uniques identifiers Solved/Closed
Hello, I have an excel spreadsheet with twelve months (5 columns each) with names and product type for each month. Each month can vary by name but...
-
Excel 2013 has stopped working Solved/Closed
Hello, 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 Solved/Closed
Hello 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 Solved/Closed
Greetings, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Please 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 Solved/Closed
Hi, 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...