Excel Forum
-
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...
-
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 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 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 ...
-
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...
-
Formula to find last date of attendance Solved/Closed
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...
-
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? 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...
-
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 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...
-
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? 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...
-
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...
-
Running a macro in different cells Solved/Closed
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 ...
-
How to extract text from column that got text Closed
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 Closed
Hello, how to convert excel to pdf in Tamil font
-
How to Speedup Formula processing Closed
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 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...
-
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 Solved/Closed
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...
-
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 ...
-
Conditional formatting as text, unless cell is a certain col
Hello, If I create a conditional formatting rule for column A to turn a color given work "General" How do I make it so that it turns "General" that...
-
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 ...
-
Indirect Ref# error
I use a formula to set the name of my sheet (using VBA to move data around) to a number based on a cell value. The value is always a number and if the...
-
master sheet to auto populate from multiple sheets
hello! could someone kindly assist me with a formula or a macro that will auto populate/update the master sheet using information from sheets A-E. t...
-
Move rows to another sheet based on values in column A
Hello, I am trying to have rows in sheet "KEY" automatically moved to sheet "INACTIVE DRIVERS" if the cell in column A is "Inactive". I have looked...
-
Convert
Hello, Sir/madam how to convert 30-1-2009in words
-
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(...
-
Counting and stop counting in a cell
Hello, I need to create a formula for a cell involving number of days between dates. A2 - start date B2 - lead time C2 - end date D2 - showi...
-
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"...
-
Highlight cell if another cell contains specific text
Hello, I have random text in cell C6 that I would like to highlight green if cell N6 has 'yes', red if cell N6 has 'no', and grey out if cell N6 h...
-
change cell color of all cells in my formula
I often have huge spreadsheets where I have to add random cells together. In order to make sure I don't miss any cells, I want to change the color of ...
-
Excel formula to check if cell contains a date
Hello, Hi, I am trying to write a formula to check if there is DATE value in a particular cell. If there is a DATE value, need to say "DELETED...
-
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...
-
Create and populate sheets based on values in master list
I have seen a few similar forms but cannot seem to achieve the functionality I'm hoping for. My workbook will have a master spreadsheet that is per...
-
Formula to compare 2 columns and count missing values
Hello, I have an Excel spreadsheet where I want to compare values between two columns A and b and to see if any values are missing in column b. ...
-
Email notification when cells in a column are changed
Hello, I am trying to set up a macro to send an email when a cell changes in a certain column in excel. I used a conversation in this forum that g...
-
Conditional format B1 based on a specific word in A1 & calc
Hello, I would like to check how to use the conditional formatting to get a colored cell in B1 containing numbers (based on a "INC VAL" in Cell A1...
-
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...
-
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...