Re: $$Excel-Macros$$ VLOOKUP to check for multiple occurences of lookup value.

2010-03-05 Thread Christopher Luka
Hi Gaurav, While VBA is great (and I use it often), I recommend only using VBA when you absolutely need to. For starters, many users won't open an XLSM file for security reasons. Second, there are many more people who can maintain Excel formulas than there are those who can maintain VBA code. F

Re: $$Excel-Macros$$ Request

2010-03-03 Thread Christopher Luka
I don't think any of us could legally send you a copy of Office 2010. You should contact the company you purchased it from and ask them to help you. On Wed, Mar 3, 2010 at 1:55 AM, sudhir kumar wrote: > Hi Dear all, > > > Can any one send me setup of MS office 2010. > It was download from net

Re: $$Excel-Macros$$ Re: remove empty cells (rows) between two cells

2010-03-01 Thread Christopher Luka
Whoops, forgot the attachment. On Mon, Mar 1, 2010 at 1:59 PM, Mark Kim wrote: > thanks.. > > um.. where is the code? ^ ^ > > On Tue, Mar 2, 2010 at 6:01 AM, Christopher Luka < > christopher.l...@gmail.com> wrote: > >> OK, I modified the code to leave the

Re: $$Excel-Macros$$ month between two different month..formula

2010-03-01 Thread Christopher Luka
See attached for solution. On Mon, Mar 1, 2010 at 6:18 AM, Umesh Matkar wrote: > Pls suggest formula ..for below conditions > > > > From To Codes > > Jul-09Sep-09 JS0909 > > Apr-09 Jun-09 AJ0909 > > Oct-08 Mar-09 OM0809 > > Apr-08 Sep-08 AS0808 > > Oct-07 Mar-08 OM07

Re: $$Excel-Macros$$ Shell Object

2010-03-01 Thread Christopher Luka
The Shell command allows you to run other programs from Excel VBA. For example, you could type the following to open up Notepad in Windows: Shell "Notepad.exe" Make sense? Chris On Sun, Feb 28, 2010 at 10:45 AM, Harpreet Singh Gujral < harpreetguj...@gmail.com> wrote: > Hi Group, > > Some of

Re: $$Excel-Macros$$ Re: remove empty cells (rows) between two cells

2010-03-01 Thread Christopher Luka
this range, I think I can use the > following code to remove the blank rows.. > > Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete > > Could you revise the code??? > > I really appreciate your help. > > > On Fri, Feb 26, 2010 at 7:33 PM, Christopher Luka <

Re: $$Excel-Macros$$ Dependent drop down lists

2010-02-27 Thread Christopher Luka
Dave & Abhishek, Not so sure that's right. In Hanum's example, A points to C, A points to D, and A points to E. It's a one-to-many relationship. Dave's example contained a one-to-one relationship. Using Hanum's example, if I chose A in the first dropdown, would the second dropdown be changed t

Re: $$Excel-Macros$$ Dependent drop down lists

2010-02-27 Thread Christopher Luka
Check out the attached file. I think it will meet your requirements, and no VBA required. On Fri, Feb 26, 2010 at 11:25 PM, ankur wrote: > hi hanum > plz attach a sample file > so it will more easy for us to help u > > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Dif

Re: $$Excel-Macros$$ Need procedure to allow VBA code by users during runt-time?

2010-02-26 Thread Christopher Luka
My understanding of the way this works is as follows. When a piece of code starts running, Excel compiles the current VBA code and runs from its compiled state. When your code alters the VBA with the custom procedure, it's stored there, but won't run until the current VBA stops executing & the co

Re: $$Excel-Macros$$ how to use the reverse vlookup in excel sheet

2010-02-26 Thread Christopher Luka
As a matter of advice, I'd use the offset/match combination even when you can use a standard vlookup. In most cases, it's quite a bit faster than VLOOKUP, *especially* when you have a large number of rows to process. On Thu, Feb 25, 2010 at 8:45 PM, Manoj kumar wrote: > Hi Anil, > > Please find

