The discussions
Excel combine worksheets into one
Newbie here, I have a question on how to do this in excel. I have lots of worksheets, 200+, each with different names, and I was wondering if its p...
Removing false value
SolvedHello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(G23=0,P15/Sum(D11:F11,IF(G23>0...
Copy rows to other sheets based on value in column
SolvedAll, I have an Excel file with three sheets: Sheet1 contains all my data. Sheet2 named "MACH" and Sheet3 named "FAB" I am looking for a way with a...
Automatically save data to another excel sheet.
Hello, System Configuration: Windows / Chrome 57.0.2987.110 Please give me suggesstion & Advice to my query, Whenever I enter date in Ex...
How to calculate values using countif
I have 2 sheets sheet1 is a Summary sheet and sheet2 is data sheet sheet 2 has columns from A TO R, in that column G is Severity (heading) wit...
Trying to create a multi-column formula.
SolvedHello, I need help making a formula. I will do my best to describe. The letters (A-I) refer to separate columns. A-B=C to be divided by D the res...
Two excel sheets copy new data input on one sheet to new row on
Hello, I have an excel spreadsheet that I have to update periodically overwriting old data. I have another sheet where I need to update the same inf...
Need to extract data from a column to another worksheet.
Hello, I need code to extract all data containing a name from a column on sheet1 and copy it to Sheet2 and remove all blanks. The name is pulled fo...
Excel problem
SolvedHello, I want a formula in which, If I enter the number in cell, the name of that number should appear in adjacent cell. Ex: Emp No Name 1 ...
Help with index match or vlookup
Hello, I have a worksheet with about 2000 rows. In column C and Column J i have a common Key. In Column K I have data that i want to write to Colu...
Highlight one value in a dropdown menu of three responses
SolvedHello, I have a template where we are asking for responses with a drop down that includes Y, N, and N/A. We want to highlight all N answers in yell...
Create new excel files based on the data in a column
Hello, I've spent hours searching and trying different macros with no avail. I'm not new to excel, but new to macros and coding. I have a spreadshee...
Code to move rows into another sheet based on certain values
SolvedI'm having trouble figuring out how to do something! I have a sheet (Sheet1) with customer details on it (columns A-D will have data in). I want to be...
Count only cells containing 2 given words
Dear friends, I simply get mad trying and trying again to find the right function that may help me to count out of an array only the cells that conta...
Cell to populate if other column has any text
Hello, I'm struggling to find a formula to populate one column's cell based on another column's cell having at least one character of text. e.g. A1...
Change cell text based on another cell's color
Hello, I need to prompt a cell to write text based on another's cell color in excel but not using VB. Can you help? System Configuration: Windows /...
Insert picture in excel macro which takes the file name refrence
Hello Friends, Kindly help me! I am trying to insert a picture in excel macro which takes the file name reference from the D5 cell and insert th...
Formula for text in a cell and then total the amount on text
Hello im trying to total the shfit allowance on timesheets eg: In cell k7 they will leave blank if not claim shift allowance, but if they are then ce...
Change value of subsequent cells once a condition is met
The simplified story: I have a user input "Start Month" that is between 1-12. I have Columns A:M labeled accordingly 1-12. The question: If the us...
Vba to automatically insert subtotals in multiple worksheets
Good Day, I hope somebody can help me, I have an workbook with a main sheet ""2017 Sales" and 10 worksheets with the name of each individual sales Age...
Open workbook using following code
Private Sub CommandButton1_Click() Workbooks("Patch.xlsm").Activate Sheets("Site Name").Select S = Range("A1:A2") D = Range("B1:B2") E = Range("B...
Database copy only certain information
Hello, I currently have a table with data containing peoples information for a sports program, I would like it if I put "Yes" in the coloumn for the...
Search a list of names at one time in excel
SolvedHi, I have a huge list of names (list A) which I need to search with another list of names (list B) and see if any name in list A is in list B . Is i...
Autofil random cell in another worksheet
Hello, Please help me write the code for below situation: 1. I have 2 sheet "Merger_Pole" and "Config". 2. In Merger_Pole, I set F2=Config!C29 (ra...
If a cell contains any text then add a value (with dates)
SolvedI am looking for help with a formula that will allow me to add up the number of times a certain date is a Monday. I am using =COUNTIF(A1:A30,"*Monday...
Macro to increase a cell reference by 11
SolvedHi everyone I want a macro that on open will increase the cell reference in a cell by 11 each time the book is opened i.e. Cell C18 has =Sheet2!H2. T...
Totaling ot hours on separate sheet
Good Morning! https://drive.google.com/file/d/0Byqv0sZOGZaHRUNuUlNUc1RKbWM/view?usp=sharing I have a spreadsheet that managers fill out with overtim...
Automatically transfer rows from 1 sheet to another using a comm
Hello, I am very new to excel codes etc... I have a spread sheet that I would like to automatically transfer rows from 1 sheet "Current" to anothe...
Mac os, big file split data into seperate worksheets
Hello, To begin I require a rather large Excel (.csv) file to updated every 2 days. This file consists of roughly 23000 records and spreads from the...
Creating a formula if a cell is equal to or less than 7.00
Hello! I am looking for a formula that will do the following: If a cell is equal to or less than 7.00, the entire row which contains said cel...
Conversion of dob to full words
SolvedHello, Configuration: iPhone / Safari 4.0 I want to to convert dob to word like 5/6/2014 to fifth June two thousand fourteen please tell me...
Data auto change on multiple status in one column
SolvedHello again, Few days ago i am looking for a command that can use to change data status in one same column. Example : 'Activated' change to 'Expired...
Master sheet auto-populating anniversary dates into new sheets?
Hello, I have a master sheet that has our employee information and start dates where I have broken up their start dates into different columns for t...
I want to create spred sheet
How do I open excel? -- Karen Deeter
Repeat row x times
Hello, I want to make some labels for products. i have a sheet with info in columns A-F(name, sku, size, description, date, and quantity. Column F...
How to sum responses from cells with list data validation
Hello, I want know if it is possible to total (SUM) the number of responses I have on cells which have the data validation. I have set up a sprea...
Question on vba code
SolvedHello, can someone explain this code to me? I have this file that has a macro button transferring all the information(KPI's to be exact) from a data...
Excel - repeat last row into n number of times
Hello, Can anyone help me to repeat last row into N number of times into same sheet. Sample Data Where N=5 Column-A Column-B abc 111 AAA...
Please help excel 2016
Hello, I have an excel workbook for our call center metrics and i need to accomplish the following On the sheet named calculations and a sheet nam...
Unable to display pic in mac platform
Hello, Please help me to solve this for my project ...need help as soon as possible Already Macro enable,picture display issue message is "The Link...
Formula help - if cell contains a number, +1.
SolvedHi there, Just a simple one for you guys! I'm currently making a spreadsheet to tally up sickness days and occurrences. I currently enter how many s...
Covert date of birth
SolvedDear Sir I want to convert date of birth in excel like below mentioned Example : 11/07/1982 then it should be reflect as Eleventh July Nineteenth...
Need help with macro to generate monthly overview
SolvedHi all! I have been trying to build a Macro that allows me to generate a new worksheet with the information from a Master Sheet where i will key in t...
Conditional formatting
SolvedI am trying to format column 'O' if the value is greater than zero but where column 'P' does not include "SBNAS735" or "SBTDP443". Help! System Conf...
Update cells in a particular column from one sheet to another
How do I update cells in a particular column from sheet to sheet. I have a payroll worksheet and occasionally our employees borrow money, I need to co...
Countif statement driven by spesific date and text criteria
Hello, Employee Work Code Report I need to summarize every occurrence in column C within each of the same dates in column D (1/1-1/31) and based ...
Formula to completed fields
Hello, I need a formula to look up values that if it shows all false it's a green light and if it contains at least 1 true value, it's red light. I...
Timesheet adding rows
Hello, I'm trying to work out a formula so that I can hand off my timesheet to a new manager and have it work correctly. Right not I sum a row of to...
Unable to display pic
ClosedAlready Macro enable,picture display issue message is "The Linked image cannot be displayed. The file may have been moved, renamed or deleted. Verif...