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
: Friday, August 24, 2012 7:15 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need Help Urgent !!!
Hi,
Please find the attached excel sheet in which their is a report Tab which
generates following report automatically
1)Current Stock
2)Current stock by Reference
but
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-
Hi,
In my sheet there are three tab 1)UPS tab 2)Router tab 3)SMPS tab
so there are date column as well is there
my question :when we open the excel file it should prompt me the message the
date is going to expire on which tab
for example :suppose in UPS tab for product no 1002&1003 date is 26 Apr s
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
please Provide Macro Code...
File is Attached...
--
Looking forward to receive your kind attention.
Thanks & Best Regards
M.Rashid.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tri
I need help with VBA
Am working on a vba project. Trying to automate something. Am gonna be using
a barcode reader and my employees have their iCards wit their employee id
printed in barcode.
Wat i need is ??
If someone comes to me with their id card i would not know if he is a
supervisor or jun
10 matches
Mail list logo
