Office Software Forum - solved topics
- Excel (9,813)
- Open Office (114)
- Outlook (643)
- PDF (334)
- PowerPoint (181)
- Word (2,187)
- Solved
-
Macro to automatically update a master sheet from multiple sheets Solved
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...
-
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(...
-
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"...
-
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...
-
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...
-
Autogenerate alphanumeric ID numbers in Excel? Solved
Hiya! Let me start off by saying I am NOT a tech person so I don't even know if this is possible. I am trying to create an excel sheet where I can ...
-
search across all open workbooks for user defined criteria Solved
Here is my problem - we store info into files that use an index number (changes with each file created) plus 2 criteria to keep track as we produce ma...
-
auto-fill items repeatedly for two sheets based on another Solved
Hello, I have two sheets(FIL1,FIL2) should auto fill some items into column A repeatedly . it depends on sheet REP after matching based on colum...
-
Copying a row based on a integer in a cell Solved
Hello, I am needing help making a macro that will allow me to do a number of things, that may or may not be able to be done with one single macro. (...
-
how split column into multiple columns for multiples sheets Solved
Hello, I need macro to split column C for sheets REP1,PROC1 into columns C,D,E based on matching column B with column B into sheet RP ...
-
match & add missed items between two sheets Solved
Hello, I have two sheets contain the same structure of data . the result should show in column B,C into sheet2 based on matching with sheet1 . ...
-
How to add rows that meet specific conditions Solved/Closed
Hi Every week at work we get data about new jobs that have been completed at our company, and I add that data to a raw data tab. In the summary tab...
-
Changing values in one cell depending on drop down Solved
Hello, I created a drop-down list of scores (ie. 10, 20, 30 to 100) in cell A1. In cell B1 I want it to show a specific number value based on which...
-
Conditional formatting: change fontcolor based on another cell Solved/Closed
Hello, I have "text" in cell B1. However, I want the font color to change based on the numerical value in cell B8; so if the number in cell B8 ran...
-
Excel formula with changing rows going in order Solved
I am mapping one cell to another spreadsheet and I trying to figure out how to change the row without having to manually change each line. For example...
-
IF function: Conditionally multiplying a value Solved
Ok so I am trying to create a formula that would use a different calculation based on an answer. So when I get the number 2 in a cell then the data us...
-
If cell = date return yes or no. Solved/Closed
Hello, I need an excel formula that tells me if a a cell = a date to return yes or no. I tried =IF(I12=TRUE, Yes, No) and =IF(I12=DATE, Yes, No) ...
-
copy adjacent Columns in excel if the ID numbers same Solved
Dear all, I have ONE HELP in excel to copy two columns data( Qty & Amount ) from another sheet if the ID numbers are same.. I have created one...
-
If cell contains multiple text how to add other cell value? Solved
Hello, I am struggeling with my excel sheet and need help. I will rather give it in an example. A1 and B1 contains a price, C1 contains three s...
-
How to Insert an Image into an Excel Comment Box (Mac) Solved
Hi I'm on Mac with Excel 16.53 and I want to insert an image into a comment box. I read this : https://ccm.net/apps-sites/software/4079-how-to-i...
-
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...
-
Exporting action buttons into MP4 Solved
Hello, I have created a powerpoint presentation with an action button to "click here to open a report". When I export the ppt to MP4 the butto...
-
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/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
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 ...
-
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/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...
-
Letter changing Solved/Closed
Hello, how to Tamil pdf change to Word
-
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...