$$Excel-Macros$$ Re: Validating a column of numbers against another worksheet

2009-01-03 Thread Dave Bonallack
Hi Rob, This problem is better solved with conditional formatting. Select all the valid ICD9 codes on the second sheet, and name the range - let's say, List Then on 1st sheet, select all the cells you want to check, and any blank cells that might have codes entered into them later. Select Format

$$Excel-Macros$$ Pick up values from alternate rows?

2009-01-03 Thread anu mittal
Hi, I have a large data set that needs to be organized in the excel. Is there an excel formula or a macro that can pick up values from every 6th row or 7th row in column A and paste it in a different column (as in every 6th row value in column b and 7th row in column c)? Any help on this is great

$$Excel-Macros$$ Validating a column of numbers against another worksheet

2009-01-03 Thread Rob Bunocore
I have a list of Diagnosis codes entered into 5 columns on a worksheet. The second worksheet, named ICD9 Codes, lists all the possible ICD9 Codes that are valid. I want to create a macro that you could activate at the top of a column and it would validate each number against the list in the seco

$$Excel-Macros$$ Validating a range of cells

2009-01-03 Thread Rob Bunocore
I have a list of Diagnosis codes entered into 5 columns on a worksheet. The second worksheet, named ICD9 Codes, lists all the possible ICD9 Codes that are valid. I want to create a macro that you could activate at the top of a column and it would validate each number against the list in the seco

$$Excel-Macros$$ Excel Macro

2009-01-03 Thread Kamal Gulati
Hi friend, Can any one send me the simple steps and sample file to create Macro's in Excel. As I am new in macro's in excel plz send me all the steps with example. Thanks and regards, = - k...@m@l' g...@ti' - = Ph: +91 9899101928, 9718361928 --

$$Excel-Macros$$ Military leave tracking

2009-01-03 Thread Anthony
I would like to design an excel workbook to track leave for Soldiers in an effort to make sure that I have sufficient manpower to complete all my missions. I would like it to do the following: 1. On sheet 1, input rank and name, leave start and end dates 2. Pass this information into a calendar

$$Excel-Macros$$ Military leave tracking

2009-01-03 Thread Anthony
I would like to design an excel workbook to track leave for Soldiers in an effort to make sure that I have sufficient manpower to complete all my missions. I would like it to do the following: 1. On sheet 1, input rank and name, leave start and end dates 2. Pass this information into a calendar

$$Excel-Macros$$ Re: Help required

2009-01-03 Thread ajay kashyap
You can use Adobe Acrobat Professional Edition 6.0. Ajay On Sat, Jan 3, 2009 at 11:08 AM, jagjeet singh wrote: > Dear friend > > > > If you are using Excel 2007 you can use the utility available at Microsoft > site wherein you can download a plugin to save the file in PDF format. > > > > Just s

$$Excel-Macros$$ Re: Help required

2009-01-03 Thread bikramjeet singh
Hi Friend, Just upload your excel or word document to google docs. And then convert it into PDF or any format. On Sat, Jan 3, 2009 at 11:08 AM, jagjeet singh wrote: > Dear friend > > > > If you are using Excel 2007 you can use the utility available at Microsoft > site wherein you can down