Office Software Forum
- Excel (9,746)
- Open Office (113)
- Outlook (639)
- PDF (334)
- PowerPoint (174)
- Word (2,185)
-
Generating new file with multiple sheet template
Hello, I have a file that is currently generating new files based on a template file + a list of names. The problem is that the file is generat...
-
How to Insert an Image into an Excel Comment Box (Mac)
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/faq/41701-how-to-insert-an-image-...
-
How to calculate position (1st,2nd,3rd) in excel....?
Hello, 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...
-
Office 365 error was deleted message without beaing read
hi I have office 365 when tracking the read receipt getting an error randomly not every time(was deleted without being read)
-
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...
-
Microsoft Word scroll bar issue
The vertical scroll bar disappeared in word. I now have a horizontal scroll bar at the bottom and it turns document pages. The wheel on the mouse is a...
-
Copy and autopast rows from sheet1 to sheet2 IF
Hello, I woul like to Copy and autopast rows from sheet1 to sheet2 IF they are f ex "highlighted" or "bold" or "underlined" is something lik...
-
Excel assistance; IF formula to calculate remaining balance
Hello, How do I write a formula in excel that says if any cell contains a certain value, then calculate a remaining balance?
-
i want to know the code
Hello, this is my code i try update the data automatically but the macro is not working of the updating part datetime auto_cycle tool time_differe...
-
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 ...
-
Copy & Paste
Hello, I copied Sheet1 Names( A2:A6) and select the Sheet2 Paste Names (B2). The same name paste entire (B) up to end row . If Sheet2 (A) ro...
-
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 ...
-
create excel spreadsheets that update from a master sheet
Good Morning I need to create a master list of individuals in a specific program on a master list that covers all counties in Maryland. I want to b...
-
when i am pressing spacebar dots are coming in word for windows 10
when I am pressing the spacebar dots are coming in word for windows 10
-
word 2007 in win 11
Hi I am new on here. My laptop just updated from win10 to win 11 & i opened my word 2007 program & got a box pop up with choose how to open - 1. xls ...
-
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...
-
Sorting table without messing up formulas
Hello, I'm trying to create an excel file to manage my diet and meal plan and counting macros. I have in the same file a table filled with differen...
-
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...
-
see all triggered animation before going to next slide in ppt
Hi All, I am building an elearning in ppt. Now I have added three triggered icons with information behind every icon when you click on the icon. Wha...
-
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...
-
Compare 2 sheets, 2 columns, copy/paste matching data to third sheet.
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
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
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 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 ...
-
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...
