Hello, I have have found on here some help in comparing two columns and if there is a match, copying a third column, but I need a way to receive an ...
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...
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...
Hello, I have a sales report provided to me monthly that has the following details: product code, product name, year and month. The format looks lik...
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...
Hello, I am looking for some helping with creating some formulas. What i am trying to do is something like a points system for 1st, 2nd and 3rd, etc...
I have an task related issue.. we have total 3 Timesheets which contains planning,execution etc in each row ..suppose i have 20 employee timesheet and...
Hello, I have an answer key in excel, which indicates correct answers with a green cell background. I need to insert a "*" prefix for each correct...
Hello, 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...
Hello, Let me give you the example first. The cell has the following text: 7 Pages TRA, 23 Pages PRF, 97 Words TRA, I would like to find the value...
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...
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...
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...
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...
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...
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 ...
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 ...
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...
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...
How do I open excel?
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...
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...
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...
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 ...
and paste it into that workbook. Any help you could give me for this would be so greatly appreciated. Thanks. System Configuration: Windows / Inte...
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....
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 ...
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...
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...
Already Macro enable,picture display issue message is "The Linked image cannot be displayed. The file may have been moved, renamed or deleted. Verif...
How to copy info from 1 excel spreadsheet to another excel spreadsheet. For example, need to copy identification numbers from master list to monthly ...
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...
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. ...
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...
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...
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...
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...
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 ...
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...
DON'T MISS