Office Software Forum
- Excel (9,854)
- Open Office (118)
- Outlook (652)
- PDF (337)
- PowerPoint (187)
- Word (2,189)
-
Transfer data between spreadsheets based on matching headers Closed
Hi, My use case is to transfer data from "Sheet 1" to "Sheet 2" within same workbook based on matching headers. If header: Addresses appears in ...
-
Where can I download a free Word document to PDF converter Solved/Closed
looking to download a free word to PDF converter
-
Formula to find the base amount Closed
Hello, I have new taxation laws that apply my organization from January. The current taxes are 10% +10% So if it was 100 it came upto 120 ...
-
Percentage calculation Closed
Hello, How to know the percentage. Example total bill amount is Rs. 25000 and we are paying Rs.18000. Can u please help me find how to get the perc...
-
Cell Formatting Closed
Hi How do I get the cells I am typing in today to turn blue? With historic date remaining black?
-
Comparing data between two excel sheets Solved/Closed
Hello, I have two excel sheets with the same columns. Essentially Name, Email, Phone. One sheet is the 'original" data and the other is the "upd...
-
Conditional formatting with multiple rules Closed
Hi, This is probably really simple, but I can't get it to work! I need excel to change a cell to red if the due date on that cell is before today'...
-
How to: When a column has 1 of 3 values, copy text Closed
Hello, I have an Excel book with 2 sheets (1 has a macro view and 1 has a micro view). The micro view sheet has a column B where the user enters a...
-
Transferring data between tabs Closed
Hi I need the formula to transfer data from one tab to another of certain cells in a row if one of the cells has a keyword in it
-
Match Function Closed
Hello, I have a spreadsheet with names in two columns and when I try to identify there is a match in column A for a name in column F, sometimes it...
-
Change a cell color in Excel once it is activated Closed
Hello, I have a little program in a Book with two sheets one called DATA and another called FORM, in this sheet I have placed the formula =DATA!$A$8...
-
If cells match 3 criteria return the data already in 3 others Closed
Hello, Hi, very basic knowledge but I have a sheet which my team can pick the name of an inspector on a drop down from a list of 5, the date they ...
-
What does this excel formula mean? Closed
Hello, Wondering if someone can assist and tell me what the following excel formula is doing: =IF($C$68$D$98,$D$98,N12),0) Context: Foreca...
-
Corrupt Powerpoint file, the file extension does not match the I Solved/Closed
Hello, I have several PowerPoint presentations that I can't open them now it says " file may be corrupted when use PowerPoint or expansion file ma...
-
excel document in trouble Closed
One of our very costly excel documents unluckily stopped correctly viewing. We have not very huge company. I’ve no any good or worthy idea what I can ...
-
How to copy only specific cells? Closed
I am attempting to create a document that will distill necessary information on a contract and spec sheet without having to do all the meticulous typi...
-
Combobox select add values in other column in new cell Closed
Hi I have a set of Comboboxes populated with the same 3 text values in each one. I also have a column of numeric in the same rows as each combobo...
-
Autopopulating multiple sheets from one main sheet Closed
Hello, I am trying to create a spreadsheet that uses one Master sheet (called Master), and then populates other worksheets with the data from that...
-
Numbering Create Automatically Closed
PO Number Qty In PO Total Quantity In PO I Need Numbering Like This 1111 1 1 1/1/1 2222 ...
-
Excel - IF conditions Closed
Hi All, I am trying to create a formula to show the outcome of a status based on 4 conditions. 1. IF cell A2 = Approved and B2 = Approved then C2 ...
-
How to Copy Formatted Text Data over excel rows Closed
Hello, I need help with the following I have Git formatted patches data in the Text file.(and there are N number of patches), which I need to ...
-
Copy and paste cells to a new sheet - Cells are defined by condi Closed
Hello, I have got a sub with a condition. If the condition is True, I want cells from one column to be copied to a column in another sheet Firs...
-
exception report using the if statement.im using one pivot table Closed
Hello, Hope you well i need help urgent. Im trying to do an exception report using the if statement.im using one pivot table. But from that on...
-
How to automatic copy a row in a file to another file Closed
Hello, I have a lot of excel files with sales project title that I fill a row in them every day, write my calling or visits reports. My manager also...
-
product key Closed
Hello, where can i find the product key to proceed further. System Configuration: Windows / Chrome 50.0.2661.102
-
file permission error Closed
Hello, i cannot save a file in microsoft word due to file permission error, how do i fix it? System Configuration: Windows / Firefox 57.0
-
help in sd card's password Closed
Hello, I have lost my micro SD card password in my blackberry z3 pls if there is someone who is able to help me, may do that. System Configurat...
-
Formula help! Closed
Hello, I need a formula that will sum a row based on the column header. I need B5:DC5 to sum based on b4:DC4. B4:DC4 has calls, apps, %. these ...
-
Similar data from groups Closed
Hello, Looking to see what similar data are in groups of data... In the example below, Group 1 Participant 1 selected 65. I need to know from oth...
-
How to create serial numbers Solved/Closed
Hello, I have an excel format shows different values of schedule of correspondence and some of the mails are gone to different addresses and the ma...
-
I have the key, but can't download Microsoft Office 2010 Closed
I have the key, but can't download Microsoft Office 2010 on my new computer (Windows 10). Will be grateful for any advice.
-
Find word in a column from list of words and report word found Closed
Hello, I have a large data set that I would like to search one column that contains sentences or purchases. I'd like to search from a group of wo...
-
my intex basic phone . Closed
Hello, Sir I forget my Intex basic phone how to unlock the mobile.password 8 numbers System Configuration: Android / UC Browser 10.10.5.809
-
Conditional formatting dates Closed
Hi I am trying to format a date column on my spreadsheet and just can't see to get the formula right Simplified, I have 2 columns, one with a deadli...
-
Formatting cell Solved/Closed
Hello, I want to highlight the coloumn B, if the coloumn A is greater than 0, In column A having numbers and the column B having texts. here so...
-
Using one value to populate multiple columns Closed
Hello, Hi sir am in need of urgent assisstance. I need to populate one value into multiple sheets in excel foe multiple rows... Ex if i enter a va...
-
Macro that extracts info from changing number of worksheets Closed
Hello, I'm trying to find a way to insert a summary of several worksheets (I'm calling them analysis logs), but want to make it in such a way th...
-
Drop down look up Solved/Closed
Hello all, I have a 40 sheet workbook. I want to hide 39 of the tabs and use one sheet as the "master" to pull all of the data. I have the tabs in ...
-
Automatically update master worksheet from other worksheets Solved/Closed
Okay, first I should mention that I'm a complete amateur when it comes to excel. No VBA or macro experience, so if you're not sure whether I know some...
-
Problem getting a sum of cells from one sheet to another Closed
Hello, I'm trying to create two spreadsheets, one with daily totals on it and one with weekly and I'd like for the weekly totals to automatically ...
-
Help- conditional cell formatting Solved/Closed
Hello, I am trying to do some conditional formatting and having a little trouble. Here is what Im looking to get. I have a column A (estimated ...
-
Can't open office website for sign in Closed
good day I just bought a new laptop HP pavilion with intel i3. I also purchased Microsoft office 365 for one year from best buy. I want to register ...
-
Transfer data to individual sheets from Master sheet. Closed
Hello, I am currently building a worksheet to track where cars are at a certain time. I have three places the car could be (west bullpen) (East Bu...
-
Sum a columns depending on pattern Closed
Hi, I need help in adding the mileage of cars. the rule is simple.. start adding the miles from cells that contains "Movement Start" until "Movemen...
-
Transfer data from one sheet to another sheet in designate area Closed
Hello, I'm working on create a hold record document for our company to label things we need to put on hold. In sheet 1, I have columns for Hold nu...
-
Copy Paste to another sheet with conditions Closed
Dear all, I wanted to copy all the data inside this "form" through the button "send". As you can see I also have two list boxes and I only wa...
-
Group Duplicates and move to new worksheet Closed
Hello, I have a data file and here's what i'm trying to accomplish as efficiently and automated as possible because I will need to repeat this dai...
-
date formatting Closed
Hello, how to convert dates between 1-Jan-17 to 7-Jan-17 single date as 7-Jan-17 using formula System Configuration: Windows / Chrome 62.0.3202...
-
If then statement for switching numbers Closed
How do I use the excel to basically score a survey! I want my code to say if qs: # 1 has score 1 then its 4 , if 2 then its 3 , if 3 then it's 2 , if ...
-
Trying to update date range every month Closed
We have a spreadsheet I'm creating for a recon that we can just input the new date every month (last day of each month) and end up with a description ...