$$Excel-Macros$$ Re: $$EXCEL-MACROS$$HOW TO AUTOFILL FOR A GIVEN SUM IN MAGIC SQUARE

Can you post an example? Not sure how a magic square works. Sam Mathai Chacko On Jul 2, 9:17 pm, karunanithi ramaswamy wrote: > HI, >   I AM INTERESTED TO KNOW HOW TO AUTO FILL A 4X4 MAGIC SQUARE FOR ANY > SUM WITH NO NUMBER REPEATS FROM A SERIES OF NUMBERS. >   THANKS IN ADVANCE > -R.KARUNANITH

$$Excel-Macros$$ Re: Excel Macros for updating current records.

I have the file stored on Google Docs at: https://docs.google.com/leaf?id=0B2wwdgJj4ncpYzQ0MTFiNzQtNDAxMi00NGNmLWIzMjMtYmM0NjQyNTY3Y2Nm&hl=en&authkey=CLjt6zY On Feb 23, 4:01 pm, Ken Hansen wrote: > Hi all, > > I have a Sales Tracking workbook. I have 2 issues that I can't seem to > resolve. > > 1

$$Excel-Macros$$ Re: Excel Macros

Hi Aswin, This is very wonderful. There are so many websites available to give you a start. Buy some good Microsoft Press books: http://www.excelitems.com/2009/03/free-e-book-on-vba-and-vsto-macros-and.html Try and if have some issue, discuss here or on Microsoft Forums. We will be pleased to sol

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

for the >>> >> owner/admin of the workbook. >>> >> >>> >> If you are learning this stuff, then pw is of no use to you rather you >>> >> should try creating this type of workbook on your own. :) >>> >> >>> >>

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

;> Best Regards, >> >> DILIPandey >> >> >> >> On 9/7/10, Vamsi Tatipamula >> >> wrote: >> >> > Thanks dilip for your explanation. >> >> > Can you share the password for that excel to open RSM sheet. >> >> &g

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

uld try creating this type of workbook on your own. :) >> >> >> >> Please feel free to get back in case any help is required. >> >> >> >> Best Regards, >> >> DILIPandey >> >> >> >> On 9/7/10, Vamsi Tatipamul

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

ssword for that excel to open RSM sheet. > >> > > >> > > >> > Regards, > >> > vamsi > >> > > >> > -Original Message- > >> > From: Dilip Pandey [mailto:dilipan...@gmail.com] > >> > Sent: Tuesday, September 07,

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

---Original Message----- >> > From: Dilip Pandey [mailto:dilipan...@gmail.com] >> > Sent: Tuesday, September 07, 2010 3:14 PM >> > To: Vamsi Tatipamula >> > Cc: excel-macros@googlegroups.com >> > Subject: Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect &a

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

Sent: Tuesday, September 07, 2010 3:14 PM > > To: Vamsi Tatipamula > > Cc: excel-macros@googlegroups.com > > Subject: Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet > > > > Hi Vamsi, > > > > Thanks for your continuous interest. &g

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

t; Sent: Tuesday, September 07, 2010 3:14 PM > To: Vamsi Tatipamula > Cc: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet > > Hi Vamsi, > > Thanks for your continuous interest. > The VBA macro is working fine in my

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

amsi > > -Original Message- > From: Dilip Pandey [mailto:dilipan...@gmail.com] > Sent: Tuesday, September 07, 2010 10:45 AM > To: Vamsi Tatipamula > Cc: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet > >

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

, September 06, 2010 10:11 PM > To: Vamsi Tatipamula > Cc: excel-macros@googlegroups.com; kalx...@gmail.com > Subject: Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet > > Hi Vamsi, > > Sure.. below is explanation:- > > Requirements were to unprotect and unhide a wor

Re: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet

acros@googlegroups.com > Subject: $$Excel-Macros$$ Re: Excel-Macros$$ Protect & hide Sheet > > Dear Kalyan, > > Attached spreadsheet has been solved as per your requirement(s). > > Note:- Going forward please mark the group as well while marking the query > email to me. By

Re: $$Excel-Macros$$ Re: $excel-macros$ help

Dear Kishan Reddy This is a very good tip and many thanks for sharing the same. I knew about excel clip board for many years but this idea of using "Paste all" to combine all sheets is really a magic. Thanks Chandru On Thu, Jul 22, 2010 at 11:36 AM, Kishan Reddy, K < kishanreddy.kethire...@gmail

