Office Software Forum - solved topics
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
- Solved
-
Date of birth number to words Solved/Closed
Hello, 05/05/1981 How to write data of birth in word
-
Multiple Sheets to One Master Sheet Update Solved
Hello, We are a team of 8 who updates a single excel work sheet, and because of this, there is always information missing or overwritten by others et...
-
How can I fix Hotmail if it keeps freezing or crashing? Solved
I am using Hotmail and now my Hotmail keeps freezing or crashing. Please suggest reasons and solutions for it.
-
How can I format multiple presentations automatically? Solved
Hello, I have a lot of presentation and I want to format every ppt to the same font and rate automatically. How can I to do it?
-
How to calculate positions (1st,2nd,3rd...) in Excel Solved
Hello, hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i...
-
How to convert the tamil pdf file to tamil word file Solved
plz give the solution
-
i can not control the transitions in powerpoint in my file, Solved
Hello, the slides of my PowerPoint moves before the first slide finishes, and sometimes it takes ages to move to another slide. I would like the sli...
-
"Enter to add a blank slide" doesn't work anymore Solved
Hello, I used to be able to add a blank slide in PowerPoint by simply pressing the "Enter" key. For some reason, I found this function did not work a...
-
Coloring cells in sheet 2 based on data sheet 1 Excel VBA Solved
Hi! I would like to ask a question about using VBA for colouring a cell in sheet 2 based on a value of a cell in sheet 1. I want to write a code in ...
-
UDF for Attendance register Solved
Hello, I have used your UDF as shown below to report a date whenever an entry is made in a row of my excel sheet. Function LastAttendanceDate(mDate...
-
Formula to find last date of attendance Solved/Closed
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...
-
How Sum the Column value in Excel via VBA based on criteria? Solved
Hello All, I would like to sum up the column value based on the following criteria (TRUE or FALSE). I have a value in the "E" column and in the "F" c...
-
Unable to Reply to Emails Solved/Closed
Can someone advise me how to conquer this sudden difficulty? Emails arrive, I can read them, but when I click "Reply" nothing happens. Why? Than...
-
office 365 product key Solved
Hello, Hello. How to activate Office 365 product key. I couldn't do it :)
-
Apply Conditional Formatting Across Several Cells Solved
Hello, I want to change the color of a row if there is text in column A of that row. I have the following equation: "=AND(ISTEXT($A$2))" ... and I h...
-
How to add Rows automatically based on Cell Value In Excel? Solved
Hi All, I have a requirement to add the Rows Based On Cell Value In Excel. Below I have attached the snapshot of the requirement details. I have two...
-
populate values in textbox based on combobox ,optionbutton Solved
Hello, I have the items in column B in sheet1,2,3 and the prices in columns F,G for sheet1,2 and the prices for columns F for sh...
-
Running a macro in different cells Solved/Closed
Hello, I have a question. I recorded a macro to average a series of columns, highlight the averages row in a bold color. I would now like to run the ...
-
Generating invoice number automatic without repetition Solved
Hello, please I need help , I want VBA CODE to Generating invoice number automatic without repetition in my excel any time type in the next cell it...
-
Macro to automatically update a master sheet from multiple sheets Solved/Closed
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...
-
Working with multiple worksheets in a workbook Solved
Hello, I am completely new to all of this so please bear with me. I am new to forums and how they work so I apologize in advance if this is a repeat ...
-
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/Closed
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/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 ...
-
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 ...
-
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...
-
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...
