The discussions
Macro for inserting pictures from folder to excel
Hi guys I am new here and would appreciate any help for the following issue: I have an excel sheet with more than 100 product codes (e.g. 00501-016...
Find and replace from a dropdown
Solvedhi Guys, second and hopefully last question for now. Is there a way to the following: I have a dropdown list with names of tabs of the excel file...
Dob conversion in excel
Hello, how to do work DOB conversion in excel sheet System Configuration: Windows / Chrome 64.0.3282.186
How to easily cummulate data
SolvedHi there, I was wondering if you guys know how to do this: got 13 weeks, each week has a figure underneath it. Let's say week 1 has 1 under it, wee...
Vba code to create pivot table
Dear all, Attached and show below the xls sheet. I need help from the forum, once I click the button, a pivot table to be generated in a new s...
Change color of cell comparing contents to 2 cells
Hello, Hope someone in this community can help me write a vba code to for example: Cells B3 and C3 have a value When I input values into cells r...
Pull data from sheet 1 to sheet 2
I would appreciate any help for my case. So in sheet 1 called WIP, consist of item descriptions (C1) and quantity to be build (D1). The item descripti...
Copy paste in loop in loop
Hi Trowa, I am new to Macro - but i have similar request to copy paste in 2 loops 1. copy a number times Sheet 1 Column 1 data ( say having 3 val...
Automatic payroll computation
Hi everyone. Im just new to my job and one of the task assigned to me is to compute payroll for our employees. im not that knowledgable with excel, m...
Automatically change the cell from general to date
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
ClosedHello, 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...
How do you change cell colour based on date
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
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
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
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
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
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
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 ...
Find a value in a matrix array
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
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
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
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
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...
Transfer data automatically in one sheet
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
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.
SolvedHello, 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
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
SolvedHave 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
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/ClosedHello, 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
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...
Macro to delete rows if cell contains string
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
ClosedHello everyone, I need help, who has good skills in excel programming ? I need to create a useful program in excel for my course paper
If formula in excel
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
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...
Excel help - if function maybe?
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
How to cell number count?
Convert number to words in excel
Hello, how to convert numbers to words in excel like 113 as one one three.
Excel lookup 2 cells to match in 2 rows.
SolvedHello, 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
SolvedHi 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
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
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
ClosedAll 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...
Subtracting amounts from a fixed amount
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
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...
How to automatically input a word into one cell
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
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
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
SolvedHello, 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...
Macro to compare the 3 columns "sec code
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 ...
