find the file it is done
On Wed, Mar 9, 2011 at 4:04 PM, Rajiv Kumar wrote:
>
>
> --
> *Thanks & Regards
>
> *
> *Rajiv Kumar
> *
> *Mawana Sugar Works, Mawana
> *
> *Mo.No: 09027414899*
>
>
> --
>
> --
> Some import
Hi
this link will help u
http://office.microsoft.com/en-us/excel-help/how-to-look-up-a-value-in-a-list-and-return-multiple-corresponding-values-HA001226038.aspx
On Wed, Mar 9, 2011 at 4:07 PM, Rajiv Kumar wrote:
>
> Dear Sir.
>
>
> Please Experts I have duplicates data from one column so how
hi,
The default setting for each cell is for them to start locked. So, you first
need to highlight ALL cells in the sheet, right click, choose format, go to
the Protection tab and take the tick out of the Locked box.
Now no cells are locked.
Now you need to select the one cell you want locking.
Hi Roop,
Follow the below steps to protect the cells :-
1) Select the cells that need protection.
2) Right click > Format Cells.
3) Go to Protection Tab
4) Select LOCKED CheckBox. (Locked check box restricts editing of cell)
5) Click OK
6) Go to Review tab (in Excel 2007)
7) Click on "Protec
Thanks a lot, it works fine...
On 3 juin, 15:17, Paul Schreiner wrote:
> This should give you something to start with:
>
> Option Explicit
> Sub OpenFiles()
> Dim fso, fl, fc, f
> Dim PathFldr
> Dim msg
> Set fso = CreateObject("Scripting.FileSystemObject")
> PathFldr = "C:\temp"
> msg = "Selecte
This should give you something to start with:
Option Explicit
Sub OpenFiles()
Dim fso, fl, fc, f
Dim PathFldr
Dim msg
Set fso = CreateObject("Scripting.FileSystemObject")
PathFldr = "C:\temp"
msg = "Selected:"
If (fso.folderexists(PathFldr)) Then
If (Right(PathFldr, 1) <> "\") Then PathFldr = Path
use ;
Today()-1
On Sat, May 29, 2010 at 9:58 PM, Deepak Pal Singh wrote:
> You can use =Today()-1
>
>
>
>
> On Fri, May 28, 2010 at 10:07 PM, Surendra saxena wrote:
>
>> Hi All,
>>
>> need you help to fix the formula in excel like below-
>>
>> (-Today+End.date)
>>
>> i want to fix t
You can use =Today()-1
On Fri, May 28, 2010 at 10:07 PM, Surendra saxena wrote:
> Hi All,
>
> need you help to fix the formula in excel like below-
>
> (-Today+End.date)
>
> i want to fix the formula in excel which reflect always previous day value
> instead on today.
> --
> Your's
> Surendra
