Office Software Forum
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
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 ...
-
Exporting action buttons into MP4 Solved/Closed
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/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...
-
Create folder in desktop with vba, if exist, ignore Solved/Closed
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...
-
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...
-
One Word Sentences Closed
Hello, newby here, I've been doing a lot of research lately which involves cutting and pasting paragraphs from online articles, books etc. I'm trying...
-
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...
-
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...
-
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...
-
Help with wps to docx files Solved/Closed
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/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...
-
Microsoft Word letters typing over each other Closed
Hello, How can I fix the above issue? I was typing a Word document and suddenly I see the letters typing over each other.
-
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...
-
Auto increase invoice number in this format "TE/2021-22/102" Solved/Closed
Hello, please tell the vba code for increase invoice number to 103,leaving others same on opening worksheet
-
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 read data from solar system (API) Closed
Hello, We have a solar panel system from the "solar edge" brand. Does anyone know how i can get the data in powerpoint preferably real time? I...
-
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...
-
Forgot my security pattern lock Closed
Hello, Hello, Forgot my security pattern lock? What can i do when i forget my unlock pattern of my gfive mobile? I forget my unlock pattern of ...
-
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...
-
Multiple logic formula Closed
Hello, I have 2 columns with separate pieces of information: Column A = Wood or Plastic Column B = 1 or 2 How do I build a formula which ca...
