The discussions
Double condition formula based on drop down selection
Hi All, I have an excel file with sheet names : Primary Data sheet, Ground floor, First Floor and readings. I need this file to capture printer usage...
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....
Automatically send emails from excel based on cell date
Hi All, Please help me anybody. I am suffering with sending email from excel automatically ..Please see attached screen shot for your reference : ...
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...
Copy data from one excel sheet to another: automatically
Dear All, Anybody help me to transfer the data from main database sheet to other sheets based on sheet name condition. i.e., The data from B6 to Q6 f...
If cell z2 contains a date, show 'yes' otherwise show no
Hello, I am trying to get my sheet to show a Yes Field when a date is entered. But a no field at any other input, weather thats 'n/a' or blank or any...
Change color of cell automatically
I am working on excel . want to change color of cell automatically as per color of another cell. Color of another cell changes automatic as per form...
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...
Excel formula: two financial year ends for one client
Hello, Thank you so much for putting time aside in helping me with the following formula. In Column O on the Main sheet, I do a VLOOKUP from the mas...
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...
Formula assistance in excel
Hello, I hope this message finds you well. I'm reaching out for some assistance with a Microsoft Excel formula-related question that I recently came ...
How do i make all rows the default height in excel?
SolvedHello, How do I make all rows the default height in Excel?
How do i change the backgroud of a cell or a whole section?
Hello, I have a question. How do I change the backgroud of a cell or a whole section? I want to differentiate one set of data from anoter set based...
How do i set the height of rows in excel all at once ?
Hello, How do I set the height of rows in Excel all at once instead of doing them one click at a time by clicking and dragging and dropping the indic...
Excel macro to duplicate info based on value in another cell
I am creating a work book that has a range of cells (C6:E34) that are considered one "Location", and another cell (D5) to input the number of location...
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...
How not to show false in the following example.
Hello, I wish the formula to return a blank cell if there a blank cells in the formula. =IF(C27="BUY",((D30-D27)*10000),IF(C27="SELL",((D27-D30)*1000...
Drop down
Hello, I have a workbook with one main sheet and lots of rows to be filled. There is one column with a drop down with 3 selection. How can I copy ...
Create multiple workbooks with template at once
Hello, I'm being tasked with copying a single workbook with a special layout in it and copying it about 90 times with the file name corresponding to a...
Adding last week position to a weekly record survey
Hello, I am compiling weekly record charts of the most popular records. How do I add the last week position to each song on each new record list in E...
How to pull data from column based on multiple criteria?
Hi Expert, I'd like to combine a column value in Mainsheet, where the column values are pulled from Sheets 1 and 2 of the same Excel file using VBA c...
Copy a data from one sheet to another
I have a Master list (Sheet 1) that contains house numbers and personnel assigned to them. I want to copy the entire row with the data assigned to eac...
Formula to return text
I need to have a formula to return text from text. I will give example; If column A = 7am then I want column B to say Days If column A = 3pm then I...
Create christmas present schedule
Hello EXCEL GENIUSES OF THE WORLD! I am trying to save my entire family money and a feeling of obligation to buy a gift for EVERY DANG KID in our fam...
Formula to recognize fical year to reset paid days off
Hello, I am trying to make a formula that will choose certain rows from each month in a calendar year that have hours in them, subtract from a total ...
Compare 2 columns to find the 3rd value and return the 4th
Hello, Here in my example, if value in Column B (table 2) matches with the value in column A (table 1), then I need to check the first row corre...
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...
Excel filter some data from other two sheets and copy back
Hi, I have some query related to excel where i have to get some results as described below: Excel Sheet 1: Excel Sheet 2: Excel Sheet ...
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...
Basic copy/paste, multiple sheets and databases
Hello all! I’m not good with this, so I’m am reaching out to those who are. I can record and run basic macros, but this is above my skill level. I’ve...
Find text in multiple cells and return different text
Hello, I am a teacher trying to find an alternative to manually entering data for single children and a way of simply analysing it. I have created a...
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...
Formula for outputting value from dropdown list
Hello, I need assistance with finding a way to output the value of cell based on the text it's associated with in a drop down list. Below is a scre...
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 ...
How to extract text from column that got text
Hello, I would like help on how to extract text from column which has text. Some column might not have text or blank, want to know how to extract th...
How to convert excel to pdf in tamil font
Hello, how to convert excel to pdf in Tamil font
How to speedup formula processing
I have been using this formula which macthes the List of Cells to Raw String and if match found then write same value. This function is working fin...
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...
Pasting a column into alternating rows in new column
Hello, i have a column of ID numbers and a column of names next to it, I want to copy and past the names with their corresponding id in cell under the...
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 ...
Compare 2 columns if it matches all columns must go tosheet2
Hello, Thank you for putting the time aside to help me. There are 2 sheets, Summary and Journal. Step 1: In the Summary sheet, I added Column E to ...