Excel Forum
-
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, "...
-
Create a Table from data held in an existing table conditionally [Closed]
Hello, We have a job monitoring excel we have been using where we have an existing table that holds the status of all possible jobs we are investi...
-
Data entry [Closed]
Hello, i am working on two different excel sheets. in sheet 1 i have a similar types of entry suppose that students name of same student mult...
-
How to Separate the worksheet based on data [Closed]
Dear Sir. I had the data as mentioned below for your reference CODE EMPNAME EB HRA GROSS 175702 MAURICE J P 10,140...
-
copy data without opening workbook using vbscript [Closed]
Hello all, Is it possible to copy data without opening workbooks using vbscript? Thanks in Advance!
Subscribe To Our Newsletter!
DON'T MISS
- How to Disabled Write Protection on a USB
- How to Fix a Blurry Snapchat Video
- Computer Boots to Black Screen
- How to Install a VPN
- How to Create a Gmail Account
- How to Recover a Disabled Facebook Account
- How to Get More Followers on Instagram
- Facebook Code Not Received
- How to Recover Your Yahoo Account
- How to Get Free Diamonds in Free Fire
- How to Upload High Quality Photos to Instagram