The discussions
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
Conditional formating
SolvedI have a spreadsheet with Excel 2013 that has text drop down lists. I want to use conditional formatting to highlight with a different cell color, dep...
I need to run multiple automatic macros in one sheet
I am developing a worksheet where there are multiple occasions down a list where users will have to select an option from a drop-down box (Y, N & N/A)...
Convert a date field in excel to day of week
Solved/ClosedHello, I know how to format a cell with a date in it so that it shows the day of the week. WHat I am trying to do is sort on the day of the week so...
Date format
in MS-Excel, When i am sorting the dates in a column of format dd/mm/yyyy, say example 10/06/2007 and 02/10/2007, the sorted column shows 02/10/2007 i...
Conditional formatting of cells with dropdownlist
In column C of my spreadsheet i have created a drop down of a set of 96 locations in US. When i select a certain location from the drop down , i want ...
Comparing columns and returning value
i've following: 1. Drop down values from 1 to 5 in column A. 2. Drop down values from A to E in column B. Ive following matrix (A44:C68): 1 ...
Some help needed about if function with dates
SolvedHello, i m making a sheet with this function =IF(H1