Office Software Forum
- Excel (9,723)
- Open Office (111)
- Outlook (635)
- PDF (334)
- PowerPoint (173)
- Word (2,181)
-
Macro Issue
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...
-
Exporting action buttons into MP4
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 deal with this complicated code and updating(subtraction between two sheets)
Hello, I need help from experts to updating this complicated code . I know this way is very complicated to subtracting the item...
-
How do I compare two worksheets where added value will copy to sheets3
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
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 to convert excel to pdf in tamil font
Hello, how to convert excel to pdf in Tamil font
-
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
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?
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 ...
-
Duplicating rows multiple times in excel
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]
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...
-
Training Delivery Tracking Help
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
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
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...
-
Best way to Open Archive PST Files
Anyone........
-
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 ...
-
VLOOKUP problem
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]
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
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]
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...
-
i need to find date of joining
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 ...
-
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...
-
Microsoft Word letters typing over each other
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]
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...
-
HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS
In creating an excel app to calculate the aggregate for students in their exams as used by WAEC to determine the student aggregate in BECE . The Excel...
-
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
-
split data from multiple sheets to tables for summary sheet based on dropdowns
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]
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)
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]
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)
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]
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...
