The discussions

Excel forum within a range

 Solved

Good day I am looking for a formula PLEASE. Example Column A, Column B, Column C, Column D, Column E, Column F No, Start, End, ...

2 replies Last reply on 24 Apr 2017 by
Gerberreinette

Need to delete columns based on column header

 Solved

Hello, I need to have an macro which will delete the columns from my excel based on the Column header. Exsample: I have the columns, Name...

7 replies Last reply on 21 Apr 2017 by
topazfae

Auto generation of code

 Solved/Closed

Hello, we facing issue in the auto generatation of vcode. it asking CUSTOMIZE HERE TO SUIT YOUR NEEDS . what code to be fill for this? kar...

Last reply on 20 Apr 2017 by
TrowaD

Excel - a macro to create new workbook and copy data

 Solved/Closed

In the example below, I want to copy Column A starting from row 2 ie: "Age" till the value available ie: "Code and column B starting from row 2 ie: "2...

Last reply on 18 Apr 2017 by
TrowaD

Excel - macro to create multiple sheets

 Solved

Hello, I have 16 sheets in excel. each of those represent a location (office) and they need to pull information from sheet1. This is for credit ...

5 replies Last reply on 14 Apr 2017 by
vcoolio

Comparing columns and returning value

 Solved/Closed

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

Last reply on 14 Apr 2017 by
kittu

Import .pdf ...?

 Solved

Hello everybody, Thanks so much for this thread, it has been extremely helpful! I have used the basic code suggested by Trowa, and it works for...

2 replies Last reply on 12 Apr 2017 by
RickRoll

Formula

 Solved

I need some help with a formula, everything I try just doesn't work. I usually don't have this problem with Excel today is my day. I have a colum...

2 replies Last reply on 6 Apr 2017 by
ehmetcalf

Conditional formatting based on two cell values

 Solved

Hi There, I'm using Excel 2016 and am trying to apply a conditional format that searches cells in column A for the text "*DEMO*", and also has a c...

3 replies Last reply on 3 Apr 2017 by
Mazzaropi

Copying cond. format for entire row based on 1 cell to other row

 Solved

I have conditional formatting for an entire row based on the value of 1 cell. For example: cell value>$A$2 = red, cell value

3 replies Last reply on 3 Apr 2017 by
Mazzaropi

Drop down lists

 Solved

Hi All, i have a drop down list in excel and the data for the list in a sheet in the same workbook. If I copy the spreadsheet with the list to anot...

3 replies Last reply on 31 Mar 2017 by
Mazzaropi

