Excel Forum
-
VLookup plus and and or match [Closed]
Hello, I am trying to compare two different pulls from and HRIS system in Excel to create a monthly Delta file, I not only need to look up and r...
-
Automatically change the cell from general to date [Closed]
Hello, System Configuration: Windows / Chrome 64.0.3282.186 Somehow i am facing an issue again and again in my office 365 excel, when i sa...
-
copy text from one work sheet to another [Closed]
Hello, Could some one help explain how I can simply copy text from a cell in a different work sheet. I'm trying to make a report using the months of t...
-
If then formula [Closed]
Hello, I am working in excel 2016. I would like to use a formula in regards to days and a project time line. For instance if a project has 365 d...
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- Facebook Code Not Received
- Computer Boots to Black Screen
- How to Recover Your Yahoo Account
- How to Fix a Blurry Snapchat Video
- How to Create a Gmail Account
- How to Get Free Diamonds in Free Fire
- How to Get More Followers on Instagram
- How to Recover a Disabled Facebook Account
- How to Disabled Write Protection on a USB
- How to Upload High Quality Photos to Instagram
- How to Install a VPN