Office Software Forum
- Excel (9,698)
- Open Office (111)
- Outlook (632)
- PDF (333)
- PowerPoint (172)
- Word (2,176)
-
Transfer Data from One Sheet to another based on an if/then condition.
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.
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 [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
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 ...
-
merge data across multiple sheets in one sheet and calculate the values
hi I have data in multiple sheets the same structure some sheets have duplicated data so it should merge and summing the value...
-
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...
-
Change cell list values when another cell is changed
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
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
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
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"
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...
-
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...
-
Command Button Launches Default Browser Via One Line of VBA Code
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
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?
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...
-
How do I fix Outlook Error 0x800ccc0f?
Hello, I am facing the Outlook Error 0x800ccc0f issue while incoming or outgoing MS Outlook messages. Please help me to resolve this error.
-
Forgot my security pattern lock
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
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
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...
-
Formula to find last date of attendance [Solved]
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...
-
Xodo PDF stops to work and xodo's window closes
Hi! I use xodopdf. Sometimes it stops to work and xodo's window closes, specially if I work with PDFs that have many pages (from 150 to 300 pages)...
-
Moving the data into previous cell by using excel formula or VBA code
hi all, I am working as Master data analyst. While working with data I got a problem, I have almost 10,000-row lines each having multiple col...
-
Unable to send/receive emails in Outlook 2016 after setting up Outlook 365 ?
Any suggestion?
-
How to copy cell value from one table to another table with Criteria [Solved]
Hi, Please help me with the below request. I would like to Copy the data from table1 (sheet1) to table2 (sheet2) based on the criteria "Yes" aut...
-
Sub-string Function in VBA
Dear Experts, I want to get the length of char and split the char with 30000. Below is the code. I'm stuck here to do further. Can you please help ...
-
Grades in excel [Solved]
Hello, How do i do the grades in Excel for example if a learner gets 70% how do i classify that using the symbols to grade the result
-
Create multiple copies of excel based on a single template [Solved]
Hello there, I need your help. I need to create multiple excel workbooks using a single template and saving them based on a list of names which ...
-
Need help: formula calculating values depending on value in drop down list.
I created a planning tool for my work. It's basically showing situation on a current week, put I need more from it for future planning and also, time ...
-
PDF editor for desktop like xodo pdf BUT with keyboard shortcuts for editing?
Hi! I am looking for: -A FREE PDF editor -For Desktop (Windows 10) -I use Xodo pdf and it is really good but it does not have shortcuts for ed...
-
Update Sheet 2: specific data is copy and pasted to next row on sheet1
Hello, Please Help! I would like to copy and paste daily data I get onto sheet two. Then using a macro button, copy and past select data from s...
-
How to fill Value in Cell if data is not available ? [Solved]
Dear All, Hope you are doing good! I would like to fill the product name as below in Cell if the nearby cell value is filled with some other te...
-
create report balances for many customers [Solved]
hi here this is the first post and I hope find what I'm looking for despite my request is not easy I have data in sheet1 contains...
-
How to store cell value in a variable excel vba OR Increase Cell Value in Excel [Solved]
Dear All, Excel is only able to store 32767 characters in one cell. But I retrieve the more than 50000 characters.So, I couldn't able to store i...
-
How to create a new sheet based on student Id numbers
Hello, I am trying to find a code that can make a new sheet based on my students name and ID number. I want to be able for the program to copy the...
-
Change colour of range of cells based upon text from a drop down menu in another [Solved]
Hi, I am trying to change the colour of a range of cells within a row if I choose an option from a drop down box within the same row and cell range. ...
-
Automatically Run Macro from a calculated cell value change [Solved]
Hello, I am not having any luck using this code(and haver tried others). Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address...
-
espacement différent entre les paragraphes, S.O.S! [Closed]
Bonjour à tous, mon problème est le suivant: j'écris un livre et de ce fait j'utilise la fonction "titres" pour distinguer des chapitres, je fais do...
-
Numbering increamental base on value in another colum
Hello, I have different numerical value in one column (say A column), I need to put serial number in another (B) column based in value in A colum...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get More Followers on Instagram
- How to Fix a Blurry Snapchat Video
- How to Recover Your Yahoo Account
- How to Install a VPN
- Facebook Code Not Received
- How to Disabled Write Protection on a USB
- Computer Boots to Black Screen
- How to Recover a Disabled Facebook Account
- How to Get Free Diamonds in Free Fire
- How to Create a Gmail Account
- How to Upload High Quality Photos to Instagram