Removing false value

 Solved

Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(G23=0,P15/Sum(D11:F11,IF(G23>0...

5 replies Last reply on 30 Mar 2017 by
ac3mark

Copy rows to other sheets based on value in column

 Solved

All, I have an Excel file with three sheets: Sheet1 contains all my data. Sheet2 named "MACH" and Sheet3 named "FAB" I am looking for a way with a...

6 replies Last reply on 30 Mar 2017 by
vcoolio

Trying to create a multi-column formula.

 Solved

Hello, I need help making a formula. I will do my best to describe. The letters (A-I) refer to separate columns. A-B=C to be divided by D the res...

9 replies Last reply on 28 Mar 2017 by
TrowaD

Excel problem

 Solved

Hello, I want a formula in which, If I enter the number in cell, the name of that number should appear in adjacent cell. Ex: Emp No Name 1 ...

3 replies Last reply on 22 Mar 2017 by
Mazzaropi

Highlight one value in a dropdown menu of three responses

 Solved

Hello, I have a template where we are asking for responses with a drop down that includes Y, N, and N/A. We want to highlight all N answers in yell...

2 replies Last reply on 17 Mar 2017 by
MeganNolf

Code to move rows into another sheet based on certain values

 Solved

I'm having trouble figuring out how to do something! I have a sheet (Sheet1) with customer details on it (columns A-D will have data in). I want to be...

1 reply Last reply on 17 Mar 2017 by
vcoolio

Search a list of names at one time in excel

 Solved

Hi, I have a huge list of names (list A) which I need to search with another list of names (list B) and see if any name in list A is in list B . Is i...

8 replies Last reply on 8 Mar 2017 by
priya_mbial

If a cell contains any text then add a value (with dates)

 Solved

I am looking for help with a formula that will allow me to add up the number of times a certain date is a Monday. I am using =COUNTIF(A1:A30,"*Monday...

7 replies Last reply on 7 Mar 2017 by
ryannordgren

Macro to increase a cell reference by 11

 Solved

Hi everyone I want a macro that on open will increase the cell reference in a cell by 11 each time the book is opened i.e. Cell C18 has =Sheet2!H2. T...

6 replies Last reply on 7 Mar 2017 by
YaneyYan

Conversion of dob to full words

 Solved

Hello, Configuration: iPhone / Safari 4.0 I want to to convert dob to word like 5/6/2014 to fifth June two thousand fourteen please tell me...

9 replies Last reply on 3 Mar 2017 by
gane@1987

Data auto change on multiple status in one column

 Solved

Hello again, Few days ago i am looking for a command that can use to change data status in one same column. Example : 'Activated' change to 'Expired...

10 replies Last reply on 3 Mar 2017 by
Mazzaropi

Question on vba code

 Solved

Hello, can someone explain this code to me? I have this file that has a macro button transferring all the information(KPI's to be exact) from a data...

2 replies Last reply on 28 Feb 2017 by
Griever666

Formula help - if cell contains a number, +1.

 Solved

Hi there, Just a simple one for you guys! I'm currently making a spreadsheet to tally up sickness days and occurrences. I currently enter how many s...

3 replies Last reply on 28 Feb 2017 by
Mazzaropi

Covert date of birth

 Solved

Dear Sir I want to convert date of birth in excel like below mentioned Example : 11/07/1982 then it should be reflect as Eleventh July Nineteenth...

2 replies Last reply on 27 Feb 2017 by
sushim1399

Need help with macro to generate monthly overview

 Solved

Hi all! I have been trying to build a Macro that allows me to generate a new worksheet with the information from a Master Sheet where i will key in t...

12 replies Last reply on 27 Feb 2017 by
ZhengPeng

Conditional formatting

 Solved

I am trying to format column 'O' if the value is greater than zero but where column 'P' does not include "SBNAS735" or "SBTDP443". Help! System Conf...

3 replies Last reply on 27 Feb 2017 by
Mazzaropi

Transfer data from one sheet to another

 Solved

Hello, I require some assistance please. I looked at a few answers on this forum, but I am stuck as my VB keeps on giving errors. I wish to automa...

3 replies Last reply on 24 Feb 2017 by
vcoolio

Date formats

 Solved

Hello, Can you tell me how to change the format from Sep-01-2015 to the format 2015-09-01? I have tried the format tab under the Date section and Cu...

3 replies Last reply on 22 Feb 2017 by
ac3mark

Complicated auto populate possible or not and if so how.

 Solved

Hello, I'm using excel to schedule for my business, I have all the customer information on the first sheet and would like to auto populate the other s...

9 replies Last reply on 22 Feb 2017 by
vcoolio

Iso 27005 risk value

 Solved

Hi All, I have the following problem: I have two cells that have a text value which can either X or M or H X value is 0, M value is 1 and H value i...

5 replies Last reply on 21 Feb 2017 by
Mazzaropi

Copy a row from one worksheet to another, based on criteria

 Solved

Hello, I'm trying to copy rows from my "master" worksheet to another sheet based on criteria in column A. Can I do this? Please help, thanks...

15 replies Last reply on 20 Feb 2017 by
vcoolio

I want to send 120 e-mail with 120 attachments

 Solved

Hello, I have excel file for salaries. In this file I have all the data for each employee (120 employees) including their e-mails as well. I want ...

35 replies Last reply on 19 Feb 2017 by
medo42002

Totaling hours by code

 Solved

I'm looking for some excel help please :) I have an excel sheet that I would like to have totals for employee hours, sorted by the code that is enter...

7 replies Last reply on 17 Feb 2017 by
Mazzaropi

Change data status in one same column

 Solved

Hello, i am looking for a command that can use to change data status in one same column. Example : 'Activated' change to 'Expired' when it due. ...

4 replies Last reply on 17 Feb 2017 by
Mazzaropi

If statement -

 Solved

Hello, I'm attempting to create an IF statement. IF a type = 1 then add the total of a corresponding cell to the total amount. =SUM(IF(B24:B51="1...

3 replies Last reply on 16 Feb 2017 by
Mazzaropi

Lookup across whole workbook (muliple sheets)

 Solved

Hello, I would need your help with my problem in MS Excel. Here is the description: 1. I have an Excel workbook containing multiple sheets (ca. ...

6 replies Last reply on 10 Feb 2017 by
Mark

Autofill master sheet

 Solved

I am trying to automatically fill in a table (with whole rows from A-N) on a master sheet (sheet 1) based on whether the data in column H of the table...

1 reply Last reply on 9 Feb 2017 by
vcoolio

If cell contains a certain text, add the numbers of another cell

 Solved

Hello, I am trying to do my finances in an easier way, and would appreciate it if anyone can help me with the below question: B2=Supermarket , C2=30$...

1 reply Last reply on 6 Feb 2017 by
Mazzaropi

Need formula for comparing differences of two columns.

 Solved

Column A and B both contain numeric values. I want Excel to look at both and give me the numeric difference between the two in a new column C. I reali...

3 replies Last reply on 4 Feb 2017 by
oduana777

Copy activechart properties to cell (from graphics)

 Solved

Hello, I hope someone could help me. Working with graphics in excel, I generate dispersion plots from some datas, later I add the trendline, display...

2 replies Last reply on 2 Feb 2017 by
mendokzeni

Copying conditional formatting with formulas accross rows

 Solved

Hello, I am trying to copy the color formatting along with the formulas across the entire row but the colors don't change based on the formula. Exam...

2 replies Last reply on 2 Feb 2017 by
Wearrien

Multiple if formula in one cell, date comparison

 Solved

Hello, Would please help me to find the proper formula for this below if R6 is Action date if S6 is Target date T6 is Number of days to close the...

3 replies Last reply on 2 Feb 2017 by
TrowaD

Convert number to assigned names and joined with another names 

 Solved

Hello, Please anyone can assist me on the below issue. that if I want to have a result as per the below if 1=Biju , 2=Daisy, 3=Mahmoud.... Cell...

4 replies Last reply on 1 Feb 2017 by
Mariam

Macro for merging data from multiple sheets

 Solved

Hello, I want to copy data of 2nd columns from all the sheets to different columns of single excel sheet. Is there any macro code available for per...

5 replies Last reply on 31 Jan 2017 by
TrowaD

How to convert date into text.

 Solved

Hello, how to convert Date to words in excell in large for Tc use e.g 05/01/1992 To change five January,Ninteen Ninty Two System Configuration: Win...

1 reply Last reply on 30 Jan 2017 by
TrowaD

Function button: unhide cells between values and hide all other

 Solved

Hello! I am new to macros and this one is proving to be a bit of a challenge for me. I am building a template that contains several sections. What ...

2 replies Last reply on 25 Jan 2017 by
MartaGH

Automatically transfer data from one sheet to another

 Solved

Hello, I have a workbook with several worksheets (Master, Pending, Lost, Sold, and Bidding). I would like to be able to have certain line items base...

5 replies Last reply on 22 Jan 2017 by
vcoolio

Range of numbers

 Solved

hello, I would appreciate help on the following problem :- If cell R1equals any number in the range 12 to 31 then I wish cell b1 to equal 2. Is ther...

3 replies Last reply on 21 Jan 2017 by
Mazzaropi

Add incremental number based on conditions in excel

 Solved

Hello, I have a column that contains variables (for example; days of the week) and I am trying to add an incremental number in the second column bas...

3 replies Last reply on 20 Jan 2017 by
Mazzaropi
Results 351 - 400 out of a total of 1,690