Excel Forum
-
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...
-
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 ...
