Excel Forum
-
Count only cells containing 2 given words [Closed]
Dear friends, I simply get mad trying and trying again to find the right function that may help me to count out of an array only the cells that conta...
-
Copy Data from Sheet 1 to Sheet 2 [Closed]
I need to copy data from sheet 1 to sheet 2 based on a Keyword or search criteria. However, the data is available in hierarchical format. I need a pr...
-
Cell to populate if other column has any text [Closed]
Hello, I'm struggling to find a formula to populate one column's cell based on another column's cell having at least one character of text. e.g. A1...
-
Change cell text based on another cell's color [Closed]
Hello, I need to prompt a cell to write text based on another's cell color in excel but not using VB. Can you help? System Configuration: Windows /...
-
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 Val...
-
vba code [Closed]
Hello, I need to compare 2 excel worksheets. sheet1 - col A, B, C sheet 2 - col A, B, C Compare Col A and B of sheet 1 and 2 --> if they match th...
-
add "only" at last after converting numbers into words ? [Closed]
Hello, how to put "only" at last after converting numbers into words ? thank you System Configuration: Windows / Chrome 56.0.2924.87
-
Merging Mutiple Sheets column data when if conditions passes [Closed]
Hello, I have excel book with multiple sheets. Rows count with data will differ in each sheets. And column C with have two data "Come" & "Out" Wh...
-
Insert picture in Excel macro which takes the file name refrence [Closed]
Hello Friends, Kindly help me! I am trying to insert a picture in excel macro which takes the file name reference from the D5 cell and insert th...
-
VBA code for deleting rows where a column does not correspond [Closed]
Hello I am trying to get a code that will delete lines where the column on one sheet does not correspond to the criteria in another (i.e. the date - ...
-
Formula for text in a cell and then total the amount on text [Closed]
Hello im trying to total the shfit allowance on timesheets eg: In cell k7 they will leave blank if not claim shift allowance, but if they are then ce...
-
Changing font color [Closed]
Hello, I need help, I want to change the font color to be black for cell A, if cell B is "done", else keep the due date in red in cell B. For exmp:...
-
Create a new Excel file based on data in column [Closed]
Hello, I've spent hours searching and trying different macros with no avail. I'm not new to excel, but new to macros and coding. I have a spreadshee...
-
Change Value of Subsequent Cells Once A Condition Is Met [Closed]
The simplified story: I have a user input "Start Month" that is between 1-12. I have Columns A:M labeled accordingly 1-12. The question: If the us...
-
Date change [Closed]
The interfaced data date from an EMR system to my system reported as an Excel has the date with Year, month and date, example 2017-01-15. I am trying...
-
Excel formulla [Solved/Closed]
Hello, I want to split cell of available qty in to multiple cell according to requirement. Input Sheet -1 Material PO qty Req. Qty ...
-
VBA To automatically insert subtotals in multiple worksheets [Closed]
Good Day, I hope somebody can help me, I have an workbook with a main sheet ""2017 Sales" and 10 worksheets with the name of each individual sales Age...
-
Open workbook using following code [Closed]
Private Sub CommandButton1_Click() Workbooks("Patch.xlsm").Activate Sheets("Site Name").Select S = Range("A1:A2") D = Range("B1:B2") E = Range("B...
-
auto insert new row and copy data from cell above [Closed]
hello, I have looked but can not seem to find. I need a macro that will insert a new blank row row below and copy cell A10 from above and paste it to...
-
Creating reminders AND/OR email reminders in Excel 2010 [Closed]
Hello, I would like to create a spreadsheet with the following information; Name Address Sender ...
-
Add value from column 2 if column 1 equals to "Yes" [Closed]
Hello, I want to create a histogram of spenditures and automatically summarize them in a table next to it. So if a value (cell b2) is in the categor...
-
Database copy only certain information [Closed]
Hello, I currently have a table with data containing peoples information for a sports program, I would like it if I put "Yes" in the coloumn for the...
-
Define paragraph formatting [Closed]
Define paragraph formatting
-
Search a list of names at one time in excel [Solved/Closed]
Hi, I have a huge list of names (list A) which I need to search with another list of names (list B) and see if any name in list A is in list B . Is i...
-
moving line data by entering data into 1 of 3 specific cells [Closed]
Hello, I am trying to move an entire row of data by entering into 1 of 3 specific cells (M5-O5) on the same line that will also color code it, to th...
-
How to automate new sheets to display the next row of data? [Closed]
Hi guys, I am currently trying to automate my database from the surveys. I have sheet 1 which shows every answer from all participants and on sheet ...
-
Automate new sheet to show the same setup of rows and columns [Closed]
Hi guys, I am currently trying to automate my database from the surveys. I have sheet 1 which shows every answer from all participants and on sheet 2...
-
Missing in Loop for Data Validation [Closed]
Hello, I would like to request that in the given code please add this feature that at every 14 rows data validation applied and then skip 5 rows aft...
-
Comparing data in worksheets [Closed]
I have 2 worksheets in the same workbook; both are set up exactly the same with each having the same header row. I want to compare the last name cells...
-
Autofil random cell in another worksheet [Closed]
Hello, Please help me write the code for below situation: 1. I have 2 sheet "Merger_Pole" and "Config". 2. In Merger_Pole, I set F2=Config!C29 (ra...
-
Help tallying names and days worked in a calendar [Closed]
Hello, I have created a calendar in excel that will be populated daily with the name of the individual working that day. I would like to tally how m...
-
If a cell contains any text then add a value (with dates) [Solved/Closed]
I am looking for help with a formula that will allow me to add up the number of times a certain date is a Monday. I am using =COUNTIF(A1:A30,"*Monday...
-
Macro to increase a cell reference by 11 [Solved/Closed]
Hi everyone I want a macro that on open will increase the cell reference in a cell by 11 each time the book is opened i.e. Cell C18 has =Sheet2!H2. T...
-
Totaling OT Hours on Separate Sheet [Closed]
Good Morning! https://drive.google.com/file/d/0Byqv0sZOGZaHRUNuUlNUc1RKbWM/view?usp=sharing I have a spreadsheet that managers fill out with overtim...
-
Help comparing two columns in excel, returning third w/dups [Closed]
Hello, I have have found on here some help in comparing two columns and if there is a match, copying a third column, but I need a way to receive an ...
-
Automatically Transfer rows from 1 sheet to another using a Comm [Closed]
Hello, I am very new to excel codes etc... I have a spread sheet that I would like to automatically transfer rows from 1 sheet "Current" to anothe...
-
MAC OS, BIG FILE Split Data into seperate Worksheets [Closed]
Hello, To begin I require a rather large Excel (.csv) file to updated every 2 days. This file consists of roughly 23000 records and spreads from the...
-
Transposing [Closed]
Hello, I have a sales report provided to me monthly that has the following details: product code, product name, year and month. The format looks lik...
-
creating a formula If a cell is equal to or less than 7.00 [Closed]
Hello! I am looking for a formula that will do the following: If a cell is equal to or less than 7.00, the entire row which contains said cel...
-
Points system formulas [Closed]
Hello, I am looking for some helping with creating some formulas. What i am trying to do is something like a points system for 1st, 2nd and 3rd, etc...
-
Code Required in vba [Closed]
I have an task related issue.. we have total 3 Timesheets which contains planning,execution etc in each row ..suppose i have 20 employee timesheet and...
-
Inserting a Prefix based on cell color [Closed]
Hello, I have an answer key in excel, which indicates correct answers with a green cell background. I need to insert a "*" prefix for each correct...
-
conversion of DOB to full words [Solved/Closed]
Hello, Configuration: iPhone / Safari 4.0 I want to to convert dob to word like 5/6/2014 to fifth June two thousand fourteen please tell me...
-
find specific values in a cell based on the text behind [Closed]
Hello, Let me give you the example first. The cell has the following text: 7 Pages TRA, 23 Pages PRF, 97 Words TRA, I would like to find the value...
-
Data auto change on multiple status in one column [Solved/Closed]
Hello again, Few days ago i am looking for a command that can use to change data status in one same column. Example : 'Activated' change to 'Expired...
-
Master sheet auto-populating anniversary dates into new sheets? [Closed]
Hello, I have a master sheet that has our employee information and start dates where I have broken up their start dates into different columns for t...
-
identify the frequency of times [Closed]
Looking for a way to identify the frequency of times a name in column A exceeds the value of its outcome in column c when compared to its expected out...
-
separate version type and names [Closed]
Hello, I have data on browsers used by users where in I need to separate version type and names. I am struck up in the middle. Formula used by me is...
-
Multi Sheet formula [Closed]
I am trying to figure out how to automatically find and remove duplicates across several sheets. The purpose of this is to have a master list of my in...
-
Date adjustments by 6 months [Closed]
Hello, I am in search of some expertise advice. Im trying to figure out if there is a formula to add 6 months from a date to another cell. What I ...
Subscribe To Our Newsletter!
DON'T MISS
- Computer Boots to Black Screen
- How to Get More Followers on Instagram
- How to Upload High Quality Photos to Instagram
- How to Create a Gmail Account
- Facebook Code Not Received
- How to Get Free Diamonds in Free Fire
- How to Recover a Disabled Facebook Account
- How to Disabled Write Protection on a USB
- How to Install a VPN
- How to Recover Your Yahoo Account
- How to Fix a Blurry Snapchat Video