Office Software Forum
- Excel (9,685)
- Open Office (111)
- Outlook (632)
- PDF (333)
- PowerPoint (171)
- Word (2,172)
-
auto populating sheets from data in main two sheets [Closed]
Hello i have found VBA code from auto populating data from excel main sheet to new sheets for each record in main sheet column, i need code to crea...
-
Loop for the Recorded Macro [Closed]
Hello, I have recorded the below Macro. All i want is to Loop till the end. Sub MainTranspose() ' ' MainTranspose Macro ' ' Keyboard Short...
-
Can I have any training to using excel? [Closed]
I wish to learn how to use excel
-
copy two sheets data in new work book with two sheets. [Closed]
Hello, I have a work book like.... Sheet 1: It has student detials (Enrollment No, Name, father name, Dob, Date of Joining). count of "N" Student...
-
How to use IF statement to add 1 to total? [Closed]
My question is slightly different: RANDOM calculation is created in cell J20 by pressing F9 (prompting different random values in J20). I want cell ...
-
Copy selected data from one sheet to another in Excel [Closed]
Respected Sir, I have a data sheet like below : Note No. Date Name Bill No. 10522 12/04/2017 Jones 123/17-18 10523 18/04/2017 Ram 123/17-18 1...
-
Conditioning a cell [Closed]
Hello, I'm trying to program a cell to return a 0 (zero) if a condition is met. I have two text "Referral Fee" and "Incentive Fee" that when thos...
-
Autopopulation of mutiple files from 1 master sheet [Closed]
Hi All, Firstly many thanks to anyone who takes the time to read and try to help. It is greatly appreciated. I have 1 master sheet that I input dat...
-
he cell checks 3 different columns each in different tables [Closed]
how would the formula look if possible, the cell checks 3 different columns each in different tables on different sheets, if the value is=< todays da...
-
Transfer data from main sheet to multiple sheets. [Closed]
I have more then 5000 rows that contains each row have one person details with 15 different column(ex,name.contact no,address.etc), and i have to copy...
-
i dont want add paise in while converting numbers in words [Closed]
Hello, i dont want paise while converting numbers in to words System Configuration: Windows / Chrome 63.0.3239.84
-
Product key of Office 2010 [Solved/Closed]
I don't K now product key of office 2010 please send me this key Regards Pardeep Gur
-
How to convert date into words? [Closed]
Hello i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22/04/2017 - convert it into Twenty Two April Two Th...
-
Code works fine on 2010 but not 2016 [Closed]
Hello, My company is having an issue we just updated our excel from 2010 to 2016, we have user forms that open a form to enter data but after we sub...
-
Can i set a formula for sorting in excel. [Closed]
Hello, Is it possible to set a rule in excel that the entered details will be sorted automatically by a set criteria?
-
Conditional formatting with multiple rules and blank text cells [Solved/Closed]
Hi, I wonder if someone would be able to help me with this. This is probably really simple, but I can't get it to work. I need excel to change a c...
-
Extract a column data in different sheet [Closed]
Hello, I need help on the below eg : I have a file with 2 sheets 1 Tracker , 2 DD2 In tracker I have lots of column but I want the first co...
-
matching a value and returning location of next empty cell [Closed]
Hi all I'm new here and I have been really stuck on this for ages, I'd really appreciate any help. I'm trying to write a macro which will work t...
-
Excel sheet to add conditions [Closed]
Hello, I am trying to do an excel sheet, so that if i put an x in a cell it adds the value from the top row. For a window schedule, where I assig...
-
Setting up Excel formula [Solved/Closed]
Hello, I need some help with the excel formulas I have new taxation laws that apply my organization from January. The current taxes are 10%...
-
Post it digital notes [Solved/Closed]
Everytime I try to download Post it Digital Notes I get the 404 error. What do I need to do?
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Upload High Quality Photos to Instagram
- How to Recover Your Yahoo Account
- How to Recover a Disabled Facebook Account
- How to Create a Gmail Account
- How to Get Free Diamonds in Free Fire
- How to Disabled Write Protection on a USB
- How to Fix a Blurry Snapchat Video
- How to Get More Followers on Instagram
- Facebook Code Not Received
- How to Install a VPN
- Computer Boots to Black Screen