Excel Forum
-
How do you change cell colour based on date Closed
Hello, How do you change cell colour automatically based on date. I am trying to set my training spreadsheet so I can clearly see when staff membe...
-
Repetitive formulae Closed
Hello, how do I construct multiple pages with the same set of formulas? System Configuration: Windows / Internet Explorer 11.0
-
How to copy information from sheet 2 into sheet1 Closed
I have a spread sheet with two sheets. The first contains names and i need to copy information from sheet 2 into sheet1. in Sheet 1 F66 =Sheet2 A2 ...
-
How to cell in sheet 1 into another calendar sheet Closed
Hello, Elson here. Would like to ask. How to transfer a date + remark from sheet A, into a calendar sheet B. For example. Sheet A Cell 1: date (...
-
Salary difference from two years based in employee Closed
Hello, Hi sir/ madam I have two sheets and in one sheet consists of 2007 year employees details ( I'd and salary) and second sheet also consists ...
-
Assistance request - IF statement and adding Time Closed
Hello Friends, I would be extremely greatfull if someone would have the time to assist me with a formula in Excel. I also know this is a voluntary...
-
Insert multiple copied rows at fixed intervals Closed
Helo Would you please help me by giving Solution for my Question how I can insert multiple copied rows n time at fixed interval using excel macros ...
-
IF statement and adding Military Time Question Closed
Hello, I am trying to add time inside an IF statement, but I cannot get the time to show correctly when adding more than 30 mins. Here is my f...
-
Find a value in a matrix array Closed
Hello, Is there any formula to find a value in a matrix array A program in gw basic i want to change it into excel. Suppose A B ...
-
School report card with data of all classes Closed
dear sir/madam i am looking for excel work for school report card, one sheet where i want to put data as where data will be entry(sheet-1) class...
-
Moving Rows overflow from Cols A&B to C&D help Closed
Hello, I'm new to this macro business but I was able to create a sheet that functions 95% of how I want it to. My only problem now is that my shee...
-
Insert the number 001 in column A if B A00-A10 Closed
Hello, In column B the data range from A00-Z99 and I want to insert the number 001 in column A if B A00-A10 and 002 if columnB A11-A20 which f...
-
Trying to record data next to date cells for today Closed
Basically what I am looking to do is to record the minutes and seconds of each call taken manually and then where the dates are, I want it to record t...
-
Copying data from multiple files into one file Closed
I have to compile an excel file by deriving thousands of data from 10 different workbooks. I know I can just use the simple "=" and link the files but...
-
Transfer data automatically in One Sheet Closed
Dear all, I am facing a problem to transfer the data from different sheets to one sheet with the help of Macro. I have attached the excel file,...
-
Estimate, print area if quantity is over 0 Closed
Hello, I am trying to make estimate software for a remodeling company. I just want the description to be printed or copies to clip board if quanit...
-
How to add 200 working days to a given date. Solved/Closed
Hello, Please I want to know how I can add 200 working days to a specific date to get a new date
-
Write Macro to search and copy to new workbook Closed
I receive sales report each month and I filter and subtotal these to show the total units purchased by each store over the month. I want to create a ...
-
Auto populate data between Excel sheets Solved/Closed
Have project management data that should be automated to populate from two Excel sheets to the desired Excel sheet. I was thinking that it could be A...
-
Help creating a rubric Closed
Hello folks, I have used some VBA in excel before, but I am wondering how to go about programming a macro to be used in a rubric so that I can doub...
-
Cannot change the date format in Excel 2007 Solved/Closed
Hello, I have tried everything mentioned in this forum and they still do not work. I have a sheet with the date appearing dd/mm/yyyy, I have ...
-
Cell background colour Closed
Hello, Is it possible for a cell to change colour as a warning that the date in the cell is nearing going out of date. System Configuration...
-
Building an order summary Closed
Hello, So I have an order form with a list of SKUs. If you enter a quantity next to any SKU the form then the price and totals show up. If you d...
-
Macro to delete rows if cell contains string Closed
Hello, I need help creating an Excel macro. I have a large sheet that has cells with large amounts of text (error messages). I would like to delet...
-
Program Closed
Hello everyone, I need help, who has good skills in excel programming ? I need to create a useful program in excel for my course paper
-
How to Insert copied rows n times at fixed Interva Closed
hello I would appreciate your help if you can give me answer for my question that is How I can Insert Multiple Copied rows n times at fixed Interv...
-
IF formula in Excel Closed
I have this in excel as a VBA , however it wont work unless the field is manually keyed , ideally I want a drop box with Yes , No , Unsure . can this ...
-
Autofill cells based on conditions & unique values Closed
I am trying to auto populate cells that meet the same criteria with a value input by a user using either macros or a formula. For example, in the data...
-
How to transfer data worksheet to worksheet Closed
I have a schedule I designed for work and need to show the last 2 hour of one shift on a new work sheet for the next shift. The data will change weekl...
-
Excel Help - IF Function maybe? Closed
Hi All, I'm hoping someone can help. I am trying to work out how to calculate the following by the information populated in my cells. For example...
-
How to Number Counting Closed
How to cell number count?
-
Convert number to words in excel Closed
Hello, how to convert numbers to words in excel like 113 as one one three.
-
Excel lookup 2 cells to match in 2 rows. Solved/Closed
Hello, I am using Excel to makes archives of PC issues we have in our compagny I have Info that i have to write in two cells that are standard...
-
Row conditional formating in Excel Solved/Closed
Hi All, I'm trying to play around with the conditional formatting in excel to highlight a row in excel if a cell in that row contains certain text....
-
VBA question Closed
Hi Trowa (experienced VBA help community), Sorry if my earlier posted question was not clear. Here is the situation: Sheet" Initial": A (Fir...
-
Pick up dates from column f which are greater than Closed
Hello, I need help with a vba code logical statement I have a worksheet1 where c19 is start date and d19 is end date. There is another sheet who...
-
Corrupted Excel file Closed
All of my excel documents are stored on working pc. Something happened with one of it, I don't know the reason, but some days ago I opened it as usual...
-
I wan't to make macro in Excel when i change value Closed
Hello, I wan't to make macro in excel that when i change the value of one cell on sheet1 macro changes the background color of the same value on she...
-
Create a loop in VBA Closed
I am trying to create a function however unable to progress as i'm stuck with the iteration part. Below are my codes. How do i go about creating the l...
-
Subtracting amounts from a fixed amount Closed
Hello, I need a equation for subtracting amounts that i entered from a fixed amount. Here is my screen shots. I enter 10000 in row 1 column A ...
-
Autopopulating new sheet based on an ans in 1 cell Closed
Hi, Hoping you can help. I need a solution whereby if I select a certain value from a drop down list it will autopopulate that row of data in a sep...
-
Option of selecting certain columns Closed
Hello, I want to select certain columns from one file and copying it to another destination file where selections can be done by giving command o...
-
How to automatically input a word into one cell Closed
Hello, I’m having a hard time trying to figure out how to automatically input a certain word into one cell if a different cell is less than anothe...
-
Copy and paste data upon click Closed
I have a set of data on A2 to A10. When I hit cell A2 which contain the word "January", the data will be copied into B2. If I hit cell A3 which co...
-
Resizing of Column & Rows in Macro Closed
Respected CCM team members, Greetings!! I am trying to insert images from a folder into excel by matching file names specified in a column, ever...
-
Highlight Help Solved/Closed
Hello, I am needing help with being able to highlight a cell based on another cell's value. Example: I am dealing with cells J2 and J3. I am needi...
-
Excel formula Closed
Hello, i need formula for below condition if b1 have any value consider that or consider g1
-
Macro to compare the 3 columns "SEC Code Closed
Hi All, I would really appreciate your help in providing me with a macro to save me some time on the following. 1- Everyday i receive 2 reports ...
-
How to save a copy of an excel sheet using macros? Closed
Hello, excel guru's, I am struggling with a problem which should be easy (i think), but with my lack of knowledge of VBA i am stuck. I have an...
-
Counting sites visits within a year Solved/Closed
Hi All, I have a small database that is regularly updated keeping track of site visits and I want to be able to create a table of number of visits ...
