Excel Forum
-
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...
-
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
-
Copy all csv file data in one master sheet through VBA [Closed]
Hello, I am in new in VBA ; Almost around 3000 csv file in folder, I want all CSV file data copy in one master sheet using VBA along with file ...
-
Excel date formula doesn't work past the new year [Closed]
Hello, I have a problem with a date formula in a spreadsheet that I would very much appreciate help with. It seems that the formula doesn't work p...
-
IF formula with dates and rates - complex! [Closed]
Hello, i'm trying to get a very complex IF formula with many dates and outcomes. if an employee's starting date is 18 Oct 2017 (cell A5), then ...
-
IF function for multiple cells and options [Closed]
Hi, I'm trying to use the IF function but even when I copy a formula, I can't seem to get the correct answer. I thought it might be because the cell w...
-
Formula for calculating work hours on overnight 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 ...
-
Consolidate different workbooks into a new one [Closed]
Hi guys, I have 3 excel workbooks (A, B, C) with multiple worksheets. Each one of the workbook have 2 worksheets (1, 2) with the same columns and sam...
-
How to send an email automatically when values are met. [Closed]
Hello, Let me start with that I'm a rookie when it comes to VBA programming. I'm attempting to set up a code that will send an email automatically...
-
How to retreive datas form one sheet to another sheet in excel [Closed]
Hello, If having the datain one sheet per example A column and Values column data are entered ., in next sheet if i enter the A it has to show th...
-
VBA to populate multiple sheets from master [Closed]
Hello, I have a spreadsheet that I use to track my customers bookings. I have multiple customers and multiple bookings. I would like to have my mas...
-
IF Function Using a Date Range [Closed]
I'm looking for a function that will assign a specific date or day of the month when another cell containing a date falls within a date range: If C...
-
Help with formula: IF, variable, add time into a different cell [Closed]
Hello, I found this website after bumping my head with the keyboard trying to find a solution to a question I have. I am trying to create a spreadshe...
-
Formula IF contains certain text, then will add time to another [Closed]
Hello, A1 is original time, B1 will be a type of equipment, C1 will be 40, 45 or 55 minutes, depending on types on B1, D1 will add C1 and A1 and thr...
-
How to convert numbers into words in Excel? [Closed]
Hi, How to link or create formula in converting figures to amount in words? Thanks
-
Data Comparison in excel [Closed]
Hello, I have two data like in one sheet Names are started with First name and in other Sheet data is started with the Last name.So how can i compar...
