Excel Forum
-
VBA code: calculating time difference Closed
Hello, this is my code i try update the data automatically but the macro is not working of the updating part datetime auto_cycle tool time_differe...
-
How can I link optionbutton and textbox based on selected from combobox Solved/Closed
Hello, hi actually I got this codes from another web and mod some . it succeed and works , but my question how should link with the others tools ...
-
Copy & Paste Closed
Hello, I copied Sheet1 Names( A2:A6) and select the Sheet2 Paste Names (B2). The same name paste entire (B) up to end row . If Sheet2 (A) ro...
-
Multiple IF arguments Solved/Closed
Hello, I am trying to get Excel to look at data in two cells and depending on the combination it finds in those cells, record a different TRUE sta...
-
add missing data before TOTAL row after matching between two sheets Solved/Closed
Hello, I'm new begginer in vba and I hope some help I have data in two sheets . should match data beween them. the match depend in COL ...
-
create excel spreadsheets that update from a master sheet Closed
Good Morning I need to create a master list of individuals in a specific program on a master list that covers all counties in Maryland. I want to b...
-
Code to move rows into another sheet based on certain values Solved/Closed
Hello, I've seen different variations on this question, but haven't seen any answers that specifically address moving rows based on multiple value...
-
cell value = sheetname to pull information from in excel formula Solved/Closed
I am trying to pull data from another sheet using the formula (located in B26) below, but I want to replace the sheetname ('9.60'! in this case) with ...
-
Return Seq Values Until Blank value then return different set of seq values Solved/Closed
Hello, What is a formula to return a specific set of values in sequential cells until the reference sequence returns a blank value then start return...
-
Sorting table without messing up formulas Closed
Hello, I'm trying to create an excel file to manage my diet and meal plan and counting macros. I have in the same file a table filled with differen...
-
how deal with this complicated code and updating(subtraction between two sheets) Solved/Closed
Hello, I need help from experts to updating this complicated code . I know this way is very complicated to subtracting the item...
-
I want to find date of joining Solved/Closed
Hello everyone i have a attandance sheet like this i want to find date of joining by formula. Mean on which date from 1 to 31 he started to work i w...
-
Compare 2 sheets, 2 columns, copy/paste matching data to third sheet. Closed
Hello, In response to this link https://ccm.net/forum/affich-756470-comparing-two-excel-sheets-and-copying-like-data-to-third-sheet I am using...
-
i need to find date of joining Closed
Hello, i have a worker attandance register of 100 employess and i want to find there joing date to the sheet from which date they started to work .as ...
-
How do I compare two worksheets where added value will copy to sheets3 Solved/Closed
Hi, 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 Solved/Closed
Hello.. 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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 Solved/Closed
Hello, 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? 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 ...
-
Duplicating rows multiple times in excel Closed
Hello, I have a sheet with over 800 rows. I need to copy each row and insert/repeat each entry 4 times below the preceding row. Example: Befo...
-
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...
-
Training Delivery Tracking Help Closed
Hello, This question is a follow-up to another question I asked here and uses the same/similar files, code, and format as that question (at least in...
-
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 ...
-
highlighted unmatched data between two sheets and merge data in summary Closed
Hello, I have two sheets contain data from COL A: COL G if there are new data in sheet1 but are not existed in sheet2 th...
-
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 ...
-
VLOOKUP problem Closed
Hi ! I have an excel document where I'm trying to use a VLOOKUP formula, however it refers to N#A whereas the value actually is in the column. I...
-
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...
-
Algorithm and Flowchart Closed
Hello, Write an Algorithm and flowchart to calculate total number of students passed in first division, second division and third division in ...
-
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...
-
split data from multiple sheets to tables for summary sheet based on dropdowns Closed
Hello, I have data about five sheets sometimes contain the same data are duplicated then should merge and summing the values as show in sheet summar...
-
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 ...
-
Download excel worksheet with formulas (calculation VAT inclusive) Closed
The simple Excel formulas (calculation VAT inclusive) Hi there how do I download this example so I can work on it? Thanks Philip
-
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...
