The discussions
Not allow paste, but allow vba code to paste
Hello all, I've run into a situation where the users of my workbook paste a row into the workbook, and that unfortunately circumvents my data valida...
Fomula for look up value
Dear colleagues Please could you help me to resolve this issue as per the image bellow:
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...
Splitting multiple choice
Dear Colleagues ; As you can see in the image below, I've already inserted the formulas that allow me to separate multiple responses from one cell int...
Help with array formula
OK, so I have posted here a few times and everyone is very helpful and knowledgeable so I'll start off with a thank you in advance. What I'm doing is...
Concanating text using vlookup forumula
Hi, Anybody help me to suggest a formula . Attached Sample file link Below: https://we.tl/t-gQD0tFH6Rh I am looking for formula at B11 .. it give...
Power query editor data source settings multiple users
-In power query editor, how can I make the file path dynamic? Multiple users need to be able to run the power query. But each file path will be differ...
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 ...
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...
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...
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?
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...
