Excel Forum
-
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...
-
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...
-
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...
-
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...
-
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....
-
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....
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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....
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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 -...
-
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...
-
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...
-
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),...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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...
-
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,...
-
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...
-
How can I stop/remain from changing the value in the Lapse days [Closed]
Hello, I have a problem in excel, how can I stop/remain from changing the value in the Lapse days Column as the days changing, if i will type...
