Excel Forum
-
Excel for Mac date formatting [Closed]
Hello, I have two columns one for the month/day and one for the year. When I formatted the month/day column it automatically adds the year in whi...
-
Format excel data [Closed]
Hello, i need to modify the data in my excel. Right now the data looks something like this: case A start 51 stop 55 ...
-
Copy rows from one tab to another - if specific criteria in col [Closed]
Hello, In a file, I am trying to copy data from one row of a worksheet if specific criteria are met in one column to another worksheet. Ex: ...
-
EDATE [Closed]
I have a training for log for a large number of staff for various different courses which have all been completed at various different dates and I wan...
-
Running a macro in different cells [Solved/Closed]
Hello, I have a question. I recorded a macro to average a series of columns, highlight the averages row in a bold color. I would now like to run the ...
-
auto populate data from one sheet to a second [Closed]
I am trying to have the information entered in the first 2 columns on sheet 1 transfer to sheet 2 in the same location automatically. There are appro...
-
Formula [Solved/Closed]
I need some help with a formula, everything I try just doesn't work. I usually don't have this problem with Excel today is my day. I have a colum...
-
Transferring Data from Multiple sheets to one [Closed]
Hello, Disclaimer: I am new to macros and VBA, so reading the code is difficult, but I am making it a priority to learn. My problem. I track co...
-
Use Excel Template as a Sign In Form [Closed]
Hello, I wanted to use an excel file as a sign in sheet. I need user to read the agreement that is presented on screen in an excel file. After read...
-
HELP FOR TIME REMINDER IN EXCEL [Closed]
Hello, I entered some date in excel and I need to be reminded one day before that expected date !! How do I code it so that I will get a reminder ...
-
Graduate number in a cell [Closed]
Hello, I have this database on Excel that I want to create. One of the columns will have the date of birth (DOB) and another column will have the...
-
Conditonal Formating [Closed]
I have a training spread sheet that is used to track the due date of the training for our field personnel. We also use it to determine if the trainin...
-
software for finanicial [Closed]
how can i get a software for account system tally ,quickbook
-
countif coloring of cells that were used. [Closed]
Hello, I would like to color cells (or a row) that were used for "countif" values. for example, at my work, i have to indicate private calls f...
-
copying data from multiple workbooks [Closed]
Dear all, Greetings of the day..!!! I m looking for a macro for the below requirement. There are multiple workbooks in a Folder, all workbook...
-
I cant get rid of the false function [Closed]
Hello, I don't know whats wrong with this formula =IF(C4="Single",K4*1, IF(C4="Twin",K4*2, IF(C4="Quad",K4*4))) It keeps saying false in the ce...
-
copy data from multiple workbook in one new workbook. [Closed]
Hello, I have 10 workbooks and have data on Sheet 2 with same Title from Column "B2:N2". All workbooks are in one folder. I want to create a ma...
-
Automatically copy contents from multiple shts to a summary sht. [Closed]
Hello, I've an appointment sheet for each client of mine with their details. lets say like 50 sheets. I'd like to create a summary sheet from all ...
-
date in words [Closed]
Hello i want to know how to convert date into words(english) in excel 2003 or 2007 for eg. 22.04.2010 - convert it into Twenty Two April 2010 or...
-
Excel-copy data in single sheet & populate multiple sheet by PO [Closed]
I'm in need of some guidance: Excel- I have one Master sheet with numerous Purchase Order # with multiple products associated with PO#. We want to sep...
-
Move dated cells up to the top of a list [Closed]
Hello, I have a spreadsheet that I am using for calibration dates. I'm using the traffic light layout for the cells. I would like to know how to...
-
Compare data pairs [Closed]
I do not know if it can be done using excell formuals, but i have a task: i have a table of 3 columns and about 15000 rows of data. I'd like to find...
-
Trying to propagate the status of a project [Closed]
Hello! I need help with a timeline project I am working on. I am pretty basic in excel, but can follow instructions and usually fumble my way to succe...
-
Excel codes [Closed]
Hello, I would like to be able to set up a spread sheet so when I type March on sheet1 in column A it copies the entire row onto sheet 2
-
vba code [Closed]
Hello, sir , i am trying to copy data from one row and paste that data into column of another sheet. this process is continuous till all row no...
-
Cell Color Count with a condition [Closed]
Hello, I need a help. I need to count cells in a range having a specific color (In one column) & cells in a range having a text (In another co...
-
Conditional Formatting based on two cell values [Solved/Closed]
Hi There, I'm using Excel 2016 and am trying to apply a conditional format that searches cells in column A for the text "*DEMO*", and also has a c...
-
Copying cond. format for entire row based on 1 cell to other row [Solved/Closed]
I have conditional formatting for an entire row based on the value of 1 cell. For example: cell value>$A$2 = red, cell value
-
Create separate worksheets/excel files [Closed]
Hello, I need to create an excel file with the following I have a base file and a summary sheet I need to create separate sheets and rename them...
-
Print selected data from a sheet based on the date period select [Closed]
Dear All, I have worksheet that gets updated on a daily basis and want to be able to set it up to automatically print based on the date period sel...
-
Excel data validation [Closed]
I manage a ongoing membership list in Excel. I've noticed typing errors in the the date field for the entered date. Is there a way I can alert the...
-
Macro to compare two excel file [Closed]
Hi Team, I need excel macro to compare two excel file and highlight the difference in the respective cell with both the values in file 1 and 2 .
-
Drop down lists [Solved/Closed]
Hi All, i have a drop down list in excel and the data for the list in a sheet in the same workbook. If I copy the spreadsheet with the list to anot...
-
Excel Combine worksheets into one [Closed]
Newbie here, I have a question on how to do this in excel. I have lots of worksheets, 200+, each with different names, and I was wondering if its p...
-
Removing False Value [Solved/Closed]
Hello, I would like to know how to remove the "False" Value when if function is nested. Here is an Example =IF(G23=0,P15/Sum(D11:F11,IF(G23>0...
-
Copy rows to other sheets based on value in column [Solved/Closed]
All, I have an Excel file with three sheets: Sheet1 contains all my data. Sheet2 named "MACH" and Sheet3 named "FAB" I am looking for a way with a...
-
Automatically save data to another excel sheet. [Closed]
Hello, System Configuration: Windows / Chrome 57.0.2987.110 Please give me suggesstion & Advice to my query, Whenever I enter date in Ex...
-
Macro for copying and pasting (related to answered question) [Closed]
Hello, You recently provided this answer to a question (see below). I'd like to do almost exactly what you recommend, except my spreadsheet has si...
-
VBA date [Closed]
Hello, please can anyone help me? With the below code i'm trying to format the cell color when an date in a cell reaches the system date or a set ...
-
how to calculate values using COUNTIF [Closed]
I have 2 sheets sheet1 is a Summary sheet and sheet2 is data sheet sheet 2 has columns from A TO R, in that column G is Severity (heading) wit...
-
Trying to create a multi-column formula. [Solved/Closed]
Hello, I need help making a formula. I will do my best to describe. The letters (A-I) refer to separate columns. A-B=C to be divided by D the res...
-
formula for multi answers [Closed]
Hello, I'm not yet a member, first time user, however interested to be registered as soon. Hi looking for the right formula for the following....
-
Paste Values copied in alternate rows in a single column [Closed]
Hello, I need to paste some data from 1 column to another column but in alternate rows. for Example:- Data to be copied is as below. Cell Valu...
-
Autopopulate from master sheet? [Closed]
Hello, I've been making, essentially, copies of my and my husbands pay stubs. Currently I'm just copy pasting an "empty pay stub form" and manuall...
-
copy and insert rows [Closed]
Hi, Everyone! I just need help I need a formula or a macro code that everytime I will manually type something on column a,b,c it will be also ge...
-
Changing current font color based on other cell's value? [Closed]
Hello! I would like to change the default font color when entering text in Column B based on the text in a different cell. BUT, I would like to ret...
-
Removing FALSE from return [Closed]
Hello, I have this formula that returns FALSE, can someone tell me how to remove this? Thanks, Ed =IF(Tama!E8,+(Tama!C8))
-
Date with condition [Closed]
Hello, What could be the answer and how If function play Three or more condition applying in date formula? Problem A=Employment Type, B=Join...
-
Update sheet - may be by using a macro [Closed]
Hello, I am trying to make a kind of template file which will be used by different users, most of them even more simple excel users than me :-) The ...
-
VBA/Copy Paste [Closed]
Hello, I have a dataset with 300 rows and 10 columns. the first 4 columns have the metadata and then 6 columns with different values. what I want t...
Subscribe To Our Newsletter!
DON'T MISS
- How to Recover Your Yahoo Account
- Facebook Code Not Received
- How to Create a Gmail Account
- How to Get Free Diamonds in Free Fire
- How to Install a VPN
- How to Recover a Disabled Facebook Account
- How to Upload High Quality Photos to Instagram
- How to Fix a Blurry Snapchat Video
- How to Get More Followers on Instagram
- Computer Boots to Black Screen
- How to Disabled Write Protection on a USB