Excel Forum
-
Formula/ Conditional Formatting Help please [Closed]
Hello, I am trying to create a tracker spread sheet. I need to enter the date a course was completed, the date it is due (2 years later) and I need...
-
Excel VBA Template [Closed]
Hi, I'm new to excel,i want a template which will take the data from one workbook & paste it to other workbook,but it has to be done daily lik...
-
Copy and paste data from different sheet. [Closed]
Hello, I have a small problem. I have made dependent lists in excel to capture the data. However, to sum up the data, I need to pick up the entire...
-
Use a macro to copy data from rows into destination range [Closed]
Hello, I want to create a macro to copy data from one range (eg. A2 to C2) and paste it to another destination in the same file. then select next...
-
Excel formula to subtract a value based on a date condition [Closed]
I need a formula for my budget in excel. I have the date automatically updating and I would like to use the due date for an automatic payment to ch...
-
Copy two sheets data in new work book with two sheets. [Closed]
Dear Concern, Please resolve the query I requested below... I have a work book like.... Sheet 1: It has student detials (Enrollment No, Name, ...
-
Macro coding [Closed]
Dear concern Macro for copying a particular sheet from a workbook and pasting only values in new work book and saving that new workbook with speci...
-
How can I stop/remain from changing the value in the Lapse days [Closed]
Hello, I have a problem in excel, how can I stop/remain from changing the value in the Lapse days Column as the days changing, if i will type value...
-
How to use a macro to copy data from one sheet to another? [Closed]
macro for copying a particular sheet from a workbook and pasting only values in new work book and saving that new workbook with specific cell value
-
Excel Macro - Create Multiple Workbooks [Closed]
Hello! I have a 4 tab workbook I need to create multiple copies of (one for each employee to use throughout the entire coming year). I have my Dat...
-
Macro [Closed]
Compare the duration field for each same environment and display the difference Note : Duration will be reported once the status is complet...
-
Formatting cell based on text in another sheet [Closed]
Hello, For e.g, I have "numeric" in cell B11 on sheet 1 with formula. However, I want the font color to change based on the text value in cell B2 ...
-
Macro for Copying group of cells and paste as row [Closed]
Hi, I need some help i need a Macro Code to arrange certain cells and prepare it as a row. I export the file from SharePoint in Excel Format. ...
-
Copy and convert worksheet data [Closed]
I have an exported worksheet of data from an InfoPath Form. The results are Yes, No, NA, Blanks and dates; I want to copy all the data to a new works...
-
IF function in Excel error [Solved/Closed]
Hello, anyone can tell me where the error Is. =IF(G:G>="0:05", 0:30Min, IF(G:G>="0:20",1:30hrs, IF(G:G="0:00",0:00hrs , 4:00hrs))) * * ...
-
Formula in excel [Closed]
how to fetch values by formula in cell from given rage only once thereafter formula should be in active or can formula be made inactive by changing ...
-
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
-
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%...
-
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 ...
-
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 ...
-
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...
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get Free Diamonds in Free Fire
- How to Fix a Blurry Snapchat Video
- How to Create a Gmail Account
- How to Recover Your Yahoo Account
- Facebook Code Not Received
- How to Disabled Write Protection on a USB
- How to Recover a Disabled Facebook Account
- How to Upload High Quality Photos to Instagram
- How to Install a VPN
- Computer Boots to Black Screen
- How to Get More Followers on Instagram