The discussions
Using if formula for dates
hello, i want to make a sheet for my job to track the allotments, i want it to count the days allotment sent for signature till it is back from sig...
Data validation if then
Hello, I have a "Yes" or "No" data validation list in cell C1 and manual input cells in D1, E1 etc. I would like to create a code that says (If C1...
Search,compare,update,indicate data in excel sheet (macros vba)
Q) 1 core excel sheet with 10 to 15 thousands rows and around 150 columns. Another targeted sheet to be completed with using VBA which content same 10...
Help with a school directory
Hi all, I am creating a school directory. My columns are Last Name, First Name, Father/Mother, Phone, Email, Address, Zip, Teacher, Grade. I ha...
Urgent,,,custom database from one entry sheet to multiple sheets
Hello, Thank's in advance...for helping in my problem I enter data in a sheet and based on that i print few page report that contains that variable...
Enable macro security via macro or automatically
Hello, Dear Friends i m not good in english so sorry in advance for bad english. but i need to enable macro automatically when worksh...
Transfer data from multiple sheets to sheet 1 based on criteria
Hello, I am creating an estimating workbook where I have multiple product sheets that list qty, part#, description, volume, lbs, list price & disc...
Concatonating within commands???
SolvedOk - I know I said no more scripting, but ... Im still with Excel (VBA) macros and trying to find a way of inputting data from a html sheet (stored...
Why the type mismatch error?
My question is in the comment in the code: Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next If Target.Cells.Count > 1...
Format row based on text length
Hello guys, Can you pls help me? I am beginner in VBA and I need to sort out one macro. I have table and need to have highlited row with color, bu...
Using if condition with date function
Hello, Sir, i am using if condition with date function. my question is that I have two date in two column. dates are different. if 1st date col...
Step by step instructions
Hi everyone: Following policies is a difficult thing because it is open to interpretation. I was wondering if it is possible to create a prompt in...
Get month name and year from date
Hello, how do I can convert the date in to month name and year ex. 01/05/2015 , I want to get month name as May and year 2015 pls help me, b...
Change date automatically on the sheets
Hello, I have a document in Excel, and has 5 different pages; all of them have the date on top. I need to know, how I can set up the formula or th...
Help msb (microsoft visual basic) code for an excel macro button
Hello, I am trying to create a macro to help the input in a complex excel file. I have created several dropdown menues to choose from a list: ...
Comparing columns and returning value
SolvedHello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: C...
Word "false" kept on appearing? =if function
Solved=IF(ISNUMBER(A1),IF(ISNUMBER(B1),IF(ISNUMBER(C1),IF(AND(A1,B1,C1),SUM(A1,B1,C1),"Incomplete Data")))) How is it happen that I put "Incomplete Data"...
Conditional formatting
Hello, I'm trying to write a conditional format formula populating one cell (column of cells) based on the text content of cells in 2 other column...
Date range to division
Hello, we capture birth date as date and we would like to convert to division Month/Year 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006...
Sumproduct based on relative cell
SolvedHello, I can use sumproduct based on information contained in the same range of rows of a column adjacent to it, but I can't figure out how to do ...
Macro to autogenerate sheets based on unique values of a list
Hello! I would greatly appreciate if anyone could help me with a macro. I have a number of populated rows in one sheet (Sheet A) and one of the co...
Copies and saved in a different column
Hello, can you guys help me with this. I want to input a data in cell A1, then it automatically copied into cell B1. then if I input again anoth...
Copy row from sheet 1 to sheet 2 with formula
Hello, i need to copy a row from one sheet to another with formula and keep updating the data in sheet 2 every time i change the data in sheet 1 ...
Vba for copy from sheet 1(form) then paste to sheet 2(database)
Hello, newbie here. Please help me by giving a vba that could automatically make a database. I have a form(sheet1) detailed with various inf...
Stack range of data to next empty row in other sheet
SolvedHello, I have a set of data in Sheet1 Range("D24:D50") and Range("AC24:AC50") would like to be copied and paste special value to Sheet2 Column A a...
Macro that kills a macro when a new workbook is opened.
SolvedHi All, I am still new at excel macros. I am using a command button to copy all work sheets in a workbook then pasting just the values into a new w...
Nested if statement...
Hello, Can anyone find any errors with this formula. I know it will never return a "N" because the vlookup will terminate anything that doesn't m...
Auto fill
Hello, im looking for a formula when i add a"XXXX" word to a cell K7 it takes the value of another F7 and auto populates to another H7. so "WOR...
Excel, how to use macros and conditioning.
SolvedHello, I have been looking up how to use excel to help sort data but ran into a few problems. First I have searched how to delete a row with certain...
Microsoft excel conditional formatting
Hi, I'm trying to make a cell display a number based whether or not another cell contains the words, "Sentinel", "Ramsden", "Goulding", or "Riverda...
Input mask
Dear Sir/Maddom. Hope to be fine and doing well. first of all i am thanks from your services in the filed of IT. I am working in Telecom Comp...
Transfer comments
Hello, Is it possible to transfer comments from one cell to another on a different sheet or workbook? I am able to transfer the contents of the ce...
Using 'rept' inside 'if'
SolvedHello, i want to do a rating..example.. Artist Rating(numerical) Rating(graphical) akon ...
Date formula
SolvedHello, Can someone please create a formula for these numbers to change to a date. 152030355A, the answer should be 7/22/2015. The first two nu...
How to enter a row when an "if condition" is met
Hello, Would like to know how to add a row in a different sheet when an "if condition" is met. To illustrate, I have the following columsn in s...
Compare worksheets return third result
I Have two worksheets a) Warehouses Combined - this list all codes a to z b) Suppliers - list all suppliers with discount per supplier. Warehouse...
Populating companies sheets from mastersheet
Hello, Could someone help please. I have a excel file with a master sheet which contains invoice companies. The are alphabetical ordered. Bu...
Assigning values to a row
Hello, I have a row with descriptions in the adjacent cell for example a1 sam b1 happy a2 Jessica b2 sad a3 max b3 angry then in row c it...
Fetch data
Solvedfist sheet Leader id Brand Status product S001 Maruti complete Maruti 800 s002 Toyota complete xyz s003 Maruti complete swift desire s004 Nisha...
Comparing 3 columns
Hello, Please help me get the correct formula for this: RETURN RED IF D1 lower than D2 and lower than D3 ...
Problem in comparing rows
Hello, I want to compare two adjacent rows and highlight the difference; then I want to apply this to entire worksheet so that all adjacent rows (...
Multiple if and functoions
Hello, I'm trying to write a function for a cell which refers to a date in another cell - which if it is between 01/01/1994 and 31/12/1995 the cell ...
Find text and add two different texts next to cell
Hello, I have a sheet with contractor names(sheet1) on A1 and I have a separate sheet (sheet2) with contractor names (A1), personnel assigned to t...
Percentage
Hello, I have Rs. 1.3 million divided to 35 peoples. Sô you can help me, i mean 1st prize is high, 2nd low prize, 3rd is more low. Please guide me f...
Conditional format restrictions
Hi. Need a little help with conditional formatting. Basically need to build in a excel spreadsheet a rule where conditoinal formatting will pick up...
Conditional formatting based text in another cell
Hello, I want to conditionally format the cells in one column (in my case) D, if the cell in the same row but in column K contains one particular ...
Creating new spreadsheet based on column - macro help!
Hello, This is my first time trying to use a Macro, so please bear with me. Anywho, I am using Excel 2007, if that helps. I have a spreadsheet th...
Date formate in formula bar
hi Tried to change the date format in the formula bar but its not taking for ex: 29/05/2015 is showing as MM/DD/YYYY in formula bar but in sheet its ...
Help with returning multiple values
Hi, I have 3 columns in Excel. I need to search value from Column A in Column B and return value from Column C. For example I need to find 004 f...
Looking up and adding the values fixing different criteria
Hello, "A column" the name of items such as Tiles, Pipes, Tables etc (many times repeated) "B Column" the size of each item such as 10mm, 20mm, 50m...