The discussions
How can i make the 'false' statement remove if blank
SolvedHello, 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
SolvedHello, 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
SolvedHi 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
SolvedHello, 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
SolvedHello, 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
SolvedHi 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
SolvedHello, 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
SolvedHi, 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"
SolvedHello, please tell the vba code for increase invoice number to 103,leaving others same on opening worksheet
Command button launches default browser via one line of vba code
SolvedI 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
SolvedHello, 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?
SolvedDear 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
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
SolvedHello, 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...
Moving the data into previous cell by using excel formula or vba code
Solvedhi 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...
How to copy cell value from one table to another table with criteria
SolvedHi, 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...
Grades in excel
SolvedHello, 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
SolvedHello 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 ...
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 ?
SolvedDear 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
Solvedhi 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
SolvedDear 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
SolvedHi, 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
SolvedHello, 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!
ClosedBonjour à 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...
Auto copy data from sheet1 to sheet based on criteria
SolvedHello, I am trying to auto copy values from Sheet1, Col A to Sheet 2 only if criteria from Sheet1, Col b is met. I have tried so many different t...
To highlight or catagorize the data
Hi, I am willing to prepare the data under the catagory used and unused list checking the data table (data_plan) suppose C4A-R1 is placed in any ce...
Vba: copy row ---> lookup value ---> paste in table
Hello, I need help copying a row then lookup a value and paste the row next to the value that has been looked up, constructing a table. Thanks...
Transferring data
Hello, i am having trouble and hopefully someone can help me i am creating an invoice system for the company i am working for and i have created a s...
Vba new sheet and copy template
Hello, Im struggling abit. I want to make a button where I add a new sheet with a specific name. In this example, "App1". But I also want to c...
Calendrier
Bonjour, Voici ma demande puisque je ne parviens pas à solutionner le problème ! En vue de mon prochain championnat, j'ai refait un nouveau calend...
Modified code copy data from userform to the empty last columns
Solvedhello this is the first post in this forum and I hope finding solution here I got this code from the internet and works wel...
Information transfer
SolvedHello, I am trying to create a way for me to type in a part number as a list for tracking inventory and have the information (parts, description, ...
Rectify a specific value in specific rows from multiple sheets
Hello, I saw the answer given by Vcoolio that was very useful to me. And how to proceed with the rectification, on especific value, on rows from ...
Word unable opening
Hello, my pc in entire words opening wont properly. im using win7.
Copy rows to multiple sheets based on drop down validation
SolvedHello all, I have tried to find the answer to my query through other questions but can't put my finger on what to do. I would like to copy rows...
Macro that changes a row color at the change of each job number.
SolvedHello, I have a spreadsheet that is say 5000 rows long and 15 columns wide and contains production job numbers in Column A. The details associate...
Deleting specific rows from multiple sheets
Hello, I have a question on how to do something specific in excel. I have a workbook with 3 sheets. Sheet 1 contains a master list of records. ...
Auto-populating rows from master sheet into other sheets
Hello, I'm attempting to create a distribution list spreadsheet that will have all the names, emails, and agencies in one master sheet, and then h...
Export data from excel to microsoft project
Hi Guys, Could someone help me in telling a way to export the data from excel to Microsoft Project automatically without having to use the import w...
If function
Hello, I have done this function but it keeps saying false and that the formula is wrong even though I did what you suggested by using semi colo...
Lookup dropdown list value in a another sheet and copy row accordingly
SolvedHello, I am trying to find out if I can create a drop-down list in Sheet1 that when I make my selection, it will copy part of a row from Sheet2 on...
If a cell has a value, make another cell indicate the number 1.
SolvedHello, If I have for example, any data entered into cell f9, how would I enter a formula to make the next cell, f9, indicate 1 or any specific numb...
