Excel Forum
-
Data auto change on multiple status in one column Solved/Closed
Hello 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? Closed
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...
-
identify the frequency of times Closed
Looking for a way to identify the frequency of times a name in column A exceeds the value of its outcome in column c when compared to its expected out...
-
separate version type and names Closed
Hello, I have data on browsers used by users where in I need to separate version type and names. I am struck up in the middle. Formula used by me is...
-
Multi Sheet formula Closed
I am trying to figure out how to automatically find and remove duplicates across several sheets. The purpose of this is to have a master list of my in...
-
Date adjustments by 6 months Closed
Hello, I am in search of some expertise advice. Im trying to figure out if there is a formula to add 6 months from a date to another cell. What I ...
-
adding 6 months to dates Closed
Hello, Im trying to figure out if there is a formula to add 6 months from a date to another cell. What I have is training that occurs twice a year ...
-
VBA button to move a range of data Closed
Hi. So, here's what I would like to do: Excel Workbook (Cert_Master) local 1. I enter various information about a job into Worksheet (DATA); it po...
-
Change bunch if cell colours when cell pressed Closed
Hello, I would like to be able to click on a yes cell, no cell and a selected amount of cells in a column change to either green/red. Effectively ac...
-
i want to create spred sheet Closed
How do I open excel?
-
Preventing a cell from being populated if different cell is popu Closed
Hi there, I have created a spreadsheet for units for a Diploma that assessors can use to select various units from a number of possible options. I h...
-
copying dates in Excel Closed
Hello, when I copy a date from one cell to another(not to the cell directly below), it appears as a number(eg 48123) rather than the date I copied(e...
-
Repeat row x times Closed
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 get entire row based on unique value of multiple column Closed
I have to get entire row with unique values based on multiple columns as shown below, in that only one row(3 with same value as 2) is repeated and in ...
-
Just general VBA to copy a sheet from one workbook to another... Closed
and paste it into that workbook. Any help you could give me for this would be so greatly appreciated. Thanks. System Configuration: Windows / Inte...
-
IF series formula Closed
I have an excel sheet with Column A thru I and rows 1 thru 23. I am trying to have my cell H2 return a word if cell D2 has a number 15 thru 21 in it....
-
How to SUM responses from cells with list data validation Closed
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 Solved/Closed
Hello, 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 Closed
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 Closed
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 Closed
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. Solved/Closed
Hi 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 Solved/Closed
Dear 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 Solved/Closed
Hi 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...
-
Help on excel Closed
Hello, I have a table of date time and value for a month, would like to find the value searching the date and time ex Date tim...
-
Conditional Formatting Solved/Closed
I 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 Closed
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 Closed
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 Closed
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 Closed
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 Closed
Already Macro enable,picture display issue message is "The Linked image cannot be displayed. The file may have been moved, renamed or deleted. Verif...
-
Copy data from 1 excel list to another excel list Closed
How to copy info from 1 excel spreadsheet to another excel spreadsheet. For example, need to copy identification numbers from master list to monthly ...
-
Conditional formatting in googlesheets Closed
Hello, I'm using Google Sheets, not sure how big of a difference will be. I'm trying to use conditional formatting between two columns, and I'm not...
-
Need some programming in excel Closed
Hello Sir, I am A basic user & new to excel & coding. I will explain what I am looking for , than you can let me know weather it's possible or not. ...
-
copy and paste from workbook to another workbook Closed
Hi, I have a master workbook that has various tables on several worksheets. The information carries forward to the master page. I copy lines from thi...
-
Need urgent help with spltng the data copied in another workbook Closed
Sub Copy_Script() 'Finds the last non-blank cell in a single row or column Dim myFile As String, cellValue As Variant, i As Integer, j As Integer, a...
-
Transfer data from one sheet to another Solved/Closed
Hello, I require some assistance please. I looked at a few answers on this forum, but I am stuck as my VB keeps on giving errors. I wish to automa...
-
Look up a word within a sentence and copy into a next column Closed
Hello, I have an excel file with over 10 000 entries, each entry contains a city within the sentence - I also have a database (another sheet) with a...
-
How to transfer data to another work book in excel Closed
Hello, I would like to automatically transfer the data to another work book but I do not want to transfer the rows that have blank data. could you ...
-
Date formats Solved/Closed
Hello, Can you tell me how to change the format from Sep-01-2015 to the format 2015-09-01? I have tried the format tab under the Date section and Cu...
-
Adding number of days in filtered excel sheet Solved/Closed
how to add number of days to columns in a filtered excel sheet
-
complicated auto populate possible or not and if so how. Solved/Closed
Hello, I'm using excel to schedule for my business, I have all the customer information on the first sheet and would like to auto populate the other s...
-
Compare columns in two sheets and copy info across Closed
Hello, I have two sheets open. Sheet 1 has two columns of data (PO number, Value) Sheet 2 has two columns of data (PO number and supplier) What ...
-
excel formual help Closed
Hello, I need a formula, hope someone can help! If i add a date in to cell A2, i want the number 1 to appear in cell A1
-
Making Labels Closed
Hello, I want to make some labels for products. i have a sheet with info in columns A-F. Column F contains quantities. I need to make a sheet that ...
-
Transfering information from one worksheet to another Closed
Hello, I am trying to transfer information from one worksheet to another, but only if the name shows up on the second worksheet. For example, I h...
-
Formula for assigning numerical value to text Closed
Hello, I have a very large excel sheet with names. Some of the rows of names duplicate, sometimes more than once. In each row next to the name is a...
-
code to check if a work centre on sheet 1 appears on sheet 2 Closed
Hi, Please help me write a code that will check if a work centre on sheet 1 appears on sheet 2. If it appears in sheet 2 the work centres in sheet 1 ...
-
My arrow key move only four cells Closed
Hello, My arrow key move only nearest few cells even in new worksheet My computer HP probook Please help System Configuration: Windows / Chrome...
-
iso 27005 Risk Value Solved/Closed
Hi All, I have the following problem: I have two cells that have a text value which can either X or M or H X value is 0, M value is 1 and H value i...
