http://social.technet.microsoft.com/Forums/en-US/officeitpro/thread/cfbcd96c-bcf1-48dc-940e-5d859f44e217
On Tue, May 28, 2013 at 11:26 AM, Prabhu Pinky wrote:
> Hi..
> Am unable to attach the sheet, since there is violation in our office.
>
> As I said earlier, I have selected only one cell. So
Hi..
Am unable to attach the sheet, since there is violation in our office.
As I said earlier, I have selected only one cell. So there is no matter if
I use filter.
Prabhu R
On May 28, 2013 10:42 AM, "VBA VABZ" wrote:
> Hi
>
> Either source sheet has filter or merged cells. Try clearing out f
Dear Prabhu,
Are u pressing cltr+then selecting the cells and trying to copy the
things.?
if u selecting the cells vertically or horizontally but in straight line
then it should copy by selecting cltr key.
But if u selecting the cells randomly then it will not copy and throws the
message whic
Hi
Either source sheet has filter or merged cells. Try clearing out filter
and perform operation again.
If doesn't work send us sheet.
HTH
On 28 May 2013 10:07, "Prabhu Pinky" wrote:
> hi experts
>
> I have one excel, from that excel I am unable to copy and paste the data
> to new excel..even
hi experts
I have one excel, from that excel I am unable to copy and paste the data to
new excel..even a single cell..am getting "this command is cannot be
processd in multiple selection" error message..
But am sure I selected and copied only single, but donno how am getting
thus errorpls hel
Hi Yogesh ,
You can use this formula,
=IF((INT(MID(U3,1,FIND("-",U3,1)-1)/7)+1)>10,"Week
10","Week"&INT(MID(U3,1,FIND("-",U3,1)-1)/7)+1)
On Tue, May 28, 2013 at 9:51 AM, Prafull Jadhav wrote:
> Dear Yogesh,
>
> use below formula
>
> =WEEKNUM()
>
>
> On Tue, May 28, 2013 at 8:27 AM, David Grugeon
Dear Yogesh,
use below formula
=WEEKNUM()
On Tue, May 28, 2013 at 8:27 AM, David Grugeon wrote:
> I think you would do better to use a pivot table. Dates can be based on
> weeksfor the summarisation.
>
> Regards
> David Grugeon
>
>
>
> On 28 May 2013 12:17, Yogesh Vyas wrote:
>
>> Hi Team,
I think you would do better to use a pivot table. Dates can be based on
weeksfor the summarisation.
Regards
David Grugeon
On 28 May 2013 12:17, Yogesh Vyas wrote:
> Hi Team,
>
> I need IF/Nested IF Formula for Supplier Aging Analysis. Please find
> attach data for the same.
>
> Eg.
>
> Data
Hi team,
Awaiting for response in below query.
Appreciate your help in looking into it.
Regards,
Kaushik
-- Forwarded message --
From: "KAUSHIK SAVLA"
Date: May 27, 2013 8:42 PM
Subject: Re: $$Excel-Macros$$ Vba code for pivot table drill down and
renaming sheet
To:
Hi,
Pleas
Hi,
Please find attached sample file.
Instructions:-
1. I want to create Pivot Table based on data in Sheet 1 (range A3 to
L1048576
In Row Label : Account
In Values : Sum of Amount
2. I want to have drill down of every account one by one in different sheet
and to rename the sheet with account a
Please attach File, I know how to handle new look.
2013/5/27 KAUSHIK SAVLA
> Hi All,
>
> Need your help in pivot table drill down.
>
> I am having huge excel database around 15 rows having whole data of
> different accounts.
> I want to create a pivot on it on basis of Account No. and Amou
Cell D3:D9 and :D24 to enter data.
Input data in is complete, Click Button "Enter data into the sheet Format",
See Attachment.
2013/5/27 David Grugeon
> Bulloo Shire Council in Thargomindah Queensland Australia.
>
> Regards
> David Grugeon
>
>
>
> On 27 May 2013 16:13, VBA VABZ wrote:
>
>> he
Hi All,
Need your help in pivot table drill down.
I am having huge excel database around 15 rows having whole data of
different accounts.
I want to create a pivot on it on basis of Account No. and Amount which is
located in column K and F respectively.
After pivot table is created with above
Hi All,
I want to change date format in MS Access. Please help me.
Date format : mm-dd- & I want to dd-mm-
Regards,
Kuldeep Singh
Assistant Manager Quality
Game Zone India Limited
Phone.: +91-9716615535
|| naukrikuld...@gmail.com ||
*Please* *Consider the environment. Please don't print
How about doing it in two adjacent cells. I doubt if it will be possible,
or certainly not easy in one cell.
When you say vertically aligned do you mean that the letters will be
rotated 90 degrees to the right, or do you want the letters the normal way
round, but one over the other?
The last mig
Bulloo Shire Council in Thargomindah Queensland Australia.
Regards
David Grugeon
On 27 May 2013 16:13, VBA VABZ wrote:
> hey
>
> for which co you work.
>
> thx
>
>
> On Mon, May 27, 2013 at 7:20 AM, Bv Dileep wrote:
>
>> Hello,
>>
>> ** **
>>
>> Please find attached the sheet.
>>
>>
Hello Team,
I need a macro which can send multiple file to individual person.
For eg. If 1 folder has files basis name of person for year 1 &
2 folder has files basis name of peron for Year 2
then macro should send both this files.
Please help.
Thanks and Regards
Atul Kesaria
Can you please share example file so that we can understand problem.
On Mon, May 27, 2013 at 12:29 PM, Prathap wrote:
> Hi Experts,
>
> How do we split a cell in excel in to two where one part of text is
> vertical aligned and other is being horizontal aligned.
>
> Pls help
> Best Regards,
> PR
Hi Rajesh,
find below detail for learn VBA, Macro, Advance Excel.
MR. Ansari Ji.
# +91 9911176564
thanks
satendra
On Mon, May 27, 2013 at 12:42 PM, Rajesh Agarwal wrote:
> Hello everyone
> I am from Delhi NCR area and want to learn macro excel. Is there any body
> in the region who can giv
Approach Noorain Ansari
On Mon, May 27, 2013 at 12:42 PM, Rajesh Agarwal wrote:
> Hello everyone
> I am from Delhi NCR area and want to learn macro excel. Is there any body
> in the region who can give me a hour or two hours time to understand it
> properly.
> Thanks in advance.
> Rgds
>
> --
>
safinx2008
--
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
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgen
Hello everyone
I am from Delhi NCR area and want to learn macro excel. Is there any body
in the region who can give me a hour or two hours time to understand it
properly.
Thanks in advance.
Rgds
--
*Rajesh Kumar Agarwal*
*9811063001*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Hi Experts,
How do we split a cell in excel in to two where one part of text is
vertical aligned and other is being horizontal aligned.
Pls help
Best Regards,
PRATHAP D
M +91 9899-370-328
--
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 of
23 matches
Mail list logo