$$Excel-Macros$$ Excel VBA not copying chart every time when using ActiveSheet.Copy

I have a workbook that has numerous pivot tables and charts. I use the "page" in the pivot table to cycle through all the items in the data to make reports. On each cycle through the pivot data I create a copy using ActiveSheet.Copy to do some cleanup before making a webpage. My problem is that

$$Excel-Macros$$ Paste directly values of a matrix' column or row without any loop

Hi everyones, I would like to know if there is a way to paste directly values of a matrix column or row without any loop. I would like to have my program running faster and I have to compute values of a VBA matrix column in an excel column but I don't know how to do without a FOR loop and it is ve

$$Excel-Macros$$ hi

Dear All, Pls. give me some example files for an Market Forecasting, Conjoint analysis & test of significance files.To Fullfill my M.B.A i want to submit my project with fullfill of all these analysis. Topic is Indian FMCG companies. Regards Sheeba --~--~-~--~~~---~--

$$Excel-Macros$$ Re: $$Excel-Macros$$

Type this formulae in C4 =right(b4,6) and then drag down Baloo On Sun, Oct 19, 2008 at 7:15 PM, Mattathil M. Pradeep <[EMAIL PROTECTED]>wrote: > Dears.. > > > > How to copy particular data from one cell ? attached excel sheet for your > reference. > > > > Thanks in advance > > PRADEEP > > > >

$$Excel-Macros$$ Re:

Hi, you can use the formula =right(A2,6) where a2 is the cell number where your data resides and 6 is the number of characters you want from the right hand side of the text On Oct 19, 6:45 pm, "Mattathil M. Pradeep" <[EMAIL PROTECTED]> wrote: > Dears.. > > How to copy particular data from one c

$$Excel-Macros$$ Re: $$Excel-Macros$$

Dear Pradeep You may use the function, =RIGHT(B4,6). I am enclosing the spreadsheet file sent by you. Wish you all the Best. N.Shivkumar Office : +914027685423 Mobile : +919866533180 Res : +914040035774 Alternate Email : [EMAIL PROTECTED] --~--~-~--~~~---~--~-

$$Excel-Macros$$ RE: $$Excel-Macros$$

Dear Mr. Shivkumar Thank you very much Thanks and Regards M. M. Pradeep From: N.Shivkumar [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2008 2:35 PM To: excel-macros@googlegroups.com; Mattathil M. Pradeep Subject: Re: $$Excel-Macros$$

$$Excel-Macros$$ Re: $$Excel-Macros$$

just double click to the particular data and select as needed and ctrl+C as same go the desrable area where they want to paste same process d. click and paste. On 10/19/08, Mattathil M. Pradeep <[EMAIL PROTECTED]> wrote: > > Dears.. > > > > How to copy particular data from one cell ? attached

$$Excel-Macros$$ Re: $$Excel-Macros$$

Solution in the attached file. On Sun, Oct 19, 2008 at 7:15 PM, Mattathil M. Pradeep <[EMAIL PROTECTED]>wrote: > Dears.. > > > > How to copy particular data from one cell ? attached excel sheet for your > reference. > > > > Thanks in advance > > PRADEEP > > > > > > > --~--~

$$Excel-Macros$$ Re: $$Excel-Macros$$

You can use i think it will be helpful. use the following formula =RIGHT(B4,6) but make sure your copy text or number not over then 6. Regards Mudassar Ramzan - Original Message - From: Mattathil M. Pradeep To: excel-macros@googlegroups.com Sent: Sunday, October 19, 2008 6:45

$$Excel-Macros$$ Re: $$Excel-Macros$$

Hi, You can try the "RIGHT" Formula, where; it will give you the last 6 digit from the particular cell. =RIGHT(B4,6) Best of luck... Regards, Sanjaykumar On Sun, Oct 19, 2008 at 7:15 PM, Mattathil M. Pradeep <[EMAIL PROTECTED]>wrote: > Dears.. > > > > How to copy particular data from one

$$Excel-Macros$$ Re: $$Excel-Macros$$

PRADEEP If it is the last 6 characters you need, place the following formula in cell C4. =RIGHT(B4,6) Then copy the formula down as far as you want. Norman On Sun, Oct 19, 2008 at 9:45 AM, Mattathil M. Pradeep <[EMAIL PROTECTED]>wrote: > Dears.. > > > > How to copy particular data from one c

$$Excel-Macros$$ Re: $$Excel-Macros$$

Pradeep, You can use the "mid" function example: PRADEEP-KUMAR-VINOD-154-AB to extract 154-AB use as follows: =mid(cellnumber,startingnumber, number of characters) =mid(cellnumber,21,6) if you have the above value in cell A1 then =mid(A1,21,6) Thanks, Skanda. On Sun, Oct 19, 2008 at 9:4

$$Excel-Macros$$ Re: Request for Formula

Hi, For understanding purpose, lets assume we have B2 instead of B2:B13, fine. The Text function formats the value (first parameter) according to the format (the second parameter). So actually the first time we use text() function, it actually tests if the cell (B2) has the value that matches the f

$$Excel-Macros$$ Re: $$Excel-Macros$$

Hi Pradeep, See the updated attached file for your reference. Regards, Aindril On Sun, Oct 19, 2008 at 8:45 PM, Mattathil M. Pradeep <[EMAIL PROTECTED]>wrote: > Dears.. > > > > How to copy particular data from one cell ? attached excel sheet for your > reference. > > > > Thanks in advance > >

$$Excel-Macros$$ Re: $$Excel-Macros$$

Hai Pradeep, select the area then Data -> Text to columns -> Deliminated -> other option put "-" then u can get data in individual cells if you want to add use concatenate () to add columns, which all are required data for you. regards siva On Sun, Oct 19, 2008 at 4:45 PM, Mattathil M. Prade