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...
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...
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...
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...
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...
Dear Concern, Please resolve the query I requested below... I have a work book like.... Sheet 1: It has student detials (Enrollment No, Name, ...
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...
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...
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
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...
Compare the duration field for each same environment and display the difference Note : Duration will be reported once the status is complet...
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 ...
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. ...
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...
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))) * * ...
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 ...
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...
Hello, I have recorded the below Macro. All i want is to Loop till the end. Sub MainTranspose() ' ' MainTranspose Macro ' ' Keyboard Short...
I wish to learn how to use excel
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...
My question is slightly different: RANDOM calculation is created in cell J20 by pressing F9 (prompting different random values in J20). I want cell ...
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...
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...
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...
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...
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...
Hello, i dont want paise while converting numbers in to words System Configuration: Windows / Chrome 63.0.3239.84
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...
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...
Hello, Is it possible to set a rule in excel that the entered details will be sorted automatically by a set criteria?
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...
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...
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...
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...
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%...
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 ...
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 ...
Hi How do I get the cells I am typing in today to turn blue? With historic date remaining black?
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...
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'...
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...
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
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...
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...
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 ...
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...
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 ...
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...
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...
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...
DON'T MISS