The formula refers to 34 in B5 but B5 is 36, not 34
Regards
David Grugeon
On 15 May 2013 16:41, P.VIJAYKUMAR wrote:
> Respected Experts,
>
> My exact requirement is that if 12(or any constant number specific to
> login) is typed in Cell B4 of the attachment it should display the log-in
> time
It is possible using VBA. Please supply a sample workbook so we can
understand exactly how your data is organised and how you want to look it
up.
Regards
David Grugeon
On 15 May 2013 13:51, Prabhu Pinky wrote:
> Nope. it is not possible..
>
>
> On 15 May 2013 01:14, santosh subudhi wrote:
>
Dear Preeti Madam,
Got the same ans ..thanks a lot..
Regards,
Prafull Jadhav
On Wed, May 15, 2013 at 9:32 AM, Prafull Jadhav wrote:
> Dear Preeti Madam,
>
> it is very perfect formula ...Madam I go through the formula
> .. earlier also i asked you that what is result of "Row and Indirect"
> f
Thanks to send this formula which is very useful for me. Thanks once again
On Wed, May 15, 2013 at 9:32 AM, Prafull Jadhav wrote:
> Dear Preeti Madam,
>
> it is very perfect formula ...Madam I go through the formula
> .. earlier also i asked you that what is result of "Row and Indirect"
> form
Respected Experts,
My exact requirement is that if 12(or any constant number specific to
login) is typed in Cell B4 of the attachment it should display the log-in
time according to the formula or otherwise working.In the same way if 34
(or any constant number specific to log-out) is mentioned in
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com
On Wed, May 15, 2013 at 11:42 AM, Feramuz Alaçal wrote:
> Dear Admin please , make me unsubscribe. I am reciving hundres mail every
> day
>
> Have a good working
>
> --
>
Dear Admin please , make me unsubscribe. I am reciving hundres mail every day
Have a good working
--
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 of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
Your query is not clear. There are no log out times in the attachment.
Please elaborate.
On Wed, May 15, 2013 at 10:59 AM, P.VIJAYKUMAR wrote:
> Respected Experts,
>
> I Have an excel sheet which is used for getting the log-in and log-out
> times of employees.I have used if formulas as is seen
It should work for all sheets upon selection.
May be you have put it at a wrong place. See the attached example.
HTH
On Wed, May 15, 2013 at 10:55 AM, Prabhu Pinky wrote:
> hi experts..
>
> actually its not working...
>
> kindly help me on this...it clears only sheet 1 contents... if i select
>
hi vijayakumar,
tell me what is your exact requirement, so that we can modify the formula.
On 15 May 2013 10:59, P.VIJAYKUMAR wrote:
> Respected Experts,
>
> I Have an excel sheet which is used for getting the log-in and log-out
> times of employees.I have used if formulas as is seen in the
Respected Experts,
I Have an excel sheet which is used for getting the log-in and log-out
times of employees.I have used if formulas as is seen in the attachment.
But, when log-in time is updated unfortunately log-out time is also
changing even if the IF condition does not apply in the case. I don
hi experts..
actually its not working...
kindly help me on this...it clears only sheet 1 contents... if i select
sheet 2 or other sheets and if i run the macro its not clearing. its works
only on sheet 1.
On 15 May 2013 10:35, Prabhu Pinky wrote:
> hi experts,
>
> i got the answer for my late
oh yeah
its working.. thanks abhi... :D
regards
Prabhu R
On 15 May 2013 10:49, Abhishek Jain wrote:
> Whenever you add, delete, or rename a sheet - just save and close the
> file. When you will open the file again, it will be updated.
>
>
> On Wed, May 15, 2013 at 10:41 AM, Prabhu Pinky
Whenever you add, delete, or rename a sheet - just save and close the file.
When you will open the file again, it will be updated.
On Wed, May 15, 2013 at 10:41 AM, Prabhu Pinky wrote:
> Hi abhi,
>
> thanks for your quick help. it really works fine.
>
> i need one more modification in this querr
Hi abhi,
thanks for your quick help. it really works fine.
i need one more modification in this querry. is it possible if i delete any
sheet in this workbook and it should not show in that list..?
On 15 May 2013 10:36, Abhishek Jain wrote:
> You did not mention that in your earlier query.
>
You did not mention that in your earlier query.
However, attached is the solution to your new requirement.
Regards,
Abhi
On Wed, May 15, 2013 at 10:22 AM, Prabhu Pinky wrote:
> thanks abhi,
>
> but i need this to be listed in drop down menu.
>
>
> regards
> prabhu r
>
>
> On 15 May 2013 10:19,
hi experts,
i got the answer for my latest post.
below is the one i found myself :
Sub clearcontents()
ActiveSheet.Cells.clearcontents
End Sub
Regards,
Prabhu R
On 15 May 2013 10:25, Prabhu Pinky wrote:
> hi experts,
>
> what is the code to clear the contents including formats in active she
hi experts,
what is the code to clear the contents including formats in active sheet?
if im in sheet 1and if i run the macro it should clear only the sheet 1
data, if i go to sheet to and if i run the macro it should clear only the
sheet 2 data.
please help.
regards,
prabhu r
--
Are you =EXP
thanks abhi,
but i need this to be listed in drop down menu.
regards
prabhu r
On 15 May 2013 10:19, Abhishek Jain wrote:
> Here.
>
> This will create a list downwards from the selected cell.
>
> On the Home sheet, select A1 and click the button. If you change the name
> of sheets, or add / re
Here.
This will create a list downwards from the selected cell.
On the Home sheet, select A1 and click the button. If you change the name
of sheets, or add / remove sheets, click on the button again to update.
HTH
Regards,
On Wed, May 15, 2013 at 10:04 AM, Prabhu Pinky wrote:
> Hi experts,
>
Hi experts,
i need the below simple thing.
assume, you have five sheets in workbook. considere sheet 1 is home sheet.
i want to list the rest sheets in sheet 1 column A1.
like : if i click A1 in sheet 1, it should list the the other sheets from
Sheet 2 to Sheet 5. also if i add more sheets that
Dear Preeti Madam,
it is very perfect formula ...Madam I go through the formula
.. earlier also i asked you that what is result of "Row and Indirect"
formula ...
I am not able to understand ..
can you explan me the once again ...
=TRANSPOSE(TRIM(MID(SUBSTITUTE(A7,",",REPT(" ",LEN(A7))),*
(((R
Nope. it is not possible..
On 15 May 2013 01:14, santosh subudhi wrote:
> Hi Group,
>
> Is it possible in excel to lookup the comments along with the value.
> --
> Regards
> Santosh
> santoshkumar.subu...@gmail.com
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
wow.. really u have big sound in formula... ur formula is confusing to
understanding.. but u done it...really great.. :)
On 14 May 2013 18:45, priti verma wrote:
> If u want you do this with excel formula you can use this one.
> See the attachment
>
>
>
> On Mon, May 13, 2013 at 8:24 PM, jmoth
Yup..thaks for you all...but I have tried that too...it seems difficult to
learn..as I am a new learner.
Prabhu R
On May 14, 2013 11:09 PM, "Bé Trần Văn" wrote:
> - If you use Excel 2003: Open Excel, press Alt + F11 (open the Visual
> Basic Edition), click on Help and knocked me nu need to learn
Hi all,
I'm very much confused how to post and where to post my questions?...I need
a small help but its very urgent...
I need a macro for the below mentioned problem.
Say for example:
I have a column A and B in a sheet.
In column A say I have 1,2,3,4,5, and
in column B say I have A.b.
Hi all,
I'm very much confused how to post and where to post my questions?...I need
a small help but its very urgent...
I need a macro for the below mentioned problem.
Say for example:
I have a column A and B in a sheet.
In column A say I have 1,2,3,4,5, and
in column B say I have A.b.c.d.e agai
Hi Group,
Is it possible in excel to lookup the comments along with the value.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
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 of this forum @
https://www.facebook.
- If you use Excel 2003: Open Excel, press Alt + F11 (open the Visual Basic
Edition), click on Help and knocked me nu need to learn the content.
- Google, Search basic guidelines VBA
2013/5/15 xlstime
> try to record macro and readits a best way to learn macro
> or
> you can search
try to record macro and readits a best way to learn macro
or
you can search VBA related help in google
.
Enjoy
Team XLS
On Tue, May 14, 2013 at 9:08 PM, Prabhu Pinky wrote:
> Hi all,
>
> I am very new to VBA working in MNC as a WFM specialist. we are work
Hi all,
I am very new to VBA working in MNC as a WFM specialist. we are working
lots of reports on a monthly, weekly as well as daily basis.
i came acrossed many situation to create report, but i do it manually. i
wants to became a expert or atleast intermediate in creating VBA reports in
excel.
If you're intent is to copy the data into separate sheets, then I'd use the
following macro:
Option Explicit
Sub CopyData()
Dim nRows As Integer
Dim nCols As Integer
Dim R As Integer
Dim C As Integer
Dim Sht As String
Dim DataSht As String
DataSht = "Sheet1"
S
I take it that your "Column Labels" in row 2 are to be the sheet names?
Then you want to copy the data in each column to that sheet?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the ti
Hi guys, I've been struggling with this Macro, I want to copy each column,
And the way I did was to use macro in Report filter, but it's unsustainable.
Basically is a Pivot table and I want to extract each column to a different
sheet, the thing is the number of columns is always changing, it can 5
HI
you can use "text to column" under Data on ribbon
Regards,
Deepak
On Mon, May 13, 2013 at 8:43 PM, Paul Schreiner wrote:
> Are you wanting to do it with a macro? or simply within Excel?
>
> If you want to do it one time, with Excel,
> it's simply a matter of selecting the column, and use Dat
Hi Prafull,
I think you got the wrong message. I never said VBA is better. I just said
a task can be accomplished in many ways. My first message was a VBA
solution and second one was without VBA.
Besides, while generalizing a topic, I suggest you don't keep the group in
copy. I always have, and w
Dear Abhishk Sir ,
I have also me the same without VBA ...just for example.
I know VBA is better way .
On Tue, May 14, 2013 at 5:43 PM, Chaya wrote:
> Hi Priti,
>
> Thank you. your formula contains logic a lot, perfectly working. thanks
> once again.
>
>
> Regards,
> Chaya
>
> The excel l
Hi Priti,
Thank you. your formula contains logic a lot, perfectly working. thanks
once again.
Regards,
Chaya
The excel learner :-)
On Tue, May 14, 2013 at 5:34 PM, priti verma wrote:
> Hi Chaya ,
> PFA,
> without vba
> If it helps
>
>
> On Tue, May 14, 2013 at 4:11 PM, Chaya wrote:
>
>>
Hi Abhishek,
I understand and agree.
On Tue, May 14, 2013 at 5:45 PM, Abhishek Jain wrote:
> Another simplified way. Without having to transpose. Requires a bit of
> other work though.
>
> There is always more than one way to get a result. This is just for the
> sake of learning. Hope you don'
Another simplified way. Without having to transpose. Requires a bit of
other work though.
There is always more than one way to get a result. This is just for the
sake of learning. Hope you don't mind Priti.
Regards,
Abhishek
On Tue, May 14, 2013 at 5:34 PM, priti verma wrote:
> Hi Chaya ,
> P
DEAR DEEPAK
thnks for your help
I have the data off region in sheet 1
regions given colunm A
REGIONS
A. HYDERABAD
B. KURNOOL
C .GUWHATI
01. I want the date region wise
02. the date should slit indidividual sheets with region names given
under column "A"
03 Region wise date ( SHEET name shoul
Hi Chaya ,
PFA,
without vba
If it helps
On Tue, May 14, 2013 at 4:11 PM, Chaya wrote:
>
> Dear experts,
>
> I have set of data which need to be copy and paste in vertical way. I
> have more than thousand columns, So very taugh to copy and paste one by
> one.
>
> I have attached the f
HI,
PFA
Regards,
Deepak
On Tue, May 14, 2013 at 4:41 PM, GRKRISHNA NAIDU wrote:
> Dear expert will you please help me
>
> i have attached file
>
> *I have region code under column "A"
>
> i need the sheet to be split according to the regions names and all values
> under ROWS
>
> THNKS IN ADV
See attached.
If this is what you want, you can use subtotal.
Regards,
On Tue, May 14, 2013 at 4:41 PM, GRKRISHNA NAIDU wrote:
> Dear expert will you please help me
>
> i have attached file
>
> *I have region code under column "A"
>
> i need the sheet to be split according to the regions names
Thanks a lot Abhishek, its working great.
Thanks Amit and to all.
Regards,
Chaya
The excel learner :-)
On Tue, May 14, 2013 at 4:31 PM, Amit Desai (MERU)
wrote:
> Please share the main sheet.. I will convert it & send it...
>
> ** **
>
> Best Regards,
>
> Amit Desai
>
> +91 98
Dear expert will you please help me
i have attached file
*I have region code under column "A"
i need the sheet to be split according to the regions names and all values
under ROWS
THNKS IN ADVANCE
GRKRSIHNA
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(
Please share the main sheet.. I will convert it & send it...
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Chaya
Sent: 14 May 2013 16:24
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Paste Vertic
Understand transpose won't work for your query.
Try this.
Regards,
On Tue, May 14, 2013 at 4:24 PM, Chaya wrote:
> Thanks Amit,
>
>But i don't want to transpose the datas, please see the attachment.
>
>
>
> Regards,
> Chaya
>
> The excel learner :-)
>
>
> On Tue, May 14, 2013 at 4:19 PM,
Thanks Amit,
But i don't want to transpose the datas, please see the attachment.
Regards,
Chaya
The excel learner :-)
On Tue, May 14, 2013 at 4:19 PM, Amit Desai (MERU)
wrote:
> Do Copy & then do Alt E S V E.
>
> ** **
>
> Best Regards,
>
> Amit Desai
>
> +91 98672 32534***
Do Copy & then do Alt E S V E.
Best Regards,
Amit Desai
+91 98672 32534
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Chaya
Sent: 14 May 2013 16:12
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Paste Vertically
Dear experts,
I have
Dear experts,
I have set of data which need to be copy and paste in vertical way. I
have more than thousand columns, So very taugh to copy and paste one by
one.
I have attached the file, there is two sheets. One contains Data and
another the output.
As always thanks to all
Regards
---
You've been invited by Pavan Chowdary to use Google Talk.
If you already have a Google account, login to Gmail and accept this chat
invitation:
http://mail.google.com/mail/b-ac89e0d1a2-62a520961b-7Geo6weyonqxc4ecsF7LHzBJe7o
52 matches
Mail list logo