Office Software Forum
- Excel (9,698)
- Open Office (111)
- Outlook (632)
- PDF (333)
- PowerPoint (172)
- Word (2,176)
Results 1 - 50 of about 2,590
Back to the forum | Top |
- Solved
-
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...
-
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...
-
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...
-
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 ...
-
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...
-
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...
-
Auto copy data from sheet1 to sheet based on criteria [Solved]
Hello, 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...
-
modified code copy data from userform to the empty last columns [Solved]
hello 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 [Solved]
Hello, 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, ...
-
Date of birth number to words [Solved]
Hello, 05/05/1981 How to write data of birth in word
-
Copy Rows to multiple sheets based on drop down validation [Solved]
Hello 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. [Solved]
Hello, 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...
-
Lookup dropdown list value in a another sheet and copy row accordingly [Solved]
Hello, 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. [Solved]
Hello, 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...
-
Excel Conditional formating using formula [Solved]
Hi All Agian, I have a table with a list of customers and i have columns with the months and on each month i enter the visit day. I want to format...
-
Macro that copy/pastes rows based on a certain condition on SAME sheet. [Solved]
Hello, I am trying to create a macro that will copy a row with 6 columns on the condition that the 6th column is blank. Then it should paste the r...
-
How to combine IF, AND, OR functions [Solved]
Increment the backers count by 5 if: The launched at month is January OR September The city is Vancouver AND the country trimmed is Canada If these...
-
computer master password needed [Solved/Closed]
Hello, my inspiron 1420 needs a system authentication password and ive tryed so many times to open it bt I need a master password plaese help me than...
-
How to convert an attached image to Base64 format. [Solved]
Hi All, Hope you are doing good! I would like to convert the attached image into Base64 format in excel via VBA. Is it possible to change the i...
-
How to make a running balance column from a Credit column and a Debit column [Solved]
Hello, I am trying to create a running balance column from credit column and debit column. Everything that I have found regarding running balances on...
-
Populate multiple tabs in an excel spreadsheet based on changes to main tab [Solved]
We have an Inventory Issued spreadsheet with the main tab listing all of our supplies, prices for each supplies and beginning inventory, number of ite...
-
Data entered in one sheet automatically appearing in a master sheet [Solved]
I have an inventory workbook with 5 worksheets inside; One of the sheets is a master listing all inventory items. The others are dedicated to type of ...
-
IF formula for a date range [Solved]
I have two columns, booked date and las rev date for 2021 If the dates in these two columns are between Jan 1 - 24 then it would be a jan report date...
-
How to convert the data from PST to EML? [Solved/Closed]
I'm not getting exact solution for this
-
Conditional Formatting: Font color for entire column based on another column [Solved]
Hi! I would like to format an entire column so that if there is any entry in column B (in the same row) the font in column A will be blue, if there...
-
Clear cell contents based on value of another cell range using VBA [Solved]
I'm new to all of this and I'm stumbling through as best as I can so forgive me if I don't explain this very well. I have a workbook that has over ...
-
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...
-
Splite the multiple column value copy & paste in other sheet [Solved]
Hello, I want to copy & paste the value of my data sheet, value are save in column & row, i want to splite the spacific rage of column value copy & ...
-
Copy data from one worksheet to another using spec criteria [Solved/Closed]
Hello, I have tried to "customize" other answers similar to this question to fit what I need but I am new to the whole macro thing. I have only use...
-
Where did page numbers go? [Solved]
Hello, I am trying to set page numbers and from youtube videos, there should be a list of different designs showing here but it is not? How do I...
-
fixing populating values into textboxes based on showing data in listbox [Solved]
hello I need help about showing wrong values in textbox(credit , debit & balnce) , it should show right value textbox (debit ) based o...
-
Matching 2 sheets [Solved]
I'm driving myself mad trying to figure this out. I have 2 sheets. I need to match First & Last name on both sheets. If the name matches, then I need...
-
Automatically replacing a value in an excel report [Solved]
Hello, I have a CAB Report template with a column called "Change Type" When I extract information the data in this column comes in as either Normal...
-
Use of IF [Solved]
Hello, Guys I am new to excel but I got a complex situation at work. Hope someone can help. I want a formula where if I change the date in one ...
-
HUGE Inventory Assistance - duplicate a row based on a cell value or quantity [Solved]
I have an inventory list that will end up being ~60k rows of data based on the sum of Col1. tab name - "inventory" Col1 - original quantity Col...
-
Match partial text string in one sheet to another text string in another sheet [Solved]
Hi All, I have two different sheets. In one sheet, I have last names. In the other sheet, I have a column that has cells that contain the person's la...
-
Quel bouton utilise cette sous-routine? [Solved]
Bonjour à tous, et merci de lire ma question. Voilà, je dois maintenir un vieux classeur excel qui présente des dizaines de boutons (je suis sous Exc...
-
modified code sum repeat data [Solved]
hello actually i search code to sum repeat values and i have about 2000 rows so that's why i do that by code instead of ...
-
Changing values in one cell depending on drop down list values in another cell [Solved]
Hello, I have created a drop down(pick list) in cell A1. In cell B1 I want it to show a specific number value based on which selection has been chos...
-
Loop through range to create new files with dynamic subfolders [Solved]
I would like to have suggestions for a VBA code that does this: Generate an Excel file for each contract number. When copying the contract number t...
-
Restore setting password for G'Five H91 [Solved/Closed]
Hello, I want to run restore setting on my G'Five H91 hendset, but I dont know what is the password use for it, Please Help Configuration: Wind...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get Free Diamonds in Free Fire
- How to Fix a Blurry Snapchat Video
- How to Upload High Quality Photos to Instagram
- How to Get More Followers on Instagram
- Facebook Code Not Received
- How to Create a Gmail Account
- How to Recover a Disabled Facebook Account
- How to Install a VPN
- Computer Boots to Black Screen
- How to Disabled Write Protection on a USB
- How to Recover Your Yahoo Account