Re: $$Excel-Macros$$ Need to add date and time to 2 seperate cells

2010-02-26 Thread Christopher Luka
Take a look at the example attached. If you press Alt+F11 to view the code, you'll see that I attached the code to the Worksheet_SelectionChange event. This fires whenever someone selects a new cell on Sheet1 (in this case). Additionally, I added two lines to prohibit the timestamp from being ch

Re: $$Excel-Macros$$ Re: remove empty cells (rows) between two cells

2010-02-26 Thread Christopher Luka
See attached for example. On Thu, Feb 25, 2010 at 9:44 PM, Ayush wrote: > Hi Markkim, > > Would you please send the sample file containing this data? > > Best regards, > Ayush Jain > > On Feb 26, 6:18 am, Markkim wrote: > > Hi > > I have been trying to make these but have failed. ^ ^;; > > I’d

Re: $$Excel-Macros$$ pls help - Vertical to Horizontal

2010-02-26 Thread Christopher Luka
You might also look up 'loan amortization' in online templates in Microsoft Office. The formulas are all built in so you can study them. On Thu, Feb 25, 2010 at 9:59 PM, ankur wrote: > hi umesh > > for learning vba , u can download books from our file section > > Have A Nice Time & Enjoy Life >

Re: $$Excel-Macros$$ Need help for macro- changing cell value

2010-02-26 Thread Christopher Luka
See attached. On Thu, Feb 25, 2010 at 7:06 AM, Mahesh parab wrote: > Dear All > > I need macro for when i open workbook, A1 cell value, will display 1 to 4 > numbers one by one, time interval should be 15sec. > i want this to create animation effects in pie chart, cell A1 is link with > data by

Re: $$Excel-Macros$$ Named Ranges

2010-02-24 Thread Christopher Luka
There's also a .RefersTo parameter that can be called. On Wed, Feb 24, 2010 at 7:36 PM, Harpreet Singh Gujral < harpreetguj...@gmail.com> wrote: > Hi Group, > > In order to name ranges i use the following code: > > ActiveWorkbook.Names.Add Name:="Ctr1", RefersToR1C1:= _ > Strshtname & "R1

Re: $$Excel-Macros$$ Cell referencing by formula

2010-02-20 Thread Christopher Luka
Here's an example with one way to do it. Let me know if the formula is too complex & I'll walk you thru it. On Wed, Feb 17, 2010 at 10:49 AM, Maitre Bart wrote: > Hi, > > I have some source data in one sheet (Calculations) and formatted data > in a second sheet (Output). > > In the Calculations

Re: $$Excel-Macros$$ Excel Daily Tip : Check VLOOKUP Formula for #NA Error without Slowing Down Co...

2010-02-20 Thread Christopher Luka
A couple of points: 1. IFERROR doesn't work on versions older than Excel 2007. 2. Second, if your concern is speeding up VLOOKUPS, switch to a combination of INDEX & MATCH. It's much faster. On Sat, Feb 20, 2010 at 8:07 AM, Ayush Jain wrote: > Ayush Jain has sent you a link to a blog: > > Dear

Re: $$Excel-Macros$$ Variable Formula Reference

2010-02-20 Thread Christopher Luka
If I'm not mistaken, what you're looking for is a *formula* that will dynamically grab the value from Sheet1!A2 for Sheet2, Sheet1!A3 for Sheet3, Sheet1!A4 for Sheet4, etc. If so, then the attached file should work for you. Note that this formula VERY MUCH depends on the fact that the worksheet n

Re: $$Excel-Macros$$ Any way to use customer icons with conditional formatting?

2010-02-02 Thread Christopher Luka
One easy way to do it is to use the camera tool & named ranges. The basic idea is contained in the link below. You'd just swap out the traffic lights for your own icons. http://www.exceluser.com/solutions/traffic.htm On Mon, Feb 1, 2010 at 12:50 PM, TD wrote: > I am doing analysis of 8 possib