---
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
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
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
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)
amit.de...@merucabs.comwrote:
Do Copy then do Alt E S V E.
** **
Best Regards,
Amit Desai
+91
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
Understand transpose won't work for your query.
Try this.
Regards,
On Tue, May 14, 2013 at 4:24 PM, Chaya chayamon...@gmail.com 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
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
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)
amit.de...@merucabs.comwrote:
Please share the main sheet.. I will convert it send it...
** **
Best Regards,
Amit
See attached.
If this is what you want, you can use subtotal.
Regards,
On Tue, May 14, 2013 at 4:41 PM, GRKRISHNA NAIDU grnaidu1...@gmail.comwrote:
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
HI,
PFA
Regards,
Deepak
On Tue, May 14, 2013 at 4:41 PM, GRKRISHNA NAIDU grnaidu1...@gmail.comwrote:
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
Hi Chaya ,
PFA,
without vba
If it helps
On Tue, May 14, 2013 at 4:11 PM, Chaya chayamon...@gmail.com 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
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 should
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
Hi Abhishek,
I understand and agree.
On Tue, May 14, 2013 at 5:45 PM, Abhishek Jain abhishek@gmail.comwrote:
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
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 pritiverma1...@gmail.comwrote:
Hi Chaya ,
PFA,
without vba
If it helps
On Tue, May 14, 2013 at 4:11 PM,
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 chayamon...@gmail.com wrote:
Hi Priti,
Thank you. your formula contains logic a lot, perfectly working. thanks
once again.
Regards,
Chaya
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
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
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
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
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 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 xlst...@gmail.com
try to record macro and readits a best way to learn macro
or
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 @
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
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
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 betnmtdongna...@gmail.com wrote:
- If you use Excel 2003: Open Excel, press Alt + F11 (open the Visual
Basic Edition), click on Help and
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 pritiverma1...@gmail.com wrote:
If u want you do this with excel formula you can use this one.
See the attachment
On Mon, May 13,
Nope. it is not possible..
On 15 May 2013 01:14, santosh subudhi santoshkumar.subu...@gmail.comwrote:
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
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))),*
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
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
thanks abhi,
but i need this to be listed in drop down menu.
regards
prabhu r
On 15 May 2013 10:19, Abhishek Jain abhishek@gmail.com 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
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
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 prabhupin...@gmail.com wrote:
hi experts,
what is the code to clear the contents including
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 prabhupin...@gmail.comwrote:
thanks abhi,
but i need this to be listed in drop down menu.
regards
prabhu r
On 15
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 abhishek@gmail.com wrote:
You did not mention that in
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 prabhupin...@gmail.comwrote:
Hi abhi,
thanks for your quick help. it really works fine.
i need one more
oh yeah
its working.. thanks abhi... :D
regards
Prabhu R
On 15 May 2013 10:49, Abhishek Jain abhishek@gmail.com 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
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 prabhupin...@gmail.com wrote:
hi experts,
i got
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
hi vijayakumar,
tell me what is your exact requirement, so that we can modify the formula.
On 15 May 2013 10:59, P.VIJAYKUMAR vijay.4...@gmail.com 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
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 prabhupin...@gmail.comwrote:
hi experts..
actually its not working...
kindly help me on this...it clears only sheet 1
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 vijay.4...@gmail.com 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
43 matches
Mail list logo