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 kumar.ashish...@gmail.com
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 date. Format cells as date is
not working
On Mon, Dec 29, 2014 at 2:16 PM, aps eragon007.apa...@gmail.com wrote:
Hi,
I had tried the same formula as you but it have a #VALUE!
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
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 around
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 rockerna...@gmail.com
wrote:
Sub Macro1()
Dim fName As String
fName = Application.GetOpenFilename(Text Files (*.txt), *.txt)
If
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 and
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 eragon007.apa...@gmail.com wrote:
When i checked the Evaluation steps i found out that excel is treating
this date as a constant.
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 eragon007.apa...@gmail.com wrote:
Hi,
I had tried the same formula as you but it have a #VALUE!
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 sarva0...@gmail.com wrote:
Hi Team,
I have an query on replace . with / in the Data
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 kumar.bemlmum...@gmail.com
wrote:
Dear Vaibhav,
I would try to explain how we do it
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
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
ElseIf
data text to column works thanks !! :D
On Mon, Dec 29, 2014 at 3:47 PM, Vaibhav Joshi v...@vabs.in 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,
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
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
Sent from my BlackBerry® wireless handheld from Glo Mobile.
-Original Message-
From: Vaibhav Joshi v...@vabs.in
Sender: excel-macros@googlegroups.com
Date: Mon, 29 Dec 2014 16:30:00
To: excel-macros@googlegroups.comexcel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
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 eragon007.apa...@gmail.com wrote:
data text to column works thanks !! :D
On Mon, Dec 29, 2014 at 3:47 PM, Vaibhav Joshi v...@vabs.in wrote:
Hi Aps
Check
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
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
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, meetg...@gmail.com wrote:
Sent from my BlackBerry® wireless handheld from Glo Mobile.
--
*From: * Vaibhav Joshi v...@vabs.in
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
in
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 v...@vabs.in wrote:
Hi
Try this:
Private Sub
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 ashishbhalar...@gmail.com
wrote:
Hi Vaibhavji,
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 sarva0...@gmail.com wrote:
Hi Team,
Please help me on Vlookup function where I will need to refer the file(by
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 sarva0...@gmail.com wrote:
i am looking for VBA Macro for this , reference file to opened
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 ashishbhalar...@gmail.com
wrote:
I was wrong, error occur of 'Sub of Function not defined.
Regards.
Ashish Bhalara
9624111822
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
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 rockerna...@gmail.com
wrote:
Haha, Same
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 v...@vabs.in
Sender:
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, meetg...@gmail.com wrote:
@Joshi, I really love to know how to write macros myself. I got a new book
for myself Excel VBA programming for dummies
31 matches
Mail list logo