Excel Forum
-
conditional Formating a column Solved/Closed
Hello, I wish to conditionally format a column depending on another columns date value in excel 2010 Column A has a target date and Column B ha...
-
Find words within cell & put value in adjacent Closed
Column has Organisation Name Need to Search and Create a category to the next 5 columns A Organisation can have key word in more than 1 category...
-
Help Request - for Advanced Filter Macro VBA Closed
Hello, I would like to have data from my master sheet to another one based on multiple criteria filter. My master sheet can be manually filled and ...
-
Copy cells based on conditions Solved/Closed
Hello, I want to make several versions of a questionnaire specific for each out of 11 types of a product. Therefore I made a button for each of th...
-
Comparison of Cells Closed
Hello, I want to compare two different cells in two different sheets and print the same in third sheet. 1) For Example in sheet1 is P and sheet2 is...
-
VBA macro to color a range of cells based on value of other cell Closed
Hello, I' am using a shared file and hence could not use conditional formatting. I want range C2:F2 should turn Blue is the value in cell G2 is...
-
Another Excel macro copying cells based on criteria Closed
Hi Excel Virtuosos, I've really been scratching my head over this one. I'm compiling a summarised history of a project since its conception 7 years ag...
-
Automate some of my daily Activity in Excel using Excel Macros Closed
Hello, I am a Hyperion technology Person. Looking for Vbscript code/Excel Macro code to automate my daily job. Before Looking for help on this, I wo...
-
Copying data from workbook to workbook using button Solved/Closed
Hello guys nad ladies, I have a problem, i hope you can help me. I have an excel worksheet (2 columns, 7 rows) It's kind of daily statistics (email...
-
Change color to different cells based on another cells text. Solved/Closed
Hi, need some help, cannot figure this one out. I had attempted to use conditional formatting; however, it is not completely accomplishing what I hav...
-
Need to find multiple Words to I Category (column) Closed
Apple, Pear, Peach example in one cell to be dragged down to 10000+ =IF(ISERROR(SEARCH("*apple*",A1,1)),"","Category ")
-
Auto notify or mail when excel sheet updated. [Solved/Closed] Closed
Hello, I have used following VBA, but still I am not getting the solution. Please help I am unable to change the following field. answer = M...
-
Unable to get email notifciation Closed
Hello, I have placed below noted in my excel. but I am unable to get the email to my ID. Please help me Private Sub Workbook_BeforeSave(ByVa...
-
Excel Workbook Closed
Hello, I have a workbook with over 100 sheets. One of the sheets has a title of labels, I am trying to set it up ina way that if i type in sheet 10,...
-
Copy cell, unless another call says specific text Closed
Hello, In my spreadsheet, currently C1 copies the number in A1. (=A1) I need this command to be overridden if B1 contains the text VISUAL Tha...
-
Multiple line to Single line in Single cell Closed
Hello, i have document in word, need to transfer the data to Excel, So copy sentecence and paste in Excel cell, but i will come like multiple line...
-
Compare two worksheets and Remove duplicated data from one Solved/Closed
Hello everyone, I am struggling to find a solution and would value input from fellow users. The Problem: I have two separate worksheets "Customer...
-
Search for matches from columns on separate sheets. Solved/Closed
Hello, I've got a problem that is stumping me, and I hope you all can help. I have two sheets in my workbook and I would like to have a formula, ...
-
Adding days to an auto populated date in Excel Closed
Hello, I want to add 3 business days to a auto populated date in another field. So for example. B1 will have the auto date (Based on a system ent...
-
Macro help required Closed
Hi, If anyone can help me to create the excel macro on- I have 12 rows data in excel with cell position A to BT. My requirement is- I want to copy ...
-
Help please, VBA userform, MsgBox! Closed
Hello. I have a userform that I use to introduce some data on excel. Most of the data must be filled (that are textbox that the verifications d...
-
excel formula using Julian calendar Closed
Hello, Can someone please help me create a formula in excel to convert A16612009 to 6/15/2015. The letter A stands for the year 2015, 166 stands ...
-
How to lock/unlock a workbook with multiple passwords Closed
Hello, I would like to lock/unlock a work book with multiple passwords. I would also like to add a Log tab and have the unlock record the user, d...
-
How to use macro to copy data from workfile A to workfile B Closed
Hi, COuld you please advise me how can I use macro coding to copy data from workfile A to workfile B? Example details :- Source data copy from:-...
-
Macro to transfer data from single to multiple columns Closed
So I have been doing research but have been unable to find a macro that does what I need. Basically, I have multiple items on different carts, labeled...
-
display a new entry in a column in a separate cell in excel Closed
Hello, I am having a column; A B 1 ab 2 abc 3 abcd 4 abcde 5 xyz 6 I want the next entry in 6 row of A to ...
-
Converting number into alphabetic word Closed
Kindly help in converting this 1,055.25 into alphabetic word... Thanks, Melvin Manila, Philippines
-
Whole Numbers and Decimals Closed
Forgive me if I was an anonymous user who had only a single question to ask after searching the internet for hours, and didn't know there were courtes...
-
Remove data on one worksheet if it appears in the other Closed
I have two separate worksheets "Customers" & "Members". Some customers are also members. I want to remove all Customers from the Members sheet. T...
-
Conditional formatting Closed
Hello, I am trying to format a column B2 to B56 with different dates in each row to change yellow when each date is 30 days before the due date and ...
-
Whole Numbers and Decimals Closed
Hello, So my problem is that I have a big chart with lots of numbers in it. Some are whole numbers "1,2,3,4,etc." and others are decimal numbers "1...
-
create Automatic tabs by sales rep Closed
I have this information on one single tab (50 sales reps) Colum A - Sales Reps Colum B Revenue sold I need to create a single worksheet for each ...
-
Date formatting Closed
Hi, When I fetch raw data from a portal, the date comes in this text format Oct-02-2015. I make it in proper format 02-Oct-2015 through delimited a...
-
If blank cell value of 1 + add 9 cells together Closed
Hello, I need a formula where if the cell is blank it gets a value of 1, then I need it to add 9 cells together (in the same row). If something (te...
-
Finding Customers Names Closed
Hi i am struggling to find my customers names on Excel Spreadsheets i have tried the format box and used the find box i also tried the name box can so...
-
greater than and less than Closed
Hello, i need help. A4 is the input i need to make it so that if A4 is greater than 1 and less than 100 it will display "centimeters" . Any sug...
-
Macro for formatting Raw data Closed
Hello, I need a macro that could format my data . Data in report comes as Col1 Col2 Col3 Col4 Name1 Date proj task hrs .. . . Tota...
-
How To Copy Data Between Several Sheets on VBA Solved/Closed
Hi, I'm still a newbie on VBA, so I could use a little help on getting some code working. I have several client used for factoring. As such, each i...
-
looking up text values in a col. and replace text in another col Closed
Hello, I am trying to lookup a partial text value in column 1(e.g. lookup all cells with the suffix AAL in cells that have an actual text of say AAL68...
-
Comparing two columns with other two columns Closed
Hello, I want to compare two columns with other two columns in excel 2003. Columns are as below A B C D a 10 a 10 b 20...
-
values from one workbook to another Solved/Closed
Hello, I need help - I have two worksheets one with costs and formulas I want to pull the answer from the formula block from the one worksheet to t...
-
I want to add 9 if conditions is it possible Closed
Hello, I want to add 9 if conditions is it possible in Excel?
-
Range of cells depending on a condition. Solved/Closed
Hello, I am trying to change part of a cell reference for a range of cells depending on a condition. For example, the formulas in column A & E: A...
-
excel problem Closed
I have two lists containing FAA pilot certification information. One list is basic information on each person in the database, the second list contai...
-
Please Solve my promlem if any body can ? Closed
Hello, if i make 10 invoices for a company on sheet 1 to sheet 10, each invoice has amount about Rs. 10000/- i need a auto covering letter on sheet ...
-
excel formula Closed
Hello, i need the formula on excel sheet for find out percentage if the number is >=3499 than find out 5% and if the number is
-
match cells in excel with all characters same except one Solved/Closed
Hi I was wondering if it was possible in excel to write a formula to perform the following task. I have two columns of data, col A and Col B . For eac...
-
Please Help Create Sub Sheet w/Master Sheet using VBA/MACRO Closed
Hi, I have a master spreadsheet that I want to pull certain information from without losing the format and formulas. I need it to link with my mast...
-
Comparing orders vs customers to find the ones who didnt order Closed
Hello, I have a list of 500 customers on one sheet with multiple columns of data for each one, Last name is column O, first is column P. On th...
-
Query Closed
Hello, if cell A2 contain any text then B2 should highlight with color Configuration: Windows 7 / Chrome 45.0.2454.99