$$Excel-Macros$$ Re: $excel-macros$ help

Hello, Open the Office clipboard: From Menu select Edit -> Office clipboard. Office clipboard will appear on the right side. Goto sheet 1 and select Data, and Press Control+C, Data will appear on Office Clipboard. Repeat the above step for all sheets. Then use the Paste All Option on Office cl

$$Excel-Macros$$ Re: $excel-macros$ help

Hi Preeti Please find attached the solution as required, do let me know if something else is required. Regards, Rajender Soni | +91 750 322 55 50 -- -- Some important links for excel users: 1. Follow us on TWITTER

$$Excel-Macros$$ Re: $excel-macros$ help - merge sheets into one sheet

Hi preeti, This code covers your task, you can run it and enjoy. It was interesting problem to solve. Please tell us does it work for you. Sub automate() Dim i, j, k, n, myfile, mySheet Call ListWorkSheetNames myfile = ActiveWorkbook.FullName Sheets("main sheet").Select Cells.Select

$$Excel-Macros$$ Re: $excel-macros$ help

Hi preeti, This code covers your task, you can run it and enjoy. It was interesting problem to solve. Please tell us does it work for you. Sub automate() Dim i, j, k, n, myfile, mySheet Call ListWorkSheetNames myfile = ActiveWorkbook.FullName Sheets("main sheet").Select Cells.Select

$$Excel-Macros$$ Re: Excel - Macros training in Excel 2003

Thanks a Ton.. Nikhil That's a great Help.. On Jul 10, 10:02 pm, Nikhil Shah wrote: > Dear Friends > > Here i am sending One URL For Excel - Macro Training in excel 2003. > > http://www.familycomputerclub.com/excel/excel2003_macros.html( With Video ) > In English &  Hindi also

RE: $$Excel-Macros$$ Re: Excel Macros Free PDF

And never underestimate the value of the macro recorder. The code may need a bit of cleaning up, but syntax is all there for you to take in, and reapply in your own code. Dave. > Date: Thu, 11 Feb 2010 18:53:53 -0800 > Subject: $$Excel-Macros$$ Re: Excel Macros Free PDF > From

$$Excel-Macros$$ Re: Excel Macros Free PDF

welcome to wonderful world of vba :) Unsure such a PDF exists (least I havent come across it yet myself) - however Excel's built-in VBA help provides a good starting place especially when coupled with Google for more examples, code fragments, tips/etc available from the numerous vba dedicated webs

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

Hi Karthikeyan, You need to clean up the data before preparing Pivot Table. If the data set is going to be similar in future as well, then I would suggest to use VBA macro code. If the data is differrent always or is extracted using different columns and rows then you might want to do the data c

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

good luck friend ! :) Hemant Hegde 2009/11/1 karthikeyan sankaran > I have download this data from PDF.Now I want to create pivotTable through > this data. > > > > --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: excel macros -non numeric value

*see attached file* On Wed, Sep 2, 2009 at 1:37 PM, ymusafi wrote: > > Hi All > I want to create a macro that is doing somthing if the cell value has > non numeric value > meaning: > if cell.value=???then > I just need to know what to put instead of the question marks > Thanks! > > > > -- Th

$$Excel-Macros$$ Re: excel macros -non numeric value

ymusafi, The following code checks to see whether the cell's contents is numeric or not: Public Function Test(cell As Range) If IsNumeric(cell.Value) Then Debug.Print "Numeric" Else Debug.Print "Not numeric" End If End Function Try it in the Immediate Window by typin

$$Excel-Macros$$ Re: excel-macros - 26 new messages in 18 topics - digest

for that you need to open the personal workbook in order to run a macro from any workbook... you need to have that workbook open i have windows 7 installed and excel 2007... so the path for personal workbook for me is the below.. C:\Users\Vivek\AppData\Roaming\Microsoft\Excel\XLSTART\ ki

$$Excel-Macros$$ Re: excel-macros - 26 new messages in 18 topics - digest

Hi Everybody, I have created a macro in personal macro workbook, and saved it, it worked very good as per my expectation, but now when I run again the macro, it did'nt work the message like "Personal Macro workbook should be open". Is there anybody to help me ? REHAN BAIG --~--~-~--~--

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

Try to use shortcut key.*"Shift + Space Bar"* On Tue, Aug 4, 2009 at 2:29 PM, Sheyn Lee wrote: > Dear All, > Is there any option that when I select a cell in the sheet, the whole row > corresponding to that cell is highlighted. > In the attached example I have selected cell C7. Required

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

rget.EntireRow.Select works too. In fact, Target.EntireRow.Interior.PatternColorIndex = xlAutomatic (and the rest) would probably work too, though I haven't tested it... thx, paul From: Andre Dreyer To: MS EXCEL AND VBA MACROS Sent: Tuesday, August 4, 2009 10:04:41 AM Subjec

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

Hi there, There is an easier way to do this as well with a single line of code in the Worksheets OnChange event, Target.EntireRow.Select It works pretty well. Cheers On Aug 4, 2:12 pm, Paul Schreiner wrote: > I don't know that there is any OPTION for this, but > I have done it before with a

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

I don't know that there is any OPTION for this, but I have done it before with a MACRO. but there are a few "tricks" I use the Worksheet_SelectionChange event. First, record a macro in which you clear all formatting (highlighting) then "highlight" the row you wish to highlight. this will get you

$$Excel-Macros$$ Re: $$ Excel-Macros $$ Consolidation of different sheet by macro

bject: $$Excel-Macros$$ Re: $$ Excel-Macros $$ Consolidation of different sheet by macro To: excel-macros@googlegroups.com Date: Friday, 3 July, 2009, 6:06 AM Hi Sanjay, If you are using Excel 2003 then keeping your cursor in the data and then clicking Ctrl+A would choose the whole range of the

$$Excel-Macros$$ Re: $$ Excel-Macros $$ Consolidation of different sheet by macro

Hi Sanjay, If you are using Excel 2003 then keeping your cursor in the data and then clicking Ctrl+A would choose the whole range of the data where your cursor is placed...Try doing this while recording the macro, It will work. Thanks, Shreedar On Thu, Jul 2, 2009 at 12:27 PM, SANJAY SONI wrote:

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

This will help you. http://www.functionx.com/vbaexcel/ Thank You, Rajesh Kunder On Thu, Jun 18, 2009 at 11:09 AM, lingesh p wrote: > Hi all, > > Can anyone send me a ppt or an overview abt macros > i want to learn the basics of macros. is there any one who can help me with > this > > > > Thanks

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

Hi All Can anyone send me a ppt or an overview abt macros i want to learn the basics of macros. Please help me Thanks & Regards Anil Kumar Executive - Database SOLUTIONS DIGITAS 3rd Floor, Chandra Bhawan, 67-68, Nehru Place | New Delhi - 110019 | India Mobile: +(91) 9211851980 | Email: anilku...

$$Excel-Macros$$ Re: Excel macros

Hi Mayank Please refer to the group's files section and online resources. You may search through excelitems.com too. Excel VBA Learning Files --> http://groups.google.com/group/excel-macros/files Website --> http://www.excelitems.com - Regards Ashish

$$Excel-Macros$$ Re: excel macros

Hi Mayank, please look into the site. http://www.vbamacros.blogspot.com regards Hari Kumar On Mon, Jun 1, 2009 at 7:16 AM, mayank khare wrote: > plz replyyy > > On Mon, Jun 1, 2009 at 7:13 AM, mayank khare wrote: > >> Hai, >> I want to learn indepth excel macros. >> Plz tell the resource to l

$$Excel-Macros$$ Re: excel macros

plz replyyy On Mon, Jun 1, 2009 at 7:13 AM, mayank khare wrote: > Hai, > I want to learn indepth excel macros. > Plz tell the resource to learn this. > I do not know any language ie Visual Basic ,which i know is required to > write a macro. > Plz guide me. > > -- > Warm Regards > Mayank Khare >

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

Hi Atul, Sorry about that. Try the modified attached. Regards - Dave. Date: Wed, 27 May 2009 14:08:38 +0530 Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$ From: atul.kesa...@gmail.com To: excel-macros@googlegroups.com Hello Dave, One small issue in the macro, the cell number " b

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

You're welcome. Date: Wed, 27 May 2009 11:11:24 +0530 Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$ From: atul.kesa...@gmail.com To: excel-macros@googlegroups.com Hello Dave, You are a rock Star...thanks a ton!!! The macro is awesome.this is what i w

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

Dave. >> >> ------ >> Date: Tue, 26 May 2009 18:33:57 +0530 >> Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$ >> From: atul.kesa...@gmail.com >> To: excel-macros@googlegroups.com >> >> >> Hello Dave, >> >> Thanks for

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

