$$Excel-Macros$$ Left VLookup

2009-03-16 Thread Alokeshwar Tiwary
Just thought of sharing this function with the group. I created it to elaminate lengthy match index formula from my reports _ "There are known knowns. These are things we know that we know. There are k

$$Excel-Macros$$ Re: macro to reference a different workbook

2009-03-16 Thread rspowell
Sub OtherWorkbook() Dim WorkbookName$ Dim varValue As Variant ' Variable for the workbook name ' -- or you can make this an array of names WorkbookName$ = "MyWorkbook.xls" ' Variable for a value from Sheet1 of that workbook ' -- in this example, gets a value from range "B2" va

$$Excel-Macros$$ macro to reference a different workbook

2009-03-16 Thread Vishwajeet Kumar
Hi, I am struggling to link my macro to a different workbook from which i need the data. Basically, my requirement is like this: There are two different workbooks with say five worksheets each. Now what i want to do is use informations form i th worksheets in workbook2 into ith worksheet in wor

$$Excel-Macros$$ MICRO AND MACRO

2009-03-16 Thread RAHUL SUREKA
RESPECTED SIR, MYSELF RAHUL KUAMR SUREKA. I M CURRENTLY USING MS-OFFICE 2007.SO,PLEASE TELL ME HOW TO USE THE FUNCTION OF MICRO AND MACRO IN EXCEL.PLEASE TELL ME THAT IS THERE IS ANY DOWNLOAD SITE FROM WHERE I CAN DOWNLOAD SOME USEFUL TIPS REGARDING EXCEL.,THEN PLEASE MENTION TH

$$Excel-Macros$$ Re: required help

2009-03-16 Thread Ajit Navre
You can format the cell to display the number as 1.10.2.30. Format->Cells->Number->Custom Type in the format as 0\.00\.0\.00 Now, the underlying value of the cells will continue to be 110230 (a number), but will be displayed as 1.10.2.30, you can then suitably increment or decrement par

$$Excel-Macros$$ Re: required help

2009-03-16 Thread Aindril De
Hi Abdul, Is there a fixed number of lines you want to cover? Or does this depend on data of some other cell? Regards, Andy On Mon, Mar 16, 2009 at 5:10 PM, Abdul Hakim Khan wrote: > Hi All, > can anybody help me out to solving this problem into excel. > I want to display following item automat

$$Excel-Macros$$ Re: required help

2009-03-16 Thread Mithoo jee
if it is ok... Select the column and go to menu > Format > Cells > Numbers > Custom and put this as format 0-00-0-00 and say ok now when you type 110230 will convert 1-10-2-30, then in cell below put formula +a1+10 and drag it down upto where u want... hope this helps. On Mon, Mar 16, 2009 at 1

$$Excel-Macros$$ Re: required help

2009-03-16 Thread Harmeet Singh
I hope attached file helps. On Mon, Mar 16, 2009 at 3:40 PM, Abdul Hakim Khan wrote: > Hi All, > can anybody help me out to solving this problem into excel. > I want to display following item automatically through condition or > formulla. > 1.10.2.30 > 1.10.2.40 > > and so on > > Regar

ignore my previous message....Re: $$Excel-Macros$$ required help

2009-03-16 Thread Mithoo jee
ignore my previous message and use the format as below: Select the column and go to menu > Format > Cells > Numbers > Custom and put this as format 0"."00"."0"."00 and say ok now when you type 110230 will convert 1.10.2.30, then in cell below put formula +a1+10 and drag it down upto where u want.

$$Excel-Macros$$ required help

2009-03-16 Thread Abdul Hakim Khan
Hi All, can anybody help me out to solving this problem into excel. I want to display following item automatically through condition or formulla. 1.10.2.30 1.10.2.40 and so on Regards Abdul Hakim Khan KSA Al Jubail abdulhakimk...@gmail.com --~--~-~--~~~---~--~