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
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...
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...
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...
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...
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...
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...
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: ...
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 ...
ram-5,raja-2,rani-6,ram-2( i want to know the excel formula for count th total no. of ram )
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...
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 ...
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...
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...
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) ...
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...
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...
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...
I have an excel file containing following data: ID , Amount , Year , Company 1 , 1000 , ...
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...
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...
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)...
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...
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"? ...
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...
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...
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...
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...
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...
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...
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 ...
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...
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 ...
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...
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...
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...
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...
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...
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...
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...
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...
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. we have 8 employees that enter job quote information onto their individual worksheets...
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...
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...
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 ...
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...
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 ?....
I receive an Excel file each month that has the following columns Group Name, DOS, Clinician Rpt Name, (rest of columns have patient information) ...
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,...
DON'T MISS