u want. > I've added a button to run the macro from the sheet, but you may want to run > it some other way. > I've left your formulas as you had them. > Regards - Dave. > > -- > Date: Tue, 26 May 2009 18:33:57 +0530 > Subject: $$Ex

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

t: $$Excel-Macros$$ Re: $$Excel-Macros$$ From: atul.kesa...@gmail.com To: excel-macros@googlegroups.com Hello Dave, Thanks for the below formulas. The reason I am asking for the macro is that we have more then 25 sheet in a file and more then 200 line items in each sheet, macro would help

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

Hello Dave, Thanks for the below formulas. The reason I am asking for the macro is that we have more then 25 sheet in a file and more then 200 line items in each sheet, macro would help to reduce the file size and minimize the changes of error. I have attached a file in which i have tried to wri

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

Hi , I think the best and efficient way to learn is to buy a Excel 2003/2007 book and come to forum a lot. That is exactly how I started one and half year ago. On Sun, May 10, 2009 at 2:18 PM, bathina srinivasa rao < ask_...@rediffmail.com> wrote: > kindly help by sending Ebook on Excel. > >

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

Hi Joe, The reason you get the flood of emails not solely pertaining to yourself is so that perhaps you can help others with their problems, and not simply receive solutions to your own. This is how the group works - everyone pitching in. Regards - Dave. From: j...@it4u.co.uk To: excel-mac

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

I want the chart to display only a portion of the data table with the chart like this: (only groups show in data table) Instead of this: (groups and control lines show) It doesn't seem like changing the columns to white text is flowing through to the data table that goes with the

$$Excel-Macros$$ Re: excel macros

Tom I dont see an 'attach file' option when I reply..??? On Jan 8, 1:48 pm, "Tom Jeffries" wrote: > When you reply to a message you will see an "Attach File" link beneath the To: > box.. Click it. You will then see a Choose File button.  Click it. Select > file to be attached. Click Open. T

$$Excel-Macros$$ Re: excel macros

When you reply to a message you will see an "Attach File" link beneath the To: box.. Click it. You will then see a Choose File button. Click it. Select file to be attached. Click Open. That's all there is to it. The selected file will be attached to your message. On Thu, Jan 8, 2009 at 4:14 AM, J

$$Excel-Macros$$ Re: excel macros

I think you can actually do this without a macro, but use Excel formulas instead. I have a calendar that for each quarter, I count the days that are identified with "V" for "vacation day" or "H" for "Half day". then, I use: =COUNTIF($D6:$Z11,"*H")*0.5+COUNTIF($D6:$Z11,"*V") to count the "H's" and

$$Excel-Macros$$ Re: excel macros

I have Tom, but how can I attach the spreadsheet for you to view ? On Jan 5, 9:53 pm, "Tom Jeffries" wrote: > Do you have an example of the Calendar? Describe its format in more detail. > > > > On Mon, Jan 5, 2009 at 5:18 AM, Joe wrote: > > > > I wonder if you can help out an absolute novice w

$$Excel-Macros$$ Re: excel macros

Do you have an example of the Calendar? Describe its format in more detail. On Mon, Jan 5, 2009 at 5:18 AM, Joe wrote: > > > I wonder if you can help out an absolute novice when it comes to excel > > macros. > > My girlfriend has sent me some homework as she has to work today and I am > > a

$$Excel-Macros$$ Re: Excel Macros totaling like values

