Office Software Forum - solved topics
- Excel (9,746)
- Open Office (113)
- Outlook (639)
- PDF (334)
- PowerPoint (174)
- Word (2,185)
- Solved
-
Formula in excel to show amount in cell Solved
Hello, I need a formula that show the amount in another cell if some text is found in another cell. Like this; A2: 500 B2: Done C2: result t...
-
How can I link optionbutton and textbox based on selected from combobox Solved
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 ...
-
Multiple IF arguments Solved
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
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 ...
-
Code to move rows into another sheet based on certain values Solved
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
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
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...
-
how deal with this complicated code and updating(subtraction between two sheets) Solved
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
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...
-
How do I compare two worksheets where added value will copy to sheets3 Solved
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
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
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
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
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
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
hello I have userform contains multiple comboboxes and textboxes . the comboboxes1,2,3 should match with sheet data in COL B,C,D ...
-
Create folder in desktop with vba, if exist, ignore Solved
Hello, 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...
-
merge data across multiple sheets in one sheet and calculate the values Solved
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
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
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
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
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
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
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
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...
-
Letter changing Solved
Hello, how to Tamil pdf change to Word
-
Excel Macro/Code help: Creating sheet for each name in column of another sheet Solved
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
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
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
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...
-
Help with wps to docx files Solved
Hello, I tried to save a wps file from cloud that was sent to me. Now, I have a problem with downloading it as a docx file. Do I need to download it...
-
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
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
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
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
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
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...
-
Auto increase invoice number in this format "TE/2021-22/102" Solved
Hello, please tell the vba code for increase invoice number to 103,leaving others same on opening worksheet
-
Command Button Launches Default Browser Via One Line of VBA Code Solved
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
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
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
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...
-
Formula to find last date of attendance Solved
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...
-
Moving the data into previous cell by using excel formula or VBA code Solved
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
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...
-
Grades in excel Solved
Hello, How do i do the grades in Excel for example if a learner gets 70% how do i classify that using the symbols to grade the result
-
Create multiple copies of excel based on a single template Solved
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
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
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...
