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

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

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

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

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

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

1 reply 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!

5 replies 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

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

4 replies Last reply on 9 Jul 2013 by
zs1986

Convert a date field in excel to day of week

 Solved/Closed

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

7 replies Last reply on 7 Jul 2013 by
Indian

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

1 reply Last reply on 6 Jul 2013 by
sgmpatnaik

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

1 reply Last reply on 6 Jul 2013 by
venkat1926

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

7 replies Last reply on 6 Jul 2013 by
venkat1926

Some help needed about if function with dates

 Solved

Hello, i m making a sheet with this function =IF(H1

3 replies Last reply on 5 Jul 2013 by
sgmpatnaik
Results 4501 - 4550 out of a total of 12,258