Excel Forum
-
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/downloads/professional/5605-pdf-to-excel-converter/ product. This product is very good. Is this a free version availa...
-
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,...
-
Plotting multiple data Closed
Hello, How do I plot a table with multiple data like this: For May: Project 1 Project 2 Project 3 Item 1 5% ...
-
comparing the two excel sheet, what formula is required Closed
I have two excel sheets one column haveing the same numbers both the sheets, Now in same number I have alloted different compaines, now I need to ...
-
Help with a Formula 'Isblank refer to another cell" Closed
I need a formula that will give me number of days between two columns Which contain dates, if one or the other has no date populated it would then ref...
-
Averaging & Assigning Blank Cells a Specific Numeric Value Closed
Good day everyone. I'm sorry if this seems remedial, but I'm having trouble with a spreadsheet. Here's the gist of my problem: Within a row, I have se...
-
proportions?ratios? not sure Closed
I have an excel spreadsheet with four different money columns. I am trying to develop a formula that might create a comparison similar to what I thin...
-
Copy data from Master Sheet to Client Sheets Closed
Hello All Good Day I Need Some help from you that is i want to copy the data from Master Sheet to Client Sheets with Criteria Columns for your b...
-
How I convern number to spelling in excel Closed
Dear friend, This is my problem. Please solve it.
-
Pull values from conditionally formatted cells - Excel 2013 Closed
hello, I have a large data set wherein I am trying to figure out where certain values fall and am applying a cell color using conditional formattin...
-
How to add a seperator / between fields, create function Closed
Hi, I am running a macro copying AA2:AA300 to B and copyiing AB2:AA300 to C this is done for 20 more columns going in B and C how can I add a line...
-
Comparing Columns Closed
Hello, I have two list of customers on separate excel worksheets. The first list has name, address, etc. in separate columns and about 3000 custome...
-
Hide rows with zero value in Multiple sheets Solved/Closed
Please help me in making a macro in the Excelsheet that: I can hide the entire rows if a cell value or (range of values) has a zero value in multiple...
-
Populate rows on sheet1 based on values in sheet2 Closed
Hi, I need to populate rows in sheet1 -- S.No, Name , Address, Contact No. with the values present in sheet2 -- S.No, Name , Address, Contact No. ...
-
pop up alert Closed
Hello, I have created a worksheet with macro to enter current time by clicking on a cell. For example, double click on A1 to enter current time th...
-
Display Formula in Cell with values Closed
i need to display the used formula in another cell as it is with substituting the values. example: if A1=100, A3=200, B1=206 formula is =SUM(A1, ...