Excel Forum
-
How to create a macro to update a file based on a masterfile [Closed]
Hi I would like to create a macro (program) which will update a file by clicking on a button, based on a masterfile. Basically I have a list...
-
Transferring data [Closed]
Hi, I use excel 2007 version. I have some data in an excel sheet - students' names, ids, test items attempted, multiple attempts made by...
-
Transfering data for a spreadsheet to another [Closed]
Its not working. May be size (row height & Column Width) not same. Is there any other way to solve this problem.
-
Conditional format only if different from cell in another sheet [Closed]
Hello. I am using Excel 2011 on a Mac. I have two sheets in my worksheet. Both sheets are a two week schedule. Sheet 1 is titled PP - it is...
-
auto-copy cells one to another + formation too [Closed]
Hi! I want to make intelligent excel, like.. i have many sheets and i want it to work the way, that sheet2 takes data from...
-
set a conditional formatting to highlight the latest number [Closed]
I have a column to record invoice numbers in this formatting KI-00123 where the number portion is in running order. How do i set a conditional...
-
Strike through when entering date [Solved/Closed]
Hello, In excel I have a row of information in six different cells. The first cell and last cell have a date format. When I enter the...
-
Place new Code to Working Code [Solved/Closed]
Hello, I would like to request that some line of code (marks as bold) I have to place in the Working Code which is given below that I cannot...
-
Printing Selected Columns from Multiple Sheets [Closed]
Good day, I recently made a workbook with multiple sheets. I am a newbie regarding Excel. I would like to know if there is a way for me to...
-
Copying a row to a different worksheets depending on word [Closed]
Active Worksheet is called Quote Sheet Row A has a drop down list: Booked Missed ...
-
If Statement or something else to Copy from sheet 1 to sheet 2 [Closed]
Hello, I am looking for a bit of help. I am not sure if this has been asked I tried looking at other post. Any Help to point me in the correct...
-
Please helpin creating a macro that will create a new spreadshee [Closed]
Hello, I would like to kindly ask for help in creating a macro that will generate a new spreadsheet based on the letter entered in a specific...
-
A macro in excel [Closed]
Issue : I have a worksheet with two columns. First column contains some individual names, and second column contains Residence PIN number of...
-
Export data from worksheet to another Excel file [Closed]
Hi I would like a macro that cam help me export data to another file. I have an Excel form which I would like to move the entries into...
-
Create folder and save file macro [Closed]
Hi I am hopping someone can help me with a macro code. I would like to save a worksheet (only the active sheet) into a shared drive (if not...
-
Excel help [Solved/Closed]
In excel I have a row of information in six different cells. The first cell and last cell have a date format. When I enter the last date to the...
-
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...
-
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...
-
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...
-
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...
-
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). ...
-
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...
-
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...
-
automatically email notification [Closed]
Hello, I would like to know how to create automatically email notification when issue overdue. Regards, Configuration: Windows /...
-
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...
-
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...
-
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...
-
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,...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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 ...
-
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...
-
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...
-
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...
-
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...
-
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...
