Excel Forum
-
IF SUM commands [Closed]
Hi! I have a column with number of mice drinking water.. 5 3 8 7 15 10 =IF(A3>10, 300,IF(A3>=7, 250, IF(A3
-
Delete Rows Based On Phrase in Column [Closed]
I am trying to make a macro that deletes a row in a column if it detects a set of specific words or phrases. "Friendly's" "Ruth's Chris Steak Ho...
-
Help - Macro to delete rows with specific text or phrase. [Closed]
I am trying to make a macro that deletes a row in a column if it detects a set of specific words or phrases. "Friendly's" "Ruth's Chris Steak Hou...
-
Creating new sheet and transferring data to new sheet [Closed]
With due respect I would like to have some Guidance for creating a excel sheet. My sheet is Date name in out time. This sheet contains 746 rec...
-
Inserting multiple rows with copy and paste the existing data [Closed]
Hi The below code works fine with inserting new rows but I need an extension of the code to incorporate copy and paste function on the existing ro...
-
Help Please with calculating large data in Pivot Table [Closed]
Dear Sirs, Can some one please help me with creating a better Pivot Table in Excel 2010. I work for an automotive company and so have to track all...
-
Conditional formatting can't caputure text...NEED VB CODE PLEASE [Solved/Closed]
Hello, I understand i can't use c formatting to insert text and therefore am looking for a piece of code that will perform the following. Consi...
-
Conditional Formatting Based On Changing Dates [Solved/Closed]
I am trying to keep on top of dates that are changed weekly based on last weeks dates, but i need to highlight the changed cells only. Example: ...
-
Conditional Formatting based on two conditions [Closed]
I need to know how to set up a conditional Format for a worksheet that changes every month. I need to have the format highlight an entire row if the ...
-
please answer me. [Closed]
ram-5,raja-2,rani-6,ram-2( i want to know the excel formula for count th total no. of ram )
-
Formula help [Closed]
I have a table of window blind size prices. The price changes due to the width and drop of the blind. The headings along the top of 450mm, 600mm, 750m...
-
find and compare calues in two columns [Solved/Closed]
Hi i need to look for values (strings) in column A and see if exist in column B. if exist return the line number. (tried vlookup but i get only ...
-
Help with cell programming! [Solved/Closed]
Hi everyone. this is my first time here, and in desperate need of help from some Excel Genie to make my wish come true! Ok, here is my "urgent" pro...
-
Conditional Formatting in Excel2010 [Solved/Closed]
I wish to have the following CF in more than three colours. I have placed the following in Data List L1,L2,L3,L4,L5,L6,M7,M8,M9,M10,M11,H12,H1...
-
Help needed in using marcos [Solved/Closed]
Hi, I need to write a marco that is able to compare the specific column in 2 different worksheets within the same workbook. (i.e Names of staffs) ...
-
how to automatically send an email when a drop down list update [Closed]
Hello, I have looked into most of the other problems people have regarding excel, and can't seem to find a solution to my particular problem. So hope...
-
CONDITIONAL FORMATTING IN EXCEL - off of a range of cells [Solved/Closed]
Hi I've never used these forums before but this issue has been bugging me for some time now.... so i thought i would leave it to the experts.... I...
-
How to modify the macro code for new structure of table [Closed]
Hello, The short description an idea of macro code in the table Z is that if I add 2014 etc. (and other new sheets). It is directly moving me XYZ...
-
Simple macro for data cleaning, help appreciated [Closed]
I have an excel file containing following data: ID , Amount , Year , Company 1 , 1000 , ...
-
Macro to search and copy specific info on the next blank line [Closed]
I am hoping someone can help me. I will be as detailed as possible, but please let me know if you need more information from me. What my end goal i...
-
How to extract data & create database from different excel sheet [Closed]
Hi I have data of around 4000 companies from one data sources in an spread sheet I have data of M&A, Joint ventures and wholly owned subsidiarie...
-
Marcos help needed [Closed]
Hi, I need to write a marco that is able to compare the specific column in 2 different worksheets within the same workbook. (i.e Names of staffs)...
-
trouble with a send key macro [Closed]
i am trying to get a sendkeys macro in excel to send a string of keystrokes to another program and repeat ten times. the macro i have now will send th...
-
How to add confirmation window [Closed]
Hello, I used below mentioned macro for locking teachers mark entry file. How to add a confirmation window like "Do you want to lock your data"? ...
-
COUNT IF AND COUNT A [Closed]
I need to count column C if cell equals "medicare" only on the same line column A has text. Column a is made up of names. I just don't need it to cou...
-
Excel Macro to use set of product numbers to delete from List [Closed]
Hello All, I am looking to create a macro that will be using a set of product numbers that should not be listed in a master list that is located i...
-
macro [Solved/Closed]
I want to write a macro from the start, I have date of employee name and their attendance on a workbook and on the other workbook I have a calendar. N...
-
Excel help on IF formula [Solved/Closed]
I want to say IF cell L27 equals the word 'low' then do sum of cell x * cell y, if cell L27 equals the work "expected" then do Sum of Cell a * b and i...
-
Macro to Extract from Different Workbooks & Multiple Worksheets [Closed]
Hi, i've been trying to figure out how to extract multiple data from different workbooks with multiple worksheets and paste them into a master shee...
-
combining two separate macros into one [Solved/Closed]
Hello, I currently am using these two separate macros independently but would like to combine them into one with the archive one being first. I'm...
-
Reminder in Excel spreadsheet [Closed]
Hi Team, I am trying to put a reminder in excel spreadsheet, I tried one macro, but its not popping up. Can any one you please help me to get this ...
-
Copy data from worksheets to master sheet [Closed]
Hi, I have one input workbook with multiple worksheets(all are with same table format) and I have to look in to each worksheet and if there value t...
-
How to compare two different columns [Closed]
Hi, I have a sheet with Id numbers in column A and names in column B, for around 50 workers. In other sheet I have Id number in column A, names in ...
-
How to the text/word of a cell in excel 2010 [Closed]
Hi, I am working on creating an excel spreadsheet in which I want a series of names to be outputted if the condition of another cell is valid. F...
-
Macro to Search/Replace Text from another Column [Solved/Closed]
Hello, I didn't realize I was being rude on my previous post, that wasn't my intention. I tend to have a "too the point" personality sometimes, and...
-
Rename a tap [Closed]
Hello, frist I'm so sorry for my mistake , pls forgive me I don't mean that . always thanks every one, I don't no how I do that! If you please...
-
Automatics mail with attachment to send using Outlook [Closed]
Hello all, I am very new to excel file so need help from this group. I have data (PDF and Excel), now i want to send automatics mail using Outlo...
-
Conditional format text cells based on a column with numbers [Closed]
Hello, So I have text cells describing what the numbers in the column next to it mean, however, I want the conditional formatting (data bars) to s...
-
EXCEL HELP [Closed]
Hello, Novice needs help I am trying to extract the contents of cells from several worksheets and summarize on one Header Summary Sheet So i...
-
Macro to filter out text contents [Closed]
i have Column E filled with numbers, formulas and text. I would like to write a macro to filter out the cells with text contents. The text contents do...
-
urgent ansin excel [Solved/Closed]
a table caring 4 rows, first row is Name, second is address, 3rd row is date, and forth row is house name. how i arrange this in excel in date wise...
-
Automatically Rename Cells [Closed]
Hi, i am using Excel 2010 ...quite poorly as my skills are basic. I am trying to work out how to Incrementally number worksheets automatically ie ...
-
Transfer data from one Excel worksheet to another automatically [Closed]
Transfer data from one Excel worksheet to another automatically. we have 8 employees that enter job quote information onto their individual worksheets...
-
Tables [Closed]
Hello, I am trying to extract the contents of cells from several worksheets and summarize on one Header Summary Sheet So i'm trying to generate...
-
macro to delete rows between named ranges in excel [Closed]
How do I delete all rows between named ranges? I have a scenario below Name Range 1 : SUBHEADER_001 (A1:E1). Displays Headers Name Range 2 : SU...
-
I need help in my project [Closed]
first see this picture http://img713.imageshack.us/img713/6725/d9i8.png now what i want is, after typing the '2' in B2, i press Enter, D2 will be ...
-
Popup reminder based on date and additional celll values [Solved/Closed]
Hi, I am new to this site and have seen a lot of great information and helpful tips here. I have been trying to figure this out for a very long tim...
-
PDF Converter to excel : [Closed]
Hi, I saw https://ccm.net/download/download-7685-pdf-to-excel-converter product. This product is very good. Is this a free version available ?....
-
Macro to Search and Replace Text from another Column [Closed]
I receive an Excel file each month that has the following columns Group Name, DOS, Clinician Rpt Name, (rest of columns have patient information) ...
-
macro to populate formula using Autofill [Closed]
i have 2 worksheets, A & B. In worksheet A, i have the data in cell F2, F3, F4. In worksheet B, i would like to refer worksheetA!F2 in Column G,...
Subscribe To Our Newsletter!
DON'T MISS
- How to Get More Followers on Instagram
- How to Recover a Disabled Facebook Account
- How to Recover Your Yahoo Account
- How to Disabled Write Protection on a USB
- How to Fix a Blurry Snapchat Video
- How to Create a Gmail Account
- Computer Boots to Black Screen
- How to Install a VPN
- How to Get Free Diamonds in Free Fire
- Facebook Code Not Received
- How to Upload High Quality Photos to Instagram