Excel Forum
-
Matchpoint score [Solved/Closed]
hello I hope that someone can help me. I have an excel sheet in which I record scores of teams and I would like a formula to calculate the points acc...
-
Copy data into new rows (row 2, 3, 4, et cetera) [Closed]
To Whom It May Concern: I'm trying to get data that's already made into a different part of the same sheet. I want to make sure it's recorded in o...
-
How to change text formating in a cell? [Closed]
Hallo!! I am working on a dictionary and I want to change the formating of the text of column B by setting prerequisites. Example: "Απαλλοτρίωσ...
-
Formula to return cell value in Excel [Closed]
Hello, System Configuration: Windows / Chrome 51.0.2704.106 I am trying to configure a formula that returns the value of a cell if is not b...
-
Populate Data [Closed]
I need to auto-populate data from a master worksheet into multiple worksheets, while having the ability to add/delete rows in the master worksheet. Th...
-
How to match contents in 2 separate cells? [Closed]
I have data in 2 separate cells. I need a formula that will pick out the first 3 characters from each cell and show if a match (true/false). Any hel...
-
Copying data from an Excel 2010 table to a String or Word File [Closed]
Can anyone help me please with the following problem: Search in Col A of an Excel Worksheet table for expression 'Employee' (exact cell location in Co...
-
Sorting 2 columns of names with the same 2 columns& limited rows [Closed]
I have an Excel sheet with room for only 2 columns and 5 rows. I need to sort 8 names alphabetically in those 2 columns and 5 rows. For instance...
-
Automatic increment number for invoice [Closed]
Hello, i do make invoice sheetwise due to the same sheet we add expenses to calculate profit, now how do i get new number whenever i copy the sh...
-
Compare values in two columns and return the value from third [Closed]
Hello, I have a table containing three columns. Column A shows the status of a product, "To Review", "Under Review", "Review Completed" Column...
-
Transfer data from the master sheet to other sheets. [Closed]
Hello, i am maintaining a master excel sheet of out tele callers in which they all enter their calling data. i want to get the data in different d...
-
Removing Extra columns after the end of the month, [Closed]
Hello, Be Happy, i want to ask you that my company's month starts from 23rd and ends on 22nd, so how the extra columns can be removed automatically...
-
Auto E-mail when cell displays "Yes" [Closed]
Good Day Could someone please assist me with my query? I do not have many experience with VBA Macro, and would appreciate a simple answer. I ha...
-
How to use conditional format based on text? [Solved/Closed]
Hello, I want a cell to change color if another cell contains the words "first aid". The text comes down from a drop down list and could read "Fi...
-
Cut from one workbook to another workbook [Closed]
Hello, from data specific cell value match then entire row cut and paste another workbook sheet in excel vba formual System Configuration: ...
-
Copy and convert data [Solved/Closed]
Hi, in advance I would like to thank everyone for reading my post and providing any assistance. I have an exported worksheet with 50 rows of data (30...
-
Input part numbers and description into selected spreadsheet [Closed]
Hello, I am compiling a excel work sheet, so far I have created 'buttons' that take me to the correct spreadsheet sections I have created. What I need...
-
Creating a time frame [Closed]
Dear excel gurus/geniuses, I'm new to excel (as in, new in discovering what a powerful software it is!!) I want to calculate approximate time (day?...
-
Wanted formula [Closed]
Hello, Want to know the formula Eg:- if a sale of one month is 585 than how to remove 30% of that amount... Wat formula to use in excel sheet
-
How to loop sheets through in a worksheet [Closed]
For each tempsheet & i Loop them and perform a same code
-
Create a spreadsheet that captures data in sheet 1 [Closed]
Hi All, Hoping someone can help with a query. I want to create a spreadsheet that captures data in sheet 1 (name, company, notes etc) and populates...
-
VBA Excel [All versions] - Calendar Control [Closed]
RE: https://ccm.net/faq/36865-vba-excel-all-versions-calendar-control The article "VBA Excel [All versions] - Calendar Control" looks very promisi...
-
VLOOKUP, IF? Question assigning value to text options [Solved/Closed]
Hello, I need to make an spreadsheet that corresponds different text values and gives them a score. I have several tables set up, that I was tryin...
-
Data showing who pays a doesnt after manually input receipts [Solved/Closed]
Hello, Hope im clear on this. Im a bit lost. I have sheet one. This is a spredsheet where we input a secuential number with the name of the ...
-
Sorting a massive amount of data [Closed]
Hello, My boss has asked me to find out how much each sales person has sold in their first 8 weeks, 16 weeks, 24 weeks,40 weeks, 1 year, 2 years a...
-
Finding a cell and adding 1 to a cell in an adjacent column [Closed]
I am working on a simple stat program to replace a tally sheet we use in basketball practice. I have created a page to choose names and statistics to...
-
Difficulty to open Excel files [Closed]
Good day! The problem is the following! When opening any Excel files (no matter what size and no matter of the mesh open or locally with a computer) t...
-
Compare sheets and put missing rows into third sheet. [Closed]
Hi to all the CCM members. I have a problem that I need assistance with and I would greatly appreciate it if a VB guru could help me with a script ...
-
Copying rows into new sheet [Closed]
Hello beautiful people of CCM, This is my first time posting and I am so excited to be part of such a wonderful community of intelligent minds. I t...
-
Compare Excel worksheets [Closed]
Hello, I need to compare one Excel Sheet1 with Sheet2 by comparing the data and putting all missing rows data not in Sheet2 into Sheet3. Sheet1 co...
-
Linking by contents not by cell number in Excel [Closed]
Hello, I currently have two workbooks open on excel. One is a shipping list of spare parts that I have sent out and the other is the one I use to ke...
-
Excel data transfer [Closed]
Hello, I have a spreadsheet that we have weekly billing sheets on. We have a sheet on it to track our PO numbers as well. There are also a variety...
-
Update one sheet excel sheet from the other [Closed]
Hello, I was wondering if anyone could help , I have a large excel sheet (AW - 2506) which holds info for each employee, we are currently moving s...
-
Allow Inserting Hyperlink after Protecting a Sheet with VBA [Closed]
Hi I have a spreadsheet which a user must complete, but he must select how many times the form must get created. My coding allows that, but I'm prot...
-
Copying rows into a new sheet [Closed]
Hello I am trying to do the following If the quantity listed in column C on sheet "Area 1" has a value of 1 or greater then pull rows A through...
-
Create new worksheets using date data [Closed]
Hello, I've been asked to find a way to sort data comprised of visit dates in to worksheets (within the same workbook) by age. The dates range fro...
-
Automated filter, copy, paste... Recommendations appreciated! [Closed]
Hello, I am a self-taught rookie attempting to create a document that will distill necessary information on a contract and spec sheet without havi...
-
Compare 2 cells then use data in 3rd cell [Closed]
hi there hope you can help me with this please i need to do the following for a stock vs sales management sheet if a1 = b1 then d1*c1 Lo...
-
Update from one sheet the other [Closed]
Hello, I have a large excel sheet (AW - 2506) which holds info for each employee, we are currently moving systems and I am storing and updating al...
-
Logging web data excel [Closed]
I’m trying to log some data imported from the web. I’ve already managed to import the data as a table and set an auto refresh to every minute. What I...
-
IF statement returning false [Closed]
Hello, The following IF statement is returning false. Please let me know how to get it to return a value. Thank you =IF(D6
-
Macro to copy data to new workbooks based on condition [Closed]
Hello, I have a workbook with data that looks something like this (except thousands of entries): Name Type Group Master John ...
-
Filter the data in Excel through formula [Solved/Closed]
Hello, I need a formula of the following quotation: Column A Belongs To Customer Name Column B Belongs The Date Column C Belongs To Item ...
-
transfer certain information from one sheet to another [Closed]
I have multiple employees. I have my payroll broke down into months. I need to have a sheet for each employee. Can i use a formula so I only have t...
-
Unable to format any date prior to 1900 as dd/mm/yyyy [Closed]
This is my second request for help. I am unable to format any date prior to 1900 as ddmmmyyyy. No matter how many times I try to custom format it, t...
-
Highlight Cell Question [Closed]
Hello, I am trying to find a way to use conditional formatting on an inventory spreadsheet that I am working on. I would like to highlight cell C3 ...
-
Help with Formula calculating time on 24H shifts [Closed]
Hello CCM community!, Here I am again with a question that's being bugging me for a while A while ago I created my own version of a work scheduler...
-
Insert rows on change of value in Excel table [Solved/Closed]
Hello, I have an excell spreadsheet that contains a table. I want a macro of vb to insert a row into the table when the values in a particular colum...
-
Number pad not working in Excel [Solved/Closed]
Hello, I have an extended keyboard on a MacBook pro and the number pad won't work. letters all work. num pad works fine everywhere else - word,...
-
date and time format change [Closed]
Hello, hi I want to change 15:07:2017 19:51:54 date format in 15/July/2017 19:51:54 System Configuration: Windows / Chrome 62.0.3202.94
Subscribe To Our Newsletter!
