Excel Forum
-
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...
-
VBA template Closed
Hello, Hi, I'm new to excel,i want a template which will take the data from one workbook & paste it to other workbook,but it has to be done da...
-
Macro which will determine a new scanned file Closed
Hello, I am trying to organize my records and here is what it comes down to, I have 4 separate folders, in which I am planning to copy scanned fil...
-
Formula/ Conditional Formatting Help please Closed
Hello, I am trying to create a tracker spread sheet. I need to enter the date a course was completed, the date it is due (2 years later) and I need...
-
Excel VBA Template Closed
Hi, I'm new to excel,i want a template which will take the data from one workbook & paste it to other workbook,but it has to be done daily lik...
-
Copy and paste data from different sheet. Closed
Hello, I have a small problem. I have made dependent lists in excel to capture the data. However, to sum up the data, I need to pick up the entire...
-
Use a macro to copy data from rows into destination range Closed
Hello, I want to create a macro to copy data from one range (eg. A2 to C2) and paste it to another destination in the same file. then select next...
-
Excel formula to subtract a value based on a date condition Closed
I need a formula for my budget in excel. I have the date automatically updating and I would like to use the due date for an automatic payment to ch...
-
Copy two sheets data in new work book with two sheets. Closed
Dear Concern, Please resolve the query I requested below... I have a work book like.... Sheet 1: It has student detials (Enrollment No, Name, ...
-
Macro coding Closed
Dear concern Macro for copying a particular sheet from a workbook and pasting only values in new work book and saving that new workbook with speci...