The discussions
Simple date subtraction excel
Solved-It seems soo simple, yet I haven't been able to find the solution. I need to display a date that is five years in the past from today. -I tried a co...
Add date function to this code
SolvedHello all, I am looking to add a date function to cell J (or whatever column/cell I need it to be) after this code performs its actions. Currently ...
Adding buttons to an excel spreadsheet.
SolvedDear CCM Team, How do you add a button on a particular cell in an excel spreadsheet to turn it on and off. Example: If I want to add a column of nu...
Pop up message in excel (like outlook agenda)
SolvedHello, I have a big file in Excel with heaps of information about my customers. One of the coloms is telling me when I need to send them a letter....
Monthly production report -automatic transfer of data
SolvedDear All, I am looking for a solution to generate monthly production analysis report of an operator for his daily production. Attached sample sheet...
Fill adjacent cell with number from text answer
SolvedHello, and good morning, I have a cell with a dropdown box, to select a certain text. When I select the type of incident from a drop down ...
Create folder in desktop with vba, if exist, ignore
SolvedHello, How to create folder in desktop with vba whenever the excel book is opened, if exist, ignore. Message if create new folder, silent if th...
Dependent (cascading) drop down list in excel
SolvedDear All, Please help me on the below . I have a data validation drop down list with unique values in cell G2. These values are job numbers from C...
Combine sheet in master spreadsheet with auto update
SolvedHello, I have 24 sheets in the same Excel document with identical headers I`d like to combine in the master spreadsheet the way if any data is insert...
Copy data from one excel sheet to another: automatically
SolvedDear all, Anybody can help me please. I have MAIN DATABASE ( sheet 1) of column names : Serial No, Service type, Job No, Date, Customer name, desc...
How do i make all rows the default height in excel?
SolvedHello, How do I make all rows the default height in Excel?
Multiple sheets to one master sheet update
SolvedHello, We are a team of 8 who updates a single excel work sheet, and because of this, there is always information missing or overwritten by others et...
Coloring cells in sheet 2 based on data sheet 1 excel vba
SolvedHi! I would like to ask a question about using VBA for colouring a cell in sheet 2 based on a value of a cell in sheet 1. I want to write a code in ...
Udf for attendance register
SolvedHello, I have used your UDF as shown below to report a date whenever an entry is made in a row of my excel sheet. Function LastAttendanceDate(mDate...
Formula to find last date of attendance
SolvedHello, I have an excel sheet that enters the time taken by each student on each day for the whole month. The student names are in the rows and d...
How sum the column value in excel via vba based on criteria?
SolvedHello All, I would like to sum up the column value based on the following criteria (TRUE or FALSE). I have a value in the "E" column and in the "F" c...
Apply conditional formatting across several cells
SolvedHello, I want to change the color of a row if there is text in column A of that row. I have the following equation: "=AND(ISTEXT($A$2))" ... and I h...
How to add rows automatically based on cell value in excel?
SolvedHi All, I have a requirement to add the Rows Based On Cell Value In Excel. Below I have attached the snapshot of the requirement details. I have two...
Populate values in textbox based on combobox ,optionbutton
SolvedHello, I have the items in column B in sheet1,2,3 and the prices in columns F,G for sheet1,2 and the prices for columns F for sh...
Running a macro in different cells
SolvedHello, I have a question. I recorded a macro to average a series of columns, highlight the averages row in a bold color. I would now like to run the ...
Generating invoice number automatic without repetition
SolvedHello, please I need help , I want VBA CODE to Generating invoice number automatic without repetition in my excel any time type in the next cell it...
Macro to automatically update a master sheet from multiple sheets
SolvedHello, I have a file with a master sheet and 6 different individual sheets. Each sheet is considered a project. It includes person's information a...
Working with multiple worksheets in a workbook
SolvedHello, I am completely new to all of this so please bear with me. I am new to forums and how they work so I apologize in advance if this is a repeat ...
How to lock in specific cells in a formula going down rows
SolvedHello, I am having an issue with easily repeating a formula I've made. the formula is =IF(AP2=Sheet2!K3,Sheet2!L3,IF(AP2=Sheet2!K4,Sheet2!L4,IF(...
Hello friends. please help ! countif formula ?
SolvedHello friends. Please help ! I want a formula ( maybe COUNTIF? ) to count how many "W" and "D" and "L" are found per each range: "B3:B12", "D3:D12"...
Automatically update one sheet from multiple other sheets
SolvedHello, I have a workbook with each office location having its own sheet to keep track of project information all with the same column headings. Co...
Summing values based on matching column across sheets
SolvedHello, Hello, I would match data across sheets based on matching columns B then should add & summing the values to sheet summary under heade...
How to copy data after at a fixed cell
SolvedHello, I have the following data for which it needed to be copied on another sheet after a gap of 7 cells for each entry in Sr No. column. Li...
Autogenerate alphanumeric id numbers in excel?
SolvedHiya! Let me start off by saying I am NOT a tech person so I don't even know if this is possible. I am trying to create an excel sheet where I can ...
Search across all open workbooks for user defined criteria
SolvedHere is my problem - we store info into files that use an index number (changes with each file created) plus 2 criteria to keep track as we produce ma...
Auto-fill items repeatedly for two sheets based on another
SolvedHello, I have two sheets(FIL1,FIL2) should auto fill some items into column A repeatedly . it depends on sheet REP after matching based on colum...
Copying a row based on a integer in a cell
SolvedHello, I am needing help making a macro that will allow me to do a number of things, that may or may not be able to be done with one single macro. (...
How split column into multiple columns for multiples sheets
SolvedHello, I need macro to split column C for sheets REP1,PROC1 into columns C,D,E based on matching column B with column B into sheet RP ...
Match & add missed items between two sheets
SolvedHello, I have two sheets contain the same structure of data . the result should show in column B,C into sheet2 based on matching with sheet1 . ...
How to add rows that meet specific conditions
Solved/ClosedHi Every week at work we get data about new jobs that have been completed at our company, and I add that data to a raw data tab. In the summary tab...
Changing values in one cell depending on drop down
SolvedHello, I created a drop-down list of scores (ie. 10, 20, 30 to 100) in cell A1. In cell B1 I want it to show a specific number value based on which...
Conditional formatting: change fontcolor based on another cell
SolvedHello, I have "text" in cell B1. However, I want the font color to change based on the numerical value in cell B8; so if the number in cell B8 ran...
If function: conditionally multiplying a value
SolvedOk so I am trying to create a formula that would use a different calculation based on an answer. So when I get the number 2 in a cell then the data us...
Copy adjacent columns in excel if the id numbers same
SolvedDear all, I have ONE HELP in excel to copy two columns data( Qty & Amount ) from another sheet if the ID numbers are same.. I have created one...
If cell contains multiple text how to add other cell value?
SolvedHello, I am struggeling with my excel sheet and need help. I will rather give it in an example. A1 and B1 contains a price, C1 contains three s...
How to insert an image into an excel comment box (mac)
SolvedHi I'm on Mac with Excel 16.53 and I want to insert an image into a comment box. I read this : https://ccm.net/apps-sites/software/4079-how-to-i...
Formula in excel to show amount in cell
SolvedHello, I need a formula that show the amount in another cell if some text is found in another cell. Like this; A2: 500 B2: Done C2: result t...
How can i link optionbutton and textbox based on selected from combobox
SolvedHello, hi actually I got this codes from another web and mod some . it succeed and works , but my question how should link with the others tools ...
Multiple if arguments
SolvedHello, I am trying to get Excel to look at data in two cells and depending on the combination it finds in those cells, record a different TRUE sta...
Add missing data before total row after matching between two sheets
SolvedHello, I'm new begginer in vba and I hope some help I have data in two sheets . should match data beween them. the match depend in COL ...
Code to move rows into another sheet based on certain values
SolvedHello, I've seen different variations on this question, but haven't seen any answers that specifically address moving rows based on multiple value...
Cell value = sheetname to pull information from in excel formula
SolvedI am trying to pull data from another sheet using the formula (located in B26) below, but I want to replace the sheetname ('9.60'! in this case) with ...
Return seq values until blank value then return different set of seq values
SolvedHello, What is a formula to return a specific set of values in sequential cells until the reference sequence returns a blank value then start return...
How deal with this complicated code and updating(subtraction between two sheets)
SolvedHello, I need help from experts to updating this complicated code . I know this way is very complicated to subtracting the item...
I want to find date of joining
SolvedHello everyone i have a attandance sheet like this i want to find date of joining by formula. Mean on which date from 1 to 31 he started to work i w...
