The discussions
Auto copy/paste data if criteria (same value in 2 cells) is met
SolvedHello from Barcelona, just signed up ... my first question ... excited :) I have 2 tabs. Tab 1 shows in column B the employee number and in col...
Duplicating data from one line on sheet 1 to sheet 2
SolvedHello, I'm looking for help, I have data in one box on sheet1 one that when I update that data I would like for it to automatically change in a bo...
Colour changing in rows determined by text in 2 different cells
SolvedHello, i would like to change the colour of a number of cells in a row if column P contains any text, however the colour it changes to depends on the...
Transfer data between sheets in excel
SolvedHello, This involves an attendance sheet. A tab for each month with columns for weekly attedance and a total for the month and a summary tab contai...
Compare values of two separate sheets and returning value
Solved/ClosedHello, Configuration: Windows 7 / Chrome 43.0.2357.81 I'm currently working a spreadsheet trying to match values from Sheet 1 Column B with...
Recording macro to duplicate page and rename to numeric value
SolvedGood day I am trying to record a macro that duplicates a page and renaming it to another file name but need to follow in numeric order. I have a...
Need to find a data in a column and copy below cell data or add
SolvedHello , Please help me to solve this, it will be very grateful column A column B column c 1......................... .........2 2.................
Count days in excel
Solved/ClosedHello, How can count dates between 2 cells in excel, 1jan - 2jan to count as 2 days. with =NETWORKDAYS(A1,A2) not count the weekends. Thanks F...
Combine of column
SolvedHello, 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
Solvedplease, 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...
Copy paste macro needs tweak
SolvedHello, I'm new to VBA, and would appreciate any help with this Macro. It copys the mouse input, but overwrites the last paste. I need it to (after I...
Conditonal format a because of values in another cell
SolvedHello, 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
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
My email have been deleting without reading
SolvedHello, I keep getting emails saying that some emails have been deleted without being read. The message below is typical of what I am seeing is: ...
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 ...
Outlook repair tool for .pst files
Solved/ClosedHello everyone, I'm not really sure what happened, but this morning, one of my pst-files was missing and for another I got the error: "Errors have ...
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...
Frequent missing emails inbox (blank)
SolvedHello, Please assist me , why my email in my inbox goes missing, this is my 5th time it happen again. Once my inbox emails goes blank, I need to s...
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...
Find serial number and input average value into adjacent cell
SolvedHello, I'm trying to find out if there is a way to do this. i have a list of 15k serial numbers. several of them repeat because the value vary. i ...
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...
How to apply conditional formatting in excel
Solved/ClosedHello, I need to apply conditional formatting to range H1:H10000 based on corresponding values in another column, G1:G10000. If the value in t...
