Hello, I have conditionally formatted A2-A15 to visually represent a stoplight for a series of equipment dependencies (RED, YELLOW, GREEN). I...
Sir I ve the following fields in my database Date Receipt No Ref No Name of the student Fees Tc total 01/04/2015 ...
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. ...
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. ...
Hello, I would like to know how to create automatically email notification when issue overdue. Regards, Configuration: Windows / Chrome 47...
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...
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...
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...
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...
=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...
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...
I want a cell to change colour if the value in another cell is negative
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...
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...
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,...
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...
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 ...
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...
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 ...
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...
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...
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...
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...
Hi, I need to know how to add a formula that changes the cells in G column when I enter the word Pending.
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...
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...
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...
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. ...
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...
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...
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 ...
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...
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...
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...
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...
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 all info in sheet 1 and 2 and identify the difference SHEET 1 COL A COL B COL C COL D GF123 USD ...
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...
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...
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...
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...
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...
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 ...
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 ...
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 ...
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, "...
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...
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...
Dear Sir. I had the data as mentioned below for your reference CODE EMPNAME EB HRA GROSS 175702 MAURICE J P 10,140...
Hello all, Is it possible to copy data without opening workbooks using vbscript? Thanks in Advance!
DON'T MISS