Basically i need a macro that does the following:
i have a sheet in excel with items ( about 2815 items) each item has a 6
digit code.
The sheet looks like this
Row 1 : code
Row 2: numeric info 1 digit
Row 3: description for item
Row 4: description for item
Row 5: Price
Now what i need is this:
Dear expert,
I have a macro
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
'Private Sub Workbook_beforclose()
'Sub sendmail()
'(mailid As String, nm As String, flname As String)
Dim OutApp As Object
Dim OutMail As Object
Set OutApp = CreateObject("Outlook.Appli
Hi Vaibhav,
Its Great buddy.
Regards
Ashish
On 19 July 2014 22:02, Vaibhav Joshi wrote:
> Check this..
>
> Cheers!!
>
>
> On Sat, Jul 19, 2014 at 2:32 PM, Vijay wrote:
>
>> Dear Team,
>>
>>
>> Please Help on this to Solve this Problem !!!
>>
>>
>> Regards,
>>
>> Vijayakumar R
>>
>> On Monda
Dear expert,
I have a macro
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
'Private Sub Workbook_beforclose()
'Sub sendmail()
'(mailid As String, nm As String, flname As String)
Dim OutApp As Object
Dim OutMail As Object
Set OutApp = CreateObject("Outlook.Appl
Dear expert,
I have a macro
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
'Private Sub Workbook_beforclose()
'Sub sendmail()
'(mailid As String, nm As String, flname As String)
Dim OutApp As Object
Dim OutMail As Object
Set OutApp = CreateObject("Outlook.Appl
Thanks
On Sun, Jul 20, 2014 at 10:06 AM, Vaibhav Joshi wrote:
> Just copy the cell in which you have applied conditional formatting, after
> that select cells where you need to apply same formatting, then Paste
> special formatting to it by right clicking on selected cells.
>
> Check this attac
Just copy the cell in which you have applied conditional formatting, after
that select cells where you need to apply same formatting, then Paste
special formatting to it by right clicking on selected cells.
Check this attachment.
Cheers!!
On Sun, Jul 20, 2014 at 2:51 AM, Ahmed Emam wrote:
> I
