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...

1 reply Last reply on 26 Aug 2015 by
ac3mark

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...

1 reply Last reply on 25 Aug 2015 by
xpcman

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...

2 replies Last reply on 25 Aug 2015 by
MAY7

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...

1 reply Last reply on 24 Aug 2015 by
xpcman

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...

1 reply Last reply on 24 Aug 2015 by
xpcman

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...

3 replies Last reply on 24 Aug 2015 by
TrowaD

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...

1 reply Last reply on 23 Aug 2015 by
vcoolio

Concatonating within commands???

 Solved

Ok - 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...

4 replies Last reply on 21 Aug 2015 by
BrianGreen

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...

1 reply Last reply on 21 Aug 2015 by
xpcman

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...

3 replies Last reply on 21 Aug 2015 by
vcoolio

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...

3 replies Last reply on 21 Aug 2015 by
vcoolio

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...

7 replies Last reply on 21 Aug 2015 by
nnavarro

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...

1 reply Last reply on 21 Aug 2015 by
vcoolio

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...

3 replies Last reply on 20 Aug 2015 by
Mazzaropi

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: ...

5 replies Last reply on 20 Aug 2015 by
RayH

Comparing columns and returning value

 Solved

Hello, I have an Excel spreadsheet where I want to compare values between two columns and return the value from another column. EX: C...

14 replies Last reply on 20 Aug 2015 by
TrowaD

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"...

2 replies Last reply on 19 Aug 2015 by
InfoTech04

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...

1 reply Last reply on 19 Aug 2015 by
ac3mark

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...

1 reply Last reply on 19 Aug 2015 by
ac3mark

Sumproduct based on relative cell

 Solved

Hello, 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 ...

2 replies Last reply on 19 Aug 2015 by
BrianP

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...

1 reply Last reply on 18 Aug 2015 by
TrowaD

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...

1 reply Last reply on 18 Aug 2015 by
TrowaD

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 ...

4 replies Last reply on 18 Aug 2015 by
Mazzaropi

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...

1 reply Last reply on 18 Aug 2015 by
vcoolio

Stack range of data to next empty row in other sheet

 Solved

Hello, 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...

4 replies Last reply on 18 Aug 2015 by
Milli

Macro that kills a macro when a new workbook is opened.

 Solved

Hi 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...

5 replies Last reply on 17 Aug 2015 by
ac3mark

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...

2 replies Last reply on 14 Aug 2015 by
M.Hanzla

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...

1 reply Last reply on 13 Aug 2015 by
Mazzaropi

Excel, how to use macros and conditioning.

 Solved

Hello, 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...

2 replies Last reply on 13 Aug 2015 by
Matt

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...

3 replies Last reply on 13 Aug 2015 by
Mazzaropi

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...

1 reply Last reply on 13 Aug 2015 by
TrowaD

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...

1 reply Last reply on 13 Aug 2015 by
TrowaD

Using 'rept' inside 'if'

 Solved

Hello, i want to do a rating..example.. Artist Rating(numerical) Rating(graphical) akon ...

2 replies Last reply on 13 Aug 2015 by
dinu

Date formula

 Solved

Hello, 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...

9 replies Last reply on 12 Aug 2015 by
Judy

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...

1 reply Last reply on 12 Aug 2015 by
vcoolio

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...

1 reply Last reply on 11 Aug 2015 by
xpcman

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...

1 reply Last reply on 11 Aug 2015 by
TrowaD

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...

1 reply Last reply on 10 Aug 2015 by
Mazzaropi

Fetch data

 Solved

fist sheet Leader id Brand Status product S001 Maruti complete Maruti 800 s002 Toyota complete xyz s003 Maruti complete swift desire s004 Nisha...

3 replies Last reply on 10 Aug 2015 by
vcoolio

Comparing 3 columns

Hello, Please help me get the correct formula for this: RETURN RED IF D1 lower than D2 and lower than D3 ...

3 replies Last reply on 8 Aug 2015 by
Mazzaropi

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 (...

1 reply Last reply on 8 Aug 2015 by
venkat1926

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 ...

1 reply Last reply on 7 Aug 2015 by
Mazzaropi

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...

1 reply Last reply on 6 Aug 2015 by
TrowaD

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...

1 reply Last reply on 6 Aug 2015 by
TrowaD

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...

3 replies Last reply on 6 Aug 2015 by
TrowaD

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 ...

2 replies Last reply on 5 Aug 2015 by
y88y

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...

9 replies Last reply on 5 Aug 2015 by
venkat1926

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 ...

1 reply Last reply on 3 Aug 2015 by
TrowaD

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...

3 replies Last reply on 3 Aug 2015 by
TrowaD

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...

1 reply Last reply on 3 Aug 2015 by
M.Hanzla
Results 2301 - 2350 out of a total of 7,066