Excel Forum
-
OVERFLOW ERROR Closed
Hello, I USED THIS MACRO BUT AN OVERFLOW ERROR MESSAGE APPEARS. KINDLY, HOW CAN I SOLVE THIS PROBLEM ? Configuration: Windows 7 / Chrome 47.0....
-
excel Closed
I have a spread sheet on Sheet one that has a list of properties that are assigned to various people with some additional info on each line about the ...
-
Format cell values to be included in another cell Closed
Hello, I am currently creating a holiday planner for all my employees on Excel 2010. I also want to create a separate cell for each day that shows...
-
Conditional Formatting Problum Closed
Hello, i have excel 2010 i have two rows. a & b i want if row a cell value not equal b cell value then change color cell b. (Note this format...
-
Using cell A1 to reflect status of A2-A15 Closed
Hello, I have conditionally formatted A2-A15 to visually represent a stoplight for a series of equipment dependencies (RED, YELLOW, GREEN). I...
-
excel Closed
Sir I ve the following fields in my database Date Receipt No Ref No Name of the student Fees Tc total 01/04/2015 ...
-
Import multiple xmls into a single excel file Closed
Hello, I have > 100 xmls to be imported into excel. Is there a way to import all the XMLs into a single excel? Please help need this urgently. ...
-
Date format change Closed
Hello, The date format is as follows : Dec 15, 2015 10:47:52 AM, I need to change to the format "DD/MM/YYYY". Could you please help me with this. ...
-
automatically email notification Closed
Hello, I would like to know how to create automatically email notification when issue overdue. Regards, Configuration: Windows / Chrome 47...
-
HOW TO GET FILTERED DATA INTO A SEPARATE SHEET Closed
I HAVE MY DATA SHEET WITH FIELDS GROUPED UNDER NAME, REF.NO, SALES . I WANT TO SORT IT ACCORDING TO THE REFERENCE NUMBER AND PLACE THE PARTICULA FIELD...
-
database report Closed
Dear Sir I have the following fields Month Receipt No Ref No. Name of the student Fees Transport Total. We enter the data according to the recei...
-
Cell formatting Closed
I am currently creating a holiday planner for all my employees on Excel 2010. I also want to create a separate cell for each day that shows how many p...
-
VBA script to copy data to another worksheet if the conditions Closed
Hi , Can someone help to give some VB script copy data from one sheet to new sheet if the conditions matches. I have a guest list with name, email ad...
-
Hello, where am I going wrong with this formula? Solved/Closed
=P10+ROUND(SUM(O10*O10*M10*0.7854)/10000,3),IF(M10>11.8,"CNB",P10) The final result in cell AV10 must be the value in cell P10 plus ROUND(SUM... [H...
-
Creating a macro to pull data from a sheet and transpose Closed
Hello, I am working on creating a journal entry form where I can enter a 'A" for accrual and have a macro look up the "A" then create a new spreads...
-
conditional formatting Closed
I want a cell to change colour if the value in another cell is negative
-
If change in Column A - Copy paste data in new worksheet Closed
Hello, Request your help. I have department wise data in a worksheet. Department name is given in Column A. I need to create new excel file for ea...
-
Code macro how to select used rows of a column Closed
Hello everybody, I'm struggle with my macro code. I would like to copy data to a worksheet and paste them to another. My problem is everyday the...
-
I want to build intelligent excel Solved/Closed
Task is: For example I have list of different fruits in cells in separate rows Apple Pear Plum I want the data to be copied to third cell,...
-
Extracting multiple date from master sheet to new sheets Solved/Closed
Hi I run a sports tipping site and I want to extract data from my master sheet to make other sheets. I.e in sports cloumn I have multiple sports and w...
-
specific price depending on the words in 2 cells? please help Solved/Closed
Hello, I am using excel 2008 for Mac, i need help with the following: example: A1 has a drop down box of 3 choices, apples, pears and peaches ...
-
Uniques identifiers Solved/Closed
Hello, I have an excel spreadsheet with twelve months (5 columns each) with names and product type for each month. Each month can vary by name but...
-
Excel 2013 has stopped working Solved/Closed
Hello, Every time I'd open Excel 2013 under Windows 8, it would crash instantly, leaving me a message: "Excel 2013 has stopped working". I looked ...
-
format one cell based on a text value in another cell Closed
Hi I'm trying to change the colour format of one cell with a text value based upon the text value of another cell, but cannot get it to work in exc...
-
Transfer scores to client list. Closed
Hello, I use excel to score measures that I use, and recently was inputting a rather large number of measures linked to a client list, I was wonderi...
-
Popup message Closed
Hello, I have a worksheet with several column displaying numbers. I wish the worksheet to popup a message when the number decreases below 21 to po...
-
Creating an order list from a sales sheet Closed
Hello, I am working of an excel sheet which is updated every time a sale is made. what i would like to do is have a list auto populated which woul...
-
Cell Turns Red when word specific word entered into Column Closed
Hi, I need to know how to add a formula that changes the cells in G column when I enter the word Pending.
-
make in to single row in exce; Closed
Hello, I HAVE EXCEL DATA IN THE BELOW FORMAT 93456787 BR129 11-10-2011 12:34:00 PM 93456787 BR140 16-9-2012 11:24:00 PM 93456787 BR1...
-
Formula to Pull out text in Description Closed
Hello, I am looking for a formula that will produce the following results: Actual: A1. Cash 10/2/15 A2. CC Application 10/4/15 A3. Check 10/1...
-
Date and amount Closed
Hello, I need to write a formula to give me alarm by turning the cell to red color and the formula is about the following: If the amount in Cell...
-
Copy data from Multiple Excel Files Closed
Hello, I have been trying to get information from indvidual files to a summary file from some time now. I have to do this mannual at the moment. ...
-
how do I code using a cell? Closed
Hello, I want to make a code that takes "50,41,62,62,60" and change each number to a letter so it's says something like a phrase such as "hello" h...
-
Problem from select list en copy to cel Closed
Hello Iwant to select from a list A5 on my Sheet1 and then i want that excel automatically Copy the cel B of the player from the Sheet2 to my She...
-
Use a master worksheet to update/populate all other sheets Closed
Hello, I'll try to make this explanation as simple as possible but please ask questions to get a better understanding. I blew my team away with ...
-
columns data formatting Closed
Hi i have data in two columns in below format: 1 a 2 b 3 c 4 d And so on. I want my two cells data in single cell with for...
-
Excel column formatting Closed
I have two columns 1 A 2 B 3 C 4 D My data is in two column like this and i want my answer like; 1 A 2 B 3 C 4...
-
Need help in creating macro to create new workbook Closed
Hoping someone can help me. I have a Microsoft Excel 2010 workbook that contains multiple rows of data. Row 1 contains my headers from Column A to C...
-
Find data and copy dynamic range Solved/Closed
Hello all, I would like to find text in one column and copy the range values which is adjacent to the text searched. I've attached the sample...
-
Resize the range Solved/Closed
Greetings, I would like to resize the range without keeping the starting position. I've attached the image In the above example, while usin...
-
how to compare data btw 2 sheets and identify the difference Closed
How to compare all info in sheet 1 and 2 and identify the difference SHEET 1 COL A COL B COL C COL D GF123 USD ...
-
Macro to Cut and Paste into next available row in another sheet Closed
Hello, I am very new to Macros and I am trying to write one that will cut the data in cells F3:H13 on sheet 1 and paste them in the next available...
-
Comparing Two Sheets in Excel to Eliminate Date Closed
I have two lists in excel, one is a full list of data and one is the list of data that I need to eliminate from the first. How do I compare the two li...
-
If formula Closed
Hello, I have to keep track of utility bills for my company on a month to month basis; is there an "if" formula that I could use to alert me if I have...
-
Excel 2013 Macro Closed
Holà! I am currently using this macro created by a former coworker to create & save as, a couple dozen excel workbooks. (This is just a section to...
-
Using the IF function for dates Solved/Closed
Hello, I am trying to figure out in Microsoft excel 2010 the appropriate IF formula to use. I am trying to calculate the number of working days th...
-
Number Conversion to Code Closed
Hello, Hello, I appreciate any and all who may give this issue some consideration. This is to change a number to a code of letters to hide ...
-
How do I code using a cell.? Closed
I want to make a code that takes a phrase such as "hello" and change each letter to a number so it's says something like "50,41,62,62,60" how do I do ...
-
How do I code using a cell? Closed
I want to make a code that takes a phrase such as "hello" and change each letter to a number so it's says something like "50,41,62,62,60" how do I do ...
-
Look at two different cells, refer to a 3rd, return value in 4th Closed
Hello, I am working on a worksheet and want to return a value from a column entitled "Possible Points" depending on which column is checked, "...
