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
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
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
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
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