Excel Forum
-
Help comparing two columns in excel, returning third w/dups [Closed]
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 ...
-
Automatically Transfer rows from 1 sheet to another using a Comm [Closed]
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 [Closed]
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...
-
Transposing [Closed]
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...
-
creating a formula If a cell is equal to or less than 7.00 [Closed]
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...
-
Points system formulas [Closed]
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...
-
Code Required in vba [Closed]
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...
-
Inserting a Prefix based on cell color [Closed]
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...
-
conversion of DOB to full words [Solved/Closed]
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...
-
find specific values in a cell based on the text behind [Closed]
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...
-
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...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get More Followers on Instagram
- How to Upload High Quality Photos to Instagram
- How to Recover Your Yahoo Account
- How to Create a Gmail Account
- How to Disabled Write Protection on a USB
- Computer Boots to Black Screen
- How to Install a VPN
- How to Recover a Disabled Facebook Account
- Facebook Code Not Received
- How to Get Free Diamonds in Free Fire
- How to Fix a Blurry Snapchat Video