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...

5 replies Last reply on 23 Aug by
Roopan01

Add date function to this code

 Solved

Hello 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 ...

13 replies Last reply on 21 May by
vcoolio

Adding buttons to an excel spreadsheet.

 Solved

Dear 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...

1 reply Last reply on 6 Feb by
RachelGreen

Pop up message in excel (like outlook agenda)

 Solved

Hello, 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....

3 replies Last reply on 5 Feb by
GeekMako

Monthly production report -automatic transfer of data

 Solved

Dear All, I am looking for a solution to generate monthly production analysis report of an operator for his daily production. Attached sample sheet...

10 replies Last reply on 2 Jan by
gannesh0604

Fill adjacent cell with number from text answer

 Solved

Hello, 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 ...

20 replies Last reply on 25 Aug 2023 by
vcoolio

Create folder in desktop with vba, if exist, ignore

 Solved

Hello, 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...

6 replies Last reply on 12 Aug 2023 by
praveen

Dependent (cascading) drop down list in excel

 Solved

Dear 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...

15 replies Last reply on 7 Aug 2023 by
gannesh0604

Combine sheet in master spreadsheet with auto update

 Solved

Hello, 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...

6 replies Last reply on 31 Jul 2023 by
vcoolio

Copy data from one excel sheet to another: automatically

 Solved

Dear 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...

10 replies Last reply on 27 Jul 2023 by
vcoolio

How do i make all rows the default height in excel?

 Solved

Hello, How do I make all rows the default height in Excel?

3 replies Last reply on 13 Jul 2023 by
HelpiOS

Multiple sheets to one master sheet update

 Solved

Hello, 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...

13 replies Last reply on 12 Apr 2023 by
vcoolio

Coloring cells in sheet 2 based on data sheet 1 excel vba

 Solved

Hi!  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 ...

4 replies Last reply on 4 Nov 2022 by
Sue-Ellen1994

Udf for attendance register

 Solved

Hello, 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...

2 replies Last reply on 3 Nov 2022 by
Slinger42

Formula to find last date of attendance

 Solved

Hello, 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...

3 replies Last reply on 3 Nov 2022 by
TrowaD

How sum the column value in excel via vba based on criteria?

 Solved

Hello 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...

2 replies Last reply on 10 Oct 2022 by
TrowaD

Apply conditional formatting across several cells

 Solved

Hello, 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...

2 replies Last reply on 12 Sep 2022 by
rdavis

How to add rows automatically based on cell value in excel?

 Solved

Hi 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...

7 replies Last reply on 12 Sep 2022 by
TrowaD

Populate values in textbox based on combobox ,optionbutton

 Solved

Hello, 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...

6 replies Last reply on 9 Sep 2022 by
Mussa_8911

Running a macro in different cells

 Solved

Hello, 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 ...

4 replies Last reply on 5 Sep 2022 by
Helmy

Generating invoice number automatic without repetition

 Solved

Hello, 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...

3 replies Last reply on 25 Aug 2022 by
TrowaD

Macro to automatically update a master sheet from multiple sheets

 Solved

Hello, 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...

17 replies Last reply on 16 Aug 2022 by
TrowaD

Working with multiple worksheets in a workbook

 Solved

Hello, 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 ...

7 replies Last reply on 11 Aug 2022 by
vcoolio

How to lock in specific cells in a formula going down rows

 Solved

Hello, 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(...

2 replies Last reply on 27 Jun 2022 by
JoshL

Hello friends. please help ! countif formula ?

 Solved

Hello 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"...

3 replies Last reply on 13 Jun 2022 by
TrowaD

Automatically update one sheet from multiple other sheets

 Solved

Hello, 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...

7 replies Last reply on 20 May 2022 by
vcoolio

Summing values based on matching column across sheets

 Solved

Hello, Hello, I would match data across sheets based on matching columns B then should add & summing the values to sheet summary under heade...

6 replies Last reply on 26 Apr 2022 by
leapout

How to copy data after at a fixed cell

 Solved

Hello, 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...

2 replies Last reply on 13 Apr 2022 by
skprma

Autogenerate alphanumeric id numbers in excel?

 Solved

Hiya! 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 ...

3 replies Last reply on 2 Mar 2022 by
vcoolio

Search across all open workbooks for user defined criteria

 Solved

Here 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...

5 replies Last reply on 1 Mar 2022 by
TrowaD

Auto-fill items repeatedly for two sheets based on another

 Solved

Hello, 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...

3 replies Last reply on 24 Feb 2022 by
TrowaD

Copying a row based on a integer in a cell

 Solved

Hello, 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. (...

5 replies Last reply on 24 Feb 2022 by
TrowaD

How split column into multiple columns for multiples sheets

 Solved

Hello, 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 ...

6 replies Last reply on 15 Feb 2022 by
Hasson_6770

Match & add missed items between two sheets

 Solved

Hello, 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 . ...

12 replies Last reply on 8 Feb 2022 by
TrowaD

How to add rows that meet specific conditions

 Solved/Closed

Hi 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...

Last reply on 28 Jan 2022 by
vcoolio

Changing values in one cell depending on drop down

 Solved

Hello, 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...

3 replies Last reply on 21 Jan 2022 by
vcoolio

Conditional formatting: change fontcolor based on another cell

 Solved

Hello, 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...

18 replies Last reply on 3 Jan 2022 by
Ravi

If function: conditionally multiplying a value

 Solved

Ok 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...

1 reply Last reply on 20 Dec 2021 by
TrowaD

Copy adjacent columns in excel if the id numbers same

 Solved

Dear 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...

1 reply Last reply on 13 Dec 2021 by
TrowaD

If cell contains multiple text how to add other cell value?

 Solved

Hello, 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...

1 reply Last reply on 13 Dec 2021 by
TrowaD

How to insert an image into an excel comment box (mac)

 Solved

Hi 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...

1 reply Last reply on 22 Nov 2021 by
TrowaD

Formula in excel to show amount in cell

 Solved

Hello, 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...

3 replies Last reply on 17 Nov 2021 by
vcoolio

How can i link optionbutton and textbox based on selected from combobox

 Solved

Hello, 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 ...

5 replies Last reply on 4 Nov 2021 by
TrowaD

Multiple if arguments

 Solved

Hello, 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...

2 replies Last reply on 2 Nov 2021 by
Tim

Add missing data before total row after matching between two sheets

 Solved

Hello, 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 ...

5 replies Last reply on 18 Oct 2021 by
TrowaD

Code to move rows into another sheet based on certain values

 Solved

Hello, I've seen different variations on this question, but haven't seen any answers that specifically address moving rows based on multiple value...

3 replies Last reply on 8 Oct 2021 by
vcoolio

Cell value = sheetname to pull information from in excel formula

 Solved

I 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 ...

3 replies Last reply on 4 Oct 2021 by
TrowaD

Return seq values until blank value then return different set of seq values

 Solved

Hello, 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...

1 reply Last reply on 30 Sep 2021 by
TrowaD

How deal with this complicated code and updating(subtraction between two sheets)

 Solved

Hello, I need help from experts to updating this complicated code . I know this way is very complicated to subtracting the item...

11 replies Last reply on 27 Sep 2021 by
TrowaD

I want to find date of joining

 Solved

Hello 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...

1 reply Last reply on 20 Sep 2021 by
TrowaD
Results 1 - 50 out of a total of 1,690