Re: $$Excel-Macros$$ Urgent help plss..

2013-05-27 Thread Murugesh Pandi
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

Re: $$Excel-Macros$$ Urgent help plss..

2013-05-27 Thread Prabhu Pinky
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

Re: $$Excel-Macros$$ Urgent help plss..

2013-05-27 Thread अनिल नारायण गवली
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

Re: $$Excel-Macros$$ Urgent help plss..

2013-05-27 Thread VBA VABZ
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

$$Excel-Macros$$ Urgent help plss..

2013-05-27 Thread Prabhu Pinky
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

Re: $$Excel-Macros$$ IF / Nested IF Formula Help **URGENT**.

2013-05-27 Thread priti verma
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

Re: $$Excel-Macros$$ IF / Nested IF Formula Help **URGENT**.

2013-05-27 Thread Prafull Jadhav
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,

Re: $$Excel-Macros$$ IF / Nested IF Formula Help **URGENT**.

2013-05-27 Thread David Grugeon
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

Fwd: Re: $$Excel-Macros$$ Vba code for pivot table drill down and renaming sheet

2013-05-27 Thread KAUSHIK SAVLA
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

Re: $$Excel-Macros$$ Vba code for pivot table drill down and renaming sheet

2013-05-27 Thread KAUSHIK SAVLA
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

Re: $$Excel-Macros$$ Vba code for pivot table drill down and renaming sheet

2013-05-27 Thread Bé Trần Văn
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

Re: $$Excel-Macros$$ Macro Help

2013-05-27 Thread Bé Trần Văn
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

$$Excel-Macros$$ Vba code for pivot table drill down and renaming sheet

2013-05-27 Thread 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 Amount which is located in column K and F respectively. After pivot table is created with above

$$Excel-Macros$$ DATE FORMAT QUERY........

2013-05-27 Thread Kuldeep Singh
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

Re: $$Excel-Macros$$ How to split cell in Excel

2013-05-27 Thread David Grugeon
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

Re: $$Excel-Macros$$ Macro Help

2013-05-27 Thread David Grugeon
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. >> >>

$$Excel-Macros$$ Macro to send Multiple file via Email

2013-05-27 Thread Atul Kesaria
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

Re: $$Excel-Macros$$ How to split cell in Excel

2013-05-27 Thread priti verma
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

Re: $$Excel-Macros$$ writing of excel macro

2013-05-27 Thread Satendra kumar
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

Re: $$Excel-Macros$$ writing of excel macro

2013-05-27 Thread Anoop K Sharma
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 > > -- >

$$Excel-Macros$$

2013-05-27 Thread safinx2008
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

$$Excel-Macros$$ writing of excel macro

2013-05-27 Thread Rajesh Agarwal
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

$$Excel-Macros$$ How to split cell in Excel

2013-05-27 Thread Prathap
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