Excel Forum - solved topics
- Solved
-
What will MS Excel return when E2-F2 is entered in a cell? Solved/Closed
Hello, What will MS Excel return when E2-F2 is entered into a cell?
-
pop message into textbox on userform if number is exceeded Solved/Closed
hello 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 Solved/Closed
hi 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 Solved/Closed
Hi 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 Solved/Closed
Hi, 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 Solved/Closed
Hi 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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? Solved/Closed
Hi, 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. Solved/Closed
Hello 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. Solved/Closed
Hello, 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 Solved/Closed
Hello! 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) Solved/Closed
Hi 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hi 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hi 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 Solved/Closed
Hello, 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 Solved/Closed
Hi, 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 Solved/Closed
I 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 Solved/Closed
Hello, 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? Solved/Closed
Dear 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 Solved/Closed
Hello, 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 Solved/Closed
hi 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 Solved/Closed
Hi, 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 Solved/Closed
Hello 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 ? Solved/Closed
Dear 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 Solved/Closed
hi 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 Solved/Closed
Dear 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 Solved/Closed
Hi, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
hello 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 Solved/Closed
Hello, 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 Solved/Closed
Hello 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. Solved/Closed
Hello, 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 Solved/Closed
Hello, 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. Solved/Closed
Hello, 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 Solved/Closed
Hi 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. Solved/Closed
Hello, 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 Solved/Closed
Increment 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. Solved/Closed
Hi 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 Solved/Closed
Hello, I am trying to create a running balance column from credit column and debit column. Everything that I have found regarding running balances on...
-
Populate multiple tabs in an excel spreadsheet based on changes to main tab Solved/Closed
We have an Inventory Issued spreadsheet with the main tab listing all of our supplies, prices for each supplies and beginning inventory, number of ite...
-
Data entered in one sheet automatically appearing in a master sheet Solved/Closed
I have an inventory workbook with 5 worksheets inside; One of the sheets is a master listing all inventory items. The others are dedicated to type of ...
-
IF formula for a date range Solved/Closed
I have two columns, booked date and las rev date for 2021 If the dates in these two columns are between Jan 1 - 24 then it would be a jan report date...
-
Conditional Formatting: Font color for entire column based on another column Solved/Closed
Hi! I would like to format an entire column so that if there is any entry in column B (in the same row) the font in column A will be blue, if there...
-
Clear cell contents based on value of another cell range using VBA Solved/Closed
I'm new to all of this and I'm stumbling through as best as I can so forgive me if I don't explain this very well. I have a workbook that has over ...
