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...
PO Number Qty In PO Total Quantity In PO I Need Numbering Like This 1111 1 1 1/1/1 2222 ...
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 ...
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 ...
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...
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...
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...
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 ...
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...
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...
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...
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...
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...
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...
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 ...
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...
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 ...
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 ...
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...
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...
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...
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...
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...
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...
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 ...
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 ...
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...
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 ...
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 ...
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...
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...
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...
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...
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...
Good Morning, I would appreciate some advice/assistance with formulas and VBA code. http://ge.tt/3wxXEJn2 I am trying to create an equipment ...