The discussions
Formula help
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
SolvedHi 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!
SolvedHi 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
SolvedI 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
SolvedHi, 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
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
SolvedHi 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
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...
Cant send out emails from my outlook2010-error
Hi All, I use gmail using outlook on my laptop, i can receive emails into my out look but can't send out from outlook, it gets stuck in the outbox...
Send/receive error
Hi Friends, I configured Outlook 2003 for yahoo & gmail on a Windows 7 computer. yahoo profile is working fine but gmail profile is not working ...
Simple macro for data cleaning, help appreciated
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
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
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...
Trouble with a send key macro
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
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
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...
Macro
Solved/ClosedI 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
SolvedI 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...
Combining two separate macros into one
Solved/ClosedHello, 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
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
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
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 ...
Date formatting in dd/mm/yyyy
Solved/ClosedHello, I have got dates typed in the format following 01.08.98 and I want to change it to 01/08/1998 format. I tried applying the format we have i...
How to the text/word of a cell in excel 2010
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
SolvedHello, 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
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...
Conditional format text cells based on a column with numbers
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
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...
Won't save passwords / usernames
Solved/ClosedHello, Computer won't save passwords / usernames, even when I ask it to and I have went into tools and everything was set as suppose to.
Macro to filter out text contents
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
Solveda 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
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
ClosedTransfer data from one Excel worksheet to another automatically. we have 8 employees that enter job quote information onto their individual worksheets...
Macro to delete rows between named ranges in excel
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
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
SolvedHi, 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 :
Hi, I saw https://ccm.net/downloads/tools/5605-pdf-to-excel-converter/ product. This product is very good. Is this a free version available ?. ...
Macro to populate formula using autofill
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,...
Ms word
after i move documents to my usb, then i cant open word documents anymore and also my microsoft office word does not open.
Help with a formula 'isblank refer to another cell"
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
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...
How i convern number to spelling in excel
Dear friend, This is my problem. Please solve it.
Pull values from conditionally formatted cells - excel 2013
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...
Comparing columns
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
SolvedPlease 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
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
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
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, ...
Macro for copying sheet 1 into sheet 2 and then deleting data in
i need macro for copying sheet 1 into sheet 2 and then deleting data in sheet 1 and sheet 3 plz help
