The discussions
How do i compare two worksheets where added value will copy to sheets3
SolvedHi, is it possible to get output as below where original in sheet1 and sheet2 will added 1 then in sheet3 it will sum the qty which previous qty is 2 ...
How to rank the last top ten students
SolvedHello.. Am a teacher.am preparing results of 126 student.. So I need to find the last ten students among those 126.
Vba code to copy worksheet multiple times and rename based on list
SolvedHello, New VBA user.. I have created code to copy a worksheet multiple times and rename based on a list in excel. However, I am receiving an e...
How can i change a cell daily
SolvedHello, I will try to explain the best I can, I have some cells 'A1, A2, A3, A4' that I fill up daily with numbers ex: -day1 I will input ...
Shared content between 2 cells on 1 sheet and on 2 sheets
SolvedHello, I have cell 'A1' and cell 'B1' How cand I do a formula so I can tipe something in A1 and B1 is the same content, but I would like it bouth w...
What will ms excel return when e2-f2 is entered in a cell?
SolvedHello, What will MS Excel return when E2-F2 is entered into a cell?
Pop message into textbox on userform if number is exceeded
Solvedhello I have userform contains multiple comboboxes and textboxes . the comboboxes1,2,3 should match with sheet data in COL B,C,D ...
Merge data across multiple sheets in one sheet and calculate the values
Solvedhi I have data in multiple sheets the same structure some sheets have duplicated data so it should merge and summing the value...
Grey out an entire row in excel 2010 depending on a cell's value
SolvedHi all, I am trying to grey out an entire row in excel 2010 depending on a cell's value. Each cell has a drop down list: Yes, No, Maybe etc ...
Multiple mathmatical calculations for profit
SolvedHi, I'm trying figure out how to create a formula to calculate profit from a row with multiple options. column n*o=a column p=b column q=c co...
Popup message when mandatory columns are not filled in a row in excel
SolvedHi All, Hope you are doing good! I want to popup an error message before saving. The requirements are for eg:- In this table, "Name & PhnNo" are ...
If cell l2 has text in it return date in j2
SolvedHello, Can anyone help with this? I am designing a Task Tracker. The user wants a Date and Time to auotgenerate when Text is entered into a Ce...
Copy automatically columns if the criteria is met
SolvedHello, I have simple workbook with 2 sheets. Sheet1 contains columns "Risk ID", "Risk" and "Response". Data would be for example ID1, "Cyber attac...
Job boards?
SolvedHi, I am new here, just signed up today. There was an issue I was having with excel and found the solution. The solution was pasted exactly as ...
Transfer data from one sheet to another based on an if/then condition.
SolvedHello there, I'm hoping to work with three lists (three sheets). First sheet, a master list, second sheet, a manager's list, third sheet, an emplo...
Finding certain words in a cell and return a value based off the word found.
SolvedHello, I need to find a certain word in a cell in a column and return text based on the value. Example of this is if the word Apple is in a cell in...
Excel macro/code help: creating sheet for each name in column of another sheet
SolvedHello! I am working on a project at my internship and ran into some issues finishing up some of the features I want to implement. The excel is a file...
Conditional formatting (office 2016)
SolvedHi Guys I want Excel to highlight cells(in a column) based on the value(text) I select from a drop-down list in another column. So each time ...
I have a '0' that need's to be gone
SolvedHello, I have a file with two sheets. In sheet2 I have cell A1 ='sheet1'!A1 (when I type something in cell A1 from sheet1 it's goes on A1 from shee...
How can i make the 'false' statement remove if blank
SolvedHello, I have this simple formula =IF(J15"",J15-H15) I have that formula alocated to G8 and I want it to work only when I type something ins...
Excel if range of cell contain a text put a cell value in
SolvedHi All, How do I put a cell value into a cell when the range of cell contain a specfic text. For example, in the sample below, I want to put the ...
Formula in excel for a date
SolvedHello, Hope you are well. Please assist me with the date calculation in Column E and Column F. The 2012/02/29 date should show (29) because for tax ...
Change cell list values when another cell is changed
SolvedHello, My calculations would go a bit further, and i don't really know if my issue can be solved by excel. I have multiple lists for speaker box...
Conditional formatting another cell based on text in a range
SolvedHi I have a spreadsheet where columns A,B,C contain text (a subject studied at school) e.g. Maths, Science, Geography. I have 170 rows of this data...
Finding file names in a local folder
SolvedHello, I have a large list of file names in excel worksheet. I am trying to find which of those files are NOT in the folder on the local drive...
Vba: use password to go to sheet
SolvedHi, I have a spreadsheet that is driven by VBA buttons that take you to different sheets, I need to password protect some of the sheets, but if an inc...
Command button launches default browser via one line of vba code
SolvedI have a userform that allows me to use a webbrowser within it, however sometimes due to compatibility issues I need to use microsoft edge and use it ...
Macro to compare 2 columns and output list with singles and sheet reference
SolvedHello, I am trying to write a macro to compare two different columns on two different sheets. and I want to print only the values that are not on ...
How to split the amount in excel formula or excel vba code?
SolvedDear All, Hope you are doing well!. I would like to copy the value in cell based on user input value. Below is the sample screenshot. The use...
Conditionally formatting if another column contains a specific date
SolvedHello, I have a spreadsheet where I am tracking requests. I want Excel to highlight the row if the item due date (column B) is NEXT month or has P...
Moving the data into previous cell by using excel formula or vba code
Solvedhi all, I am working as Master data analyst. While working with data I got a problem, I have almost 10,000-row lines each having multiple col...
How to copy cell value from one table to another table with criteria
SolvedHi, Please help me with the below request. I would like to Copy the data from table1 (sheet1) to table2 (sheet2) based on the criteria "Yes" aut...
Create multiple copies of excel based on a single template
SolvedHello there, I need your help. I need to create multiple excel workbooks using a single template and saving them based on a list of names which ...
How to fill value in cell if data is not available ?
SolvedDear All, Hope you are doing good! I would like to fill the product name as below in Cell if the nearby cell value is filled with some other te...
Create report balances for many customers
Solvedhi here this is the first post and I hope find what I'm looking for despite my request is not easy I have data in sheet1 contains...
How to store cell value in a variable excel vba or increase cell value in excel
SolvedDear All, Excel is only able to store 32767 characters in one cell. But I retrieve the more than 50000 characters.So, I couldn't able to store i...
Change colour of range of cells based upon text from a drop down menu in another
SolvedHi, I am trying to change the colour of a range of cells within a row if I choose an option from a drop down box within the same row and cell range. ...
Automatically run macro from a calculated cell value change
SolvedHello, I am not having any luck using this code(and haver tried others). Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address...
Auto copy data from sheet1 to sheet based on criteria
SolvedHello, I am trying to auto copy values from Sheet1, Col A to Sheet 2 only if criteria from Sheet1, Col b is met. I have tried so many different t...
Modified code copy data from userform to the empty last columns
Solvedhello this is the first post in this forum and I hope finding solution here I got this code from the internet and works wel...
Information transfer
SolvedHello, I am trying to create a way for me to type in a part number as a list for tracking inventory and have the information (parts, description, ...
Copy rows to multiple sheets based on drop down validation
SolvedHello all, I have tried to find the answer to my query through other questions but can't put my finger on what to do. I would like to copy rows...
Macro that changes a row color at the change of each job number.
SolvedHello, I have a spreadsheet that is say 5000 rows long and 15 columns wide and contains production job numbers in Column A. The details associate...
Lookup dropdown list value in a another sheet and copy row accordingly
SolvedHello, I am trying to find out if I can create a drop-down list in Sheet1 that when I make my selection, it will copy part of a row from Sheet2 on...
If a cell has a value, make another cell indicate the number 1.
SolvedHello, If I have for example, any data entered into cell f9, how would I enter a formula to make the next cell, f9, indicate 1 or any specific numb...
Excel conditional formating using formula
SolvedHi All Agian, I have a table with a list of customers and i have columns with the months and on each month i enter the visit day. I want to format...
Macro that copy/pastes rows based on a certain condition on same sheet.
SolvedHello, I am trying to create a macro that will copy a row with 6 columns on the condition that the 6th column is blank. Then it should paste the r...
How to combine if, and, or functions
SolvedIncrement the backers count by 5 if: The launched at month is January OR September The city is Vancouver AND the country trimmed is Canada If these...
How to convert an attached image to base64 format.
SolvedHi All, Hope you are doing good! I would like to convert the attached image into Base64 format in excel via VBA. Is it possible to change the i...
How to make a running balance column from a credit column and a debit column
SolvedHello, I am trying to create a running balance column from credit column and debit column. Everything that I have found regarding running balances on...