$$Excel-Macros$$ Fwd: Merge files with few criteria of pasting

2014-09-29 Thread Vinod Narayanan
Hi Gurus, Need your help!. I need to consolidate many files received from various branches from time to time basis. Attached is the sample file wherein I have added 2 worksheets. One is the input file received from Branches and another the Output file. *Input file:* As there files are save

$$Excel-Macros$$ Teach Formula Series

2012-09-10 Thread Vinod Narayanan
Hi All, Request the group to start a thread which teaches excel formulas.. - Explain the formula - Difference ( if any) in 2003, 2007 & 2010 versions - Examples Your thoughts please Thanks and Regards Vinod -- Join official facebook page of this forum @ https://www.facebook.com/discusse

Re: $$Excel-Macros$$ re: conversion of numbers

2011-11-27 Thread Vinod Narayanan
Hi Harsh, Select the cells which requires the formatting to be done and in Format Cells --> Custom, Please type *#,* to convert numbers in thousands and so on Option 1 = If base data is 10 - type *#,* in Format Cells --> Custom.. The result will be 100 Option 2 = If base data is 100

Re: $$Excel-Macros$$ Freeze/Unalterable Cells

2011-05-17 Thread Vinod Narayanan
Value) Then > Target.Locked = True > End If > ActiveSheet.Protect Password:="ashish" > Else: End If > > End Sub > > > > On Mon, May 16, 2011 at 1:04 AM, Vinod Narayanan wrote: > >> Hi Team, >> >> Request you to help me creating an assessment

$$Excel-Macros$$ Freeze/Unalterable Cells

2011-05-15 Thread Vinod Narayanan
upon the question) Sample sheet is attached... the movement the option is chosen by the person, the cell c3 should freeze and make it unalterable -- Thanks and Regards Vinod Narayanan -- -- Some important links for