thanks
On Sat, Sep 21, 2013 at 6:24 PM, ashish koul wrote:
> hv u tried vlookup
>
> =VLOOKUP(C6,Sheet1!C:E,3,0)
>
>
>
> On Sat, Sep 21, 2013 at 6:22 PM, TIWARI wrote:
>
>> dear expert,
>> I am attaching a file data of invoice value of abc ltd to copy of another
>> sheet in blank invoice coloum
hv u tried vlookup
=VLOOKUP(C6,Sheet1!C:E,3,0)
On Sat, Sep 21, 2013 at 6:22 PM, TIWARI wrote:
> dear expert,
> I am attaching a file data of invoice value of abc ltd to copy of another
> sheet in blank invoice coloum . Pls help me urgently.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Ex
Better you should have created it in Ms-Access.
<><><><><><>
*Ms.Exl.Learner*
<><><><><><>
On Fri, Aug 24, 2012 at 5:45 PM, jocky Beta wrote:
>
> Hi,
>
> Please find the attached excel sheet in which their is a report Tab
> which generates following report automatically
>
> 1)Current Stock
> 2
Why is YOUR request more URGENT than the request of anyone else?
And, it appears that instead of asking a question to help yourself you are
asking for a project to be done for free. Really!
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: jocky Beta
Sent: Frid
Try ths code
Private Sub Workbook_Open()
Dim i, j, k As Long
Dim SWA1, SWA2, SWA3 As String
SWA1 = ""
SWA2 = ""
SWA3 = ""
Sheets("UPS").Activate
For j = 2 To Sheets("UPS").Range("a1").End(xlDown).Row
If Sheets("UPS").Cells(j, 2).Value <= DateSerial(Year(Now), Month(Now),
Day(Now)) Then
SWA1 = SW
Hi Ashish,
Thanks for replying but it is showing for only 28-April-2011 see what i want
to display the meassage which date has been expired eg.today date is 27
april ,so the message display for less than the today date or system date
for example
Product Date
1001 3-May-2011
1002 26-
use this code in sheet 1
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
If Target.Column = 1 And Target.Row = 3 Then
Sheets(2).Activate
Sheets(2).Cells(2, 1).Select
End If
End Sub
On Mon, Feb 14, 2011 at 12:48 PM, rashid memon wrote:
> please Provide Macro Co