Hi Naveen, I sorted the spreadsheet so that all entries with the same state were grouped together - and used the SUBTOTAL function. It worked well to total the number of times each state code occurs. The results I get are: AB Count 11 AE Count 4 AK Count 7 ...and so on (there are over 35,000 ent

$$Excel-Macros$$ Re: Excel Macros totaling like values

By using SUBTOTAL function in data menu, it can be done.         Regards Naveen Kumar M N     Transport Supervisor(HP) 91-08-99728 10886     Email :[EMAIL PROTECTED]   Best Wishes-Karunaada Kuvara --- On Wed, 11/5/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: From: [EMAIL PROTECTED] <[

$$Excel-Macros$$ Re: Excel Macros totaling like values

can you send the file. Regards CA. Atul Singhal -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: November 06, 2008 2:58 AM To: MS Excel & VBA Macros Subject: $$Excel-Macros$$ Excel Macros totaling like values How do I create a macro in Excel that will count t

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

t: $$Excel-Macros$$ Re: $$Excel-Macros$$ Dear Mr. Atul, But formula can not read text "comm" for taking value of %, it is taking the same on fifo basis. Regards, Kamlesh On Thu, Oct 23, 2008 at 2:35 PM, SINGHAL, ATUL. < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >

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

lem. > > > Regards > > CA. Atul Singhal > > > -Original Message- > *From:* Abhijit Kanhegaonkar [mailto:[EMAIL PROTECTED] > *Sent:* October 22, 2008 9:44 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Re: $$Excel-Macros$$ > >

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

Thanks dude, It worked wonderfully!! Regards Abhijit _ From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of SINGHAL, ATUL. Sent: Thursday, October 23, 2008 2:36 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$ Hi

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

ill help you in developing the vb code, I know it is a bit challenging and you can do it. Regards Abhijit _ From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of AJIT NAVRE Sent: Wednesday, October 22, 2008 8:43 PM To: excel-macros@googlegroups.com Subject: $$Ex

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

ghal > > > -Original Message- > *From:* Abhijit Kanhegaonkar [mailto:[EMAIL PROTECTED] > *Sent:* October 22, 2008 9:44 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Re: $$Excel-Macros$$ > > Hey guys, > > > > Very interesting! I th

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

Please unsuscribe me --- On Thu, 23/10/08, Venkata Narayana <[EMAIL PROTECTED]> wrote: From: Venkata Narayana <[EMAIL PROTECTED]> Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$ To: excel-macros@googlegroups.com Date: Thursday, 23 October, 2008, 1:06 AM Dear,   You can copy u

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

Hi Abhi, I think, the enclosed file can solve your problem. Regards CA. Atul Singhal -Original Message- From: Abhijit Kanhegaonkar [mailto:[EMAIL PROTECTED] Sent: October 22, 2008 9:44 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$ Hey guys

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

Dear, You can copy using formula see excel sheet, select that cell to see formula With regards, Venkata Narayana K On 10/19/08, Mattathil M. Pradeep <[EMAIL PROTECTED]> wrote: > > Dears.. > > > > How to copy particular data from one cell ? attached excel sheet for your > reference. > > > > Th

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

file. > Pls revert. > > > > Regards > > > > Abhijit > -- > > *From:* excel-macros@googlegroups.com [mailto: > [EMAIL PROTECTED] *On Behalf Of *H Upadhyay > *Sent:* Tuesday, October 21, 2008 7:26 PM > *To:* excel-macros@googlegrou

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

t _ From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of H Upadhyay Sent: Tuesday, October 21, 2008 7:26 PM To: excel-macros@googlegroups.com Cc: [EMAIL PROTECTED] Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$ pls chk this Regds Harish Upadhyay AXIS BANK LTD

$$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

$$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$$

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: $$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$$

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$$

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$$

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$$

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$$

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$$

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: Excel Macros Book?

Hi All, if you want Macros book in PDF format you can search them in following website. www.*4shared*.com On Wed, Sep 24, 2008 at 8:56 PM, kalpesh velinkar <[EMAIL PROTECTED] > wrote: > Dear John. > > Even I would like to learn. In case you find some solution without VBA. > Please let me know.

$$Excel-Macros$$ Re: Excel Macros Book?

Wiley - Excel 2003 Power Programming With Vba - John Walkenbach On Sep 16, 4:23 am, SilvergunSuperman <[EMAIL PROTECTED]> wrote: > Would anyone be able to recommend a good book to purchase wrt to > Macros and VBA? > > Thanks in advance!!  : ) --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Excel Macros Book?

you may visit http://socko.wordpress.com and let me know the feedback. If you have anything new in macro/vba please let me know. selva On Sep 16, 6:41 pm, "johnson dara" <[EMAIL PROTECTED]> wrote: > Hi All, > > I would like to learn and start using macros as my daily life involves lot > of routin

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

hello first of u go on print preview and setup then go to header & footer , select page of 1 ? in header apply I think ur problem solved On 9/25/08, pavithra murthy <[EMAIL PROTECTED]> wrote: > > > hi > i want the code for page numbers to appear on top of the print preview of > my report on top o

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

u can use header or footer in print option - Original Message - From: pavithra murthy To: excel-macros@googlegroups.com Sent: Thursday, September 25, 2008 8:30 PM Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$ hi i want the code for page numbers to appear on top of the

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

Pavithra Try this under Headdeara and footers Insert Page nomber and also pages the symbol # and insert "/" and then click ++ it should appear like &[Page]/&[Pages] Let me know if it works Happy excelling S Baloo On Thu, Sep 25, 2008 at 9:00 PM, pavithra murthy <[EMAIL PROTECTED]>wrot

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

hi i want the code for page numbers to appear on top of the print preview of my report on top on the right sidesimilarly it has to increment for each page for eg: if 3 pages are there it should come like 1st page : 1/3 2nd pg :2/3 3rd pg :3/3 i needed a generalized function so th

$$Excel-Macros$$ Re: Excel Macros Book?

Dear John. Even I would like to learn. In case you find some solution without VBA. Please let me know. Kalpesh On Tue, Sep 16, 2008 at 7:11 PM, johnson dara <[EMAIL PROTECTED]> wrote: > Hi All, > > I would like to learn and start using macros as my daily life involves lot > of routine excel job

$$Excel-Macros$$ Re: Excel Macros Book?

Totally agree with Mohd. I have several books (learning as well) and Microsoft Press Step-by- Step is one of the best Robert On Sep 17, 6:14 am, "Idrees Akhtar" <[EMAIL PROTECTED]> wrote: > VBA Programmer Refrence 2003 is the one of the best book to learn the vba > programming in EXCEL. > > YOu

$$Excel-Macros$$ Re: Excel Macros Book?

Hi, here is another one: http://excel-macros.googlegroups.com/attach/4d97bd1a51c32c86/O%27Reilly+-+VB+%26+VBA+In+A+Nutshell.zip?part=4 On Sep 15, 7:23 pm, SilvergunSuperman <[EMAIL PROTECTED]> wrote: > Would anyone be able to recommend a good book to purchase wrt to > Macros and VBA? > > Thanks i

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

try this To return the week number of a date we can use the WEEKNUM formula. It will return a number that indicates where the week falls numerically within a year. If this function is not available, and returns the #NAME? error, install and load the *Analysis ToolPak* add-in. That is, *Tools*>*Add

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

You can use function *weeknum* On Thu, Sep 18, 2008 at 3:49 PM, Lakshmanan T S < [EMAIL PROTECTED]> wrote: > Hi friends, > > Is there any predefined function or menu in Excel by which we can reflect > the Week no inside a cell, if dates are entered in another cell? > For example, the running week

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

Hi Dude... Yes it is there for that you need to install add in - --- Analysis Tool pack the FUNCTION name is =WEEKNUM(A1). hope this will work.. Thanks, yogesh 2008/9/18 Lakshmanan T S <[EMAIL PROTECTED]> > Hi friends, > > Is there any predefined function or menu

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

Hi friends, Is there any predefined function or menu in Excel by which we can reflect the Week no inside a cell, if dates are entered in another cell? For example, the running week now is week no 38 of the year 2008. So if we enter in cell A1 , 09/18/2008, can we get Week no 38 in A2 by way of a

$$Excel-Macros$$ Re: Excel Macros Book?

hi, I have downloaded: John Walkenbach "Power Programming with VBA". For me it's really helpful Here you can find it: http://www.akae.cn/ftp/mirror/194.44.214.3/e-books/john%20wiley%20&%20sons%20-%20excel%202002%20power%20programming%20with%20vba.pdf I hope the link is working cause I've downloa

$$Excel-Macros$$ Re: Excel Macros Book?

VBA Programmer Refrence 2003 is the one of the best book to learn the vba programming in EXCEL. YOu can download that book from esnips.com , just write the vba programming and you fill find many book regarding excle vba programming. download the sybase mastering excel programming, vba power progra

$$Excel-Macros$$ Re: Excel Macros Book?

Microsoft Press Step-by-Step is excellent if you are new to VBA On Sep 16, 2:23 am, SilvergunSuperman <[EMAIL PROTECTED]> wrote: > Would anyone be able to recommend a good book to purchase wrt to > Macros and VBA? > > Thanks in advance!!  : ) --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Excel Macros Book?

I am working through Excel for Scientists and Engineers (Numerical methods) by E. Joseph Billo. It has several sections on the basics of VBA On Sep 15, 9:23 pm, SilvergunSuperman <[EMAIL PROTECTED]> wrote: > Would anyone be able to recommend a good book to purchase wrt to > Macros and VBA? > > T

$$Excel-Macros$$ Re: Excel Macros Book?

Hi All, I would like to learn and start using macros as my daily life involves lot of routine excel jobs. I would be grateful if any one shares how to start using macros. Should i start learn VBA? Should i manage with the help of books or is it mandatory to attend some practical classes. regds J