Yes, it is very good book..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 30, 2014 at 12:44 PM, wrote:
> @Joshi, I really love to know how to write macros myself. I got a new book
> for myself "Excel VBA programming for dummies 3rd ed." Hope th
Reason behind is,
I am Working on a multiple manual task in one report, like already
enquired, pulling data from Text file, changing data formats, based on this
data pull information from other source, clean up templates. etc
regards,
saravanan R
On Tue, Dec 30, 2014 at 12:33 PM, Mandeep Baluja
@Joshi, I really love to know how to write macros myself. I got a new book for
myself "Excel VBA programming for dummies 3rd ed." Hope that would help me?
Sent from my BlackBerry® wireless handheld from Glo Mobile.
-Original Message-
From: Vaibhav Joshi
Sender: excel-macros@googlegroups.
hmn.writing macro is very easy, however as long as solution exist using
available resources then same should be explored..
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 30, 2014 at 12:33 PM, Mandeep Baluja
wrote:
> Haha, Same question from my side to
>
> Haha, Same question from my side too Vabz but i was still trying to get
> it. Too much logical by calling it with udf because whenever you're writing
> a function the excel files during browsing cant be opened.
>
Trying this Macro to achieve the result.
Option Explicit
Public Sub Tes
check this
i m not getting any error..
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 30, 2014 at 10:29 AM, Ashish Bhalara
wrote:
> I was wrong, error occur of 'Sub of Function not defined.
>
> Regards.
> Ashish Bhalara
> 9624111822
> P*Please do not pri
why you need macro when you simply get it done using builtin excel dialogue
box..
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 30, 2014 at 10:34 AM, saravanan R wrote:
> i am looking for VBA Macro for this , reference file to opened by browse
> option t
i am looking for VBA Macro for this , reference file to opened by browse
option then select the range.
thanks & regards,
Saravanan
On Mon, Dec 29, 2014 at 6:45 PM, saravanan R wrote:
> Hi Team,
>
> Please help me on Vlookup function where I will need to refer the file(by
> browsing the path) an
I was wrong, error occur of 'Sub of Function not defined.
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*
On Tue, Dec 30, 2014 at 10:24 AM, Ashish Bhalara
wrote:
> Hi Vaibhavji,
>
> The Syntex error occ
Hi Vaibhavji,
The Syntex error occur in IF formula.
Regards.
Ashish Bhalara
9624111822
P*Please do not print this email unless it is absolutely necessary. Spread
environmental üawareness.♣♣♣*
On Mon, Dec 29, 2014 at 7:07 PM, Vaibhav Joshi wrote:
> Hi
>
> Try this:
>
> Private Sub Worksheet_Ch
Hi
Yes you can do so..Keep both the file open & goto cell where yo need to
insert formula and start vlookup dialogue box by pressing Shift + F3 ..
When dialogue box appears select vlookup from Lookup & reference category
and press enter..now select look value from col A, press tab & you will be
i
Hi
Your email is blank
+
*I did not do this for you. God is here working through me for you.*
On Mon, Dec 29, 2014 at 6:12 PM, wrote:
> Sent from my BlackBerry® wireless handheld from Glo Mobile.
> --
> *From: * Vaibhav Joshi
> *Sender: * excel-macros@googlegro
Hi
Try this:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range, c As Range
If Target.Cells.Count > 1 Or IsEmpty(Target) Then Exit Sub
If Not Intersect(Target, Range("A16:A50")) Is Nothing Then
Set rng = Range("A16:A150")
For Each c In rng
If c.Value = "" Then
c.Enti
Hi Team,
Please help me on Vlookup function where I will need to refer the file(by
browsing the path) and update the correponding data in the current file.
requirement as below:
col x=vlookup(col A current working file, rng, 2,0)
Col x & A refers to the current working file
but range I have to s
Cheers :D
+
*I did not do this for you. God is here working through me for you.*
On Mon, Dec 29, 2014 at 5:41 PM, aps wrote:
> data text to column works thanks !! :D
>
> On Mon, Dec 29, 2014 at 3:47 PM, Vaibhav Joshi wrote:
>
>> Hi Aps
>>
>> Check this...in case you want to keep date
Sent from my BlackBerry® wireless handheld from Glo Mobile.
-Original Message-
From: Vaibhav Joshi
Sender: excel-macros@googlegroups.com
Date: Mon, 29 Dec 2014 16:30:00
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Cc:
Subject: Re: $$Excel-Macros$$ How to in
>
> Hope you know what is UDF. PFA for the solution it can some for any no of
> colors in B column. just drag the formula in C according to your number of
> cells.
>
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELS
Dear all
I have a excel sheet in which cells are coloured on some basis (manually)
I want to do some calculation based on colour
Please find attached Sheet
--
Shrini
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page o
data text to column works thanks !! :D
On Mon, Dec 29, 2014 at 3:47 PM, Vaibhav Joshi wrote:
> Hi Aps
>
> Check this...in case you want to keep date in dd.mm. format..
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Mon, Dec 29, 2014
Dear experts,
Kindly see below code to hide row if cell value is blank. I need looping in
this code to apply this code from row 16 to 50. Thanks in advance.
Private Sub Worksheet_Change(ByVal Target As Range) If
Range("A16").Value = "" Then Rows("16:16").EntireRow.Hidden =
True
Els
Hey Victor,
Check this...
There is 2 separate macro for inserting row & deleting row...
While inserting row first you need to enter how many rows to be inserted &
then select cell after which rows to be inserted..
For deleting row you will be prompted for selecting cell for which you need
to de
ok, send a format in which you need output with sample data having 2-3
distinct code...
+
*I did not do this for you. God is here working through me for you.*
On Mon, Dec 29, 2014 at 8:13 AM, C.G.Kumar
wrote:
>
> Dear Vaibhav,
>
> I would try to explain how we do it manually so that it is
>
Hi
VBA considering it as mdy format..
Use format function to switch format..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Mon, Dec 29, 2014 at 3:01 PM, saravanan R wrote:
> Hi Team,
>
> I have an query on replace "." with "/" in the Data pulled from
Hi Aps
Check this...in case you want to keep date in dd.mm. format..
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Mon, Dec 29, 2014 at 2:16 PM, aps wrote:
> Hi,
>
> I had tried the same formula as you but it have a #VALUE! error. I have
> tried to
Hi
select column and use data text to column...
+
*I did not do this for you. God is here working through me for you.*
On Mon, Dec 29, 2014 at 2:30 PM, aps wrote:
> When i checked the Evaluation steps i found out that excel is treating
> this date as a constant. How to convert it to a da
Hi Team,
I have an query on replace "." with "/" in the Data pulled from SAP .
Actually Format is,
01.12.2014 17.12.2014 WHen I Do Manually Find & Replace,
It show me as ,
1/Dec/14
17/Dec/14.
But when I do through VBA COde,
I replace as,
12/Jan/14
"INVALID DATE FORMAT)
Can You please check in
Hi Mandeep,
Thanks For your quick response, This is what actually i needed.
Thanks a Lot
Regrads,
Saravanan
On Mon, Dec 29, 2014 at 11:35 AM, Mandeep Baluja
wrote:
> Sub Macro1()
>>
>> Dim fName As String
>>
>> fName = Application.GetOpenFilename("Text Files (*.txt), *.txt")
>> If fName = "F
Reply already given check my file which i sent to you.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Tuesday, December 23, 2014 4:46:44 PM UTC+5:30, Aparna wrote:
>
> hi,
>
> i have a column of arou
chk dis file.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Tuesday, December 23, 2014 4:46:44 PM UTC+5:30, Aparna wrote:
>
> hi,
>
> i have a column of around 150 different dates. i need to create a
When i checked the Evaluation steps i found out that excel is treating this
date as a constant. How to convert it to a date. Format cells as date is
not working
On Mon, Dec 29, 2014 at 2:16 PM, aps wrote:
> Hi,
>
> I had tried the same formula as you but it have a #VALUE! error. I have
> tried t
Hi,
I had tried the same formula as you but it have a #VALUE! error. I have
tried to format the cells as date but no effect takes place when i do that.
Please see. ive added the column in the workbook u shared.
On Tue, Dec 23, 2014 at 6:18 PM, Ashish Kumar
wrote:
> Superb Solution Vaibhav Bhai.
31 matches
Mail list logo