Office Software Forum
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
Multiple logic formula Closed
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...
-
Xodo PDF stops to work and xodo's window closes Closed
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 Solved/Closed
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...
-
How to copy cell value from one table to another table with Criteria Solved/Closed
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 Closed
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/Closed
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/Closed
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. Closed
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 Closed
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/Closed
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/Closed
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/Closed
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 Closed
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/Closed
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/Closed
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 Closed
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 Solved/Closed
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...
-
to highlight or catagorize the data Closed
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 Closed
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...
-
match between two sheets and create summary Closed
hello I'm a beginner in vba excel so I hope find assistance from the experts I have two sheets names are(sheet1,sheet2) I would compare data i...
-
Word 2007 - Lost my product key Closed
Hello, I lost my product key for my office word 2007
-
transferring data Closed
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...
-
How to import multiple texte files to multiple Excel files using Power Query Closed
Hello to All Need for help to import multiple csv/txt files to multiple Excel Sheets/files using Power Query Thanks
-
VBA New sheet and copy template Closed
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 Closed
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 Solved/Closed
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/Closed
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, ...
-
Rectify a specific value in specific rows from multiple sheets Closed
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 Closed
Hello, my pc in entire words opening wont properly. im using win7.
-
Copy Rows to multiple sheets based on drop down validation Solved/Closed
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/Closed
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...
-
Deleting specific rows from multiple sheets Closed
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 Closed
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 Closed
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 Closed
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 Solved/Closed
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/Closed
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/Closed
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/Closed
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...
-
Help with Average/Lookup forumlas Closed
I need help with a formula that will average numbers that meet a certain criteria. . I need break down the average results for each teacher and facili...
-
How to combine IF, AND, OR functions Solved/Closed
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...
-
Copy row to another sheet if two (2) criterium are true Closed
Hello, I have a worksheet with seven columns. I need to copy some information to another sheet if b2 is a certain color AND g2 contains contains c...
-
FALSE in Excel spreadsheet Closed
Hello, I wonder if anyone can tell me why I am getting a 'FALSE' entry from the following formula: - =IF($E$3=Sheet1!$A$1,Totals!E6,IF($E$3=She...
-
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/Closed
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/Closed
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/Closed
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...
-
Microsoft Power Bi Closed
I have two sets of data -Data A and Data B. The data is a time range - Entry in and Exit. I need to compare my two sets of data, within Power Bi to d...
-
Copy multiple cells info from sheet if value greater than 0 in another cell Closed
I'm trying to go row by row for a range (c3:c177) to move information from multiple cells in that row that are not grouped together on one sheet to an...
