Excel Forum
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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, %....
-
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...
-
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...
-
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...
-
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....
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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)...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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 ,...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
Worksheet_SelectionChange event not working [Solved/Closed]
Hello, I wanted to execute a Worksheet_SelectionChange event code. But its not working. I searched on net to find that if I change (General)...
-
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...
-
give a response by comparing 2 times (in different columns) [Closed]
I have a sheet which has a dispatch and arrival time in 2 separate columns. Our response time should be no more than 1 hour during office hours...
-
import jpeg into cel [Closed]
Making database for artist archive. Best way to import image files? Sizing is part of issue - how to import a small jpeg and have it conform to cel?
-
Working out the difference in times between two columns [Solved/Closed]
I have various times in Column B (Departure time), and another set of times in Column C (arrival time). If the time in B is between 07.00 and...
-
How to load data from various sheets into one master sheet? [Closed]
Hi Guys, Hope for an expert in excel who can help!!! I have a spread sheet that contains: 1st sheet is master file with the number plate...
-
Excel macro to insert two rows. [Closed]
Hello, System Configuration: Windows / Chrome 61.0.3163.100 I have similar problem as this. Just that, I wanted to insert row in...
-
Convert in to rs in word [Closed]
3456755332578097 convert in to rs in word
-
How to use the Spellnumber function in Excel? [Closed]
Hi. Please giud me how to use formula in excel for spell number for Indian currency .
-
Inserting day of week along with date [Closed]
Hello, I found an previous post with same question that is closed and it was helpful except for the format. I am looking for an outcome...
-
Multiple cell copy to a single cell [Closed]
Hello, I am trying to copy the contents of multiple cells in workbook A to a single cell in workbook B. This worked fine in the 2010 version...
-
How to copy columns to a specific column header and repeat? [Solved/Closed]
Hello all, am new to using macros in excel. i have data and i want to be able to columns and paste it under some specific columns...
-
Auto populate data from invoice. [Closed]
Dear CCM.NET, Hope you are doing well. I am working for a yarn whole-seller company. I to keep record of various kinds of Yarn purchase, Yarn...
-
Changing format of date in Excel [Solved/Closed]
Hello, I have an excel sheet which has lots of cells in a column with the date format as - day month date time year & I wish to convert that to...
