Excel Forum
-
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 ...
-
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...
-
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...
-
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...
-
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 ...
-
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 ...
-
Move Rows of Data into New Worksheets [Closed]
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 daily. Move...
-
Consolidating Data [Closed]
Hello, I have an excel worksheet that I am attempting to publish easily by automating the recovery of certain data. My goal is to add the text of ...
-
auto populate from master to individual sheets [Closed]
Hello, I have an excel sheet that I would like to auto populate from a master sheet to individual sheets. Basically it is an assignment list that I ...
-
Make a macro run when data entered in a cell [Solved/Closed]
Hello, I have a macro that runs when the user clicks on a button. Instead, I want the macro to run when Cell D10 is populated. The data for D10 c...
-
Need help with #value! [Closed]
Hello, Hello, I need a formula that will change answer based on selection from drop down box (the formula that I used keeps giving me a #valu...
-
Conditional sum function in Excel [Closed]
hi, i have 2 sheets in matrix format ,One having travel time between different zones and other having values of number of trips between different zo...
-
Need help with #value! [Closed]
Hello, I need a formula that will change answer based on selection from drop down box B33 can be any number from 0-10, it has a drop down box w...
-
How to format text with a Macro? [Closed]
I have a simple event based "macro" that populates my header with information. The question I had was: How can I have the header populate thi...
-
Excel Formula/VBA Assistance [Closed]
Good Morning, I would appreciate some advice/assistance with formulas and VBA code. http://ge.tt/3wxXEJn2 I am trying to create an equipment ...
Subscribe To Our Newsletter!
