$$Excel-Macros$$ VLOOKUP with multiple dependents

Hi All I have a little query regarding VLOOKUP Formula. I have been using it depending on only one value. But now I want to use for two dependents. The attached file has two sheets one with the master data and the other one where I extract data using VLOOKUP. *Customer No.* *Proposal No.* *

$$Excel-Macros$$ Vlookup using multiple dependents (Ractified attachment)

Hi All I have a little query regarding VLOOKUP Formula. I have been using it depending on only one value. But now I want to use for two dependents. The attached file has two sheets one with the master data and the other one where I extract data using VLOOKUP. *Customer No.* *Proposal No.* *

$$Excel-Macros$$ Re: help needed regarding protecting excel files

Hi Suneeta, One way of protcting all xl files in a folder is to write a macro which will individually set a password you specify for all files in that folder. If you insist I can write such macro for you. Sharad On 11/16/08, Sunita Paudel <[EMAIL PROTECTED]> wrote: > > *hi all i have been looki

$$Excel-Macros$$ Excel macro to iterate through rows collection - help please

I'm trying to create a macro that will do the following: When the user changes a value or values in column 'B', the macro will iterate through all cells in columns 'C' to 'AO' but only in the same row(s) that were changed in column 'B'. So basically, whatever row or rows got changed, those same

$$Excel-Macros$$ Re: Macro from C#

http://www.eggheadcafe.com/articles/create_macro_at_runtime_in_dotnet.asp http://www.eggheadcafe.com/software/aspnet/31040342/calling-excel-macro-from.aspx Try this Regards, Andy On Sun, Nov 16, 2008 at 12:44 AM, Shrish Jain <[EMAIL PROTECTED]> wrote: > > I read an Excel workbook from C# code a

$$Excel-Macros$$ Macro from C#

I read an Excel workbook from C# code and want to know whether there exist a macro in it or not. Can someone give me pointer how can I find it. THanks, Shrish --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com

$$Excel-Macros$$ Re: Single pivot for more than one sheets

Assuming that the Worksheets you want to combine are in the same workbook the attached macro CombineWorksheets will combine them into a single sheet named "Combined". Then proceed with your pivot on the combined sheet. Tom On Fri, Nov 14, 2008 at 4:37 AM, arun p <[EMAIL PROTECTED]> wrote: > Good

$$Excel-Macros$$ help needed regarding protecting excel files

*hi all i have been looking all mailz regarding excel that is help me to improve my skill on it since long time.. here i need small helpi have put all my excel works in one folder and i want to protect it puting password ( for folder ) can somone hlp me on this ?? thnx Suneeta * --~--