The discussions

Find and compare calues in two columns

 Solved

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 ...

2 replies Last reply on 2 Aug 2013 by
mswonderer

Help with cell programming!

 Solved

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...

10 replies Last reply on 1 Aug 2013 by
ozfox999

Conditional formatting in excel2010

 Solved

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...

2 replies Last reply on 30 Jul 2013 by
Peter

Help needed in using marcos

 Solved

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) ...

4 replies Last reply on 30 Jul 2013 by
Asmodeux

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...

1 reply Last reply on 30 Jul 2013 by
TrowaD

Conditional formatting in excel - off of a range of cells

 Solved

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...

6 replies Last reply on 30 Jul 2013 by
TrowaD

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...

9 replies Last reply on 30 Jul 2013 by
TrowaD

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...

1 reply Last reply on 30 Jul 2013 by
recovertools

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 ...

1 reply Last reply on 30 Jul 2013 by
recovertools

Simple macro for data cleaning, help appreciated

I have an excel file containing following data: ID , Amount , Year , Company 1 , 1000 , ...

1 reply Last reply on 30 Jul 2013 by
venkat1926

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...

5 replies Last reply on 29 Jul 2013 by
TrowaD

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...

1 reply Last reply on 29 Jul 2013 by
TrowaD

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...

5 replies Last reply on 27 Jul 2013 by
wraith373

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"? ...

1 reply Last reply on 26 Jul 2013 by
ac3mark

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...

1 reply Last reply on 25 Jul 2013 by
TrowaD

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...

Last reply on 24 Jul 2013 by
Ambucias

Excel help on if formula

 Solved

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...

5 replies Last reply on 24 Jul 2013 by
ac3mark

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...

Last reply on 23 Jul 2013 by
Devarajan

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 ...

1 reply Last reply on 23 Jul 2013 by
TrowaD

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...

1 reply Last reply on 23 Jul 2013 by
TrowaD

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 ...

1 reply Last reply on 23 Jul 2013 by
TrowaD

Date formatting in dd/mm/yyyy

 Solved/Closed

Hello, 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...

Last reply on 23 Jul 2013 by
appu

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...

1 reply Last reply on 22 Jul 2013 by
ac3mark

Macro to search/replace text from another column

 Solved

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...

2 replies Last reply on 18 Jul 2013 by
mylove0mylife

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...

2 replies Last reply on 18 Jul 2013 by
deyamag

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...

1 reply Last reply on 18 Jul 2013 by
TrowaD

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...

1 reply Last reply on 18 Jul 2013 by
TrowaD

Won't save passwords / usernames

 Solved/Closed

Hello, 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.

Last reply on 18 Jul 2013 by
arendtrepair

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...

3 replies Last reply on 18 Jul 2013 by
TrowaD

Urgent ansin excel

 Solved

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...

1 reply Last reply on 18 Jul 2013 by
venkat1926

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 ...

3 replies Last reply on 18 Jul 2013 by
venkat1926

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...

Last reply on 17 Jul 2013 by
Ambucias

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...

1 reply Last reply on 16 Jul 2013 by
TrowaD

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 ...

1 reply Last reply on 16 Jul 2013 by
TrowaD

Popup reminder based on date and additional celll values

 Solved

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...

10 replies Last reply on 15 Jul 2013 by
MikeTis

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 ?. ...

1 reply Last reply on 15 Jul 2013 by
Ambucias

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,...

3 replies Last reply on 15 Jul 2013 by
TrowaD

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.

1 reply Last reply on 14 Jul 2013 by
Nathan :)

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...

1 reply Last reply on 14 Jul 2013 by
venkat1926

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...

3 replies Last reply on 13 Jul 2013 by
venkat1926

How i convern number to spelling in excel

Dear friend, This is my problem. Please solve it.

1 reply Last reply on 12 Jul 2013 by
Ambucias

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...

3 replies Last reply on 12 Jul 2013 by
venkat1926

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...

1 reply Last reply on 11 Jul 2013 by
Muhasin AM

Word markup area

 Solved/Closed

Hello, How do I turn off markup area in Word? Thanks!

Last reply on 10 Jul 2013 by
car234

Hide rows with zero value in multiple sheets

 Solved

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...

2 replies Last reply on 10 Jul 2013 by
Excellent answer

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. ...

3 replies Last reply on 10 Jul 2013 by
venkat1926

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...

1 reply Last reply on 10 Jul 2013 by
venkat1926

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, ...

1 reply Last reply on 9 Jul 2013 by
TrowaD

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

1 reply Last reply on 9 Jul 2013 by
TrowaD

Conditional formating

 Solved

I 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...

10 replies Last reply on 9 Jul 2013 by
jgmb
Results 4501 - 4550 out of a total of 12,264