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...
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...
Hallo!! I am working on a dictionary and I want to change the formating of the text of column B by setting prerequisites. Example: "Απαλλοτρίωσ...
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...
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...
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...
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...
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...
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...
Hello, I have a table containing three columns. Column A shows the status of a product, "To Review", "Under Review", "Review Completed" Column...
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...
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...
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...
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...
Hello, from data specific cell value match then entire row cut and paste another workbook sheet in excel vba formual System Configuration: ...
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...
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...
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?...
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
For each tempsheet & i Loop them and perform a same code
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...
RE: https://ccm.net/faq/36865-vba-excel-all-versions-calendar-control The article "VBA Excel [All versions] - Calendar Control" looks very promisi...
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...
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 ...
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...
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...
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...
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 ...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
Hello, The following IF statement is returning false. Please let me know how to get it to return a value. Thank you =IF(D6
Hello, I have a workbook with data that looks something like this (except thousands of entries): Name Type Group Master John ...
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 ...
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...
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...
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 ...
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...
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...
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,...
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