$$Excel-Macros$$ IMPORT FIXED WIDTH TXT FILE TO EXCEL

From: vivek jain [mailto:vivek.j...@gmail.com] Sent: Saturday, April 03, 2010 8:04 AM To: 'excel-macros@googlegroups.com' Cc: 'excel-macros+nore...@googlegroups.com' Subject: IMPORT FIXED WIDTH TXT FILE TO EXCEL Dear Group Members, I want to import a txt file w

$$Excel-Macros$$ HOW TO CALCUATE THE NO. OF YEARS BETWEEN TWO DATES

on 01/01/2004 it will show zero result whereas I want 1. Again if the asset has been acquired on 01/01/2005 it will show "-1" whereas I want it to be zero. Is there any other formula I can use. Thanks & regards... CA Vivek Jain, FCA --~--~-~--~~~---~

$$Excel-Macros$$ Re: HOW TO CALCUATE THE NO. OF YEARS BETWEEN TWO DATES

Apr-05 1 2 [c1] =DATEDIF(A1, B1, "Y") On Sun, Sep 21, 2008 at 9:57 AM, vivek jain http://vivek.j.ca/> @gmail.com <http://gmail.com/> > wrote: Dear All, I am preparing a fixed asset register for the last fifty years for an organization. I have to calculate t

$$Excel-Macros$$ Page numbering in excel

The numbers should start after the last page number in MS Word. E.g. if the last page number in theory part is 12, in excel it should start from13 and should continue in different sheets. And once completed can I get a combined index. Thanks.. CA Vivek Jain,

$$Excel-Macros$$ Re: Page numbering in excel

choose i.e page14 when ur sheet end e.i page no.20 then u go next sheet remove auto and write 21 I think ur problem have been solved. Tiwari On 9/29/08, vivek jain <[EMAIL PROTECTED]> wrote: Dear All, I prepare project reports for my clients wherein I prepare the theory part in M

$$Excel-Macros$$ Re: Page numbering in excel

iew the sheets indivdiuallay, page numbering may not be in > sequenece. > But, if you preeiw the whole work book, page numbers will be in sequene. > > Thansk and regards, > Naresh > > > On 9/29/08, vivek jain <[EMAIL PROTECTED]> wrote: >> >> Dear All, >> &

$$Excel-Macros$$ Re: , is to .csv as ____ is to .xls

You can use text to column option in excel by using , as a separator and get the data in excel in columnar form. Thanks & Regards... cid:image001.jpg@01C85EB8.0483F790 Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari R

$$Excel-Macros$$ Automatic Page Numbering in Excel

number for first page. Moroever it doesn't work when all sheets are not selected. Please help Thanks & Regards... cid:image001.jpg@01C85EB8.0483F790 Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari Road, A T Road, Gu

$$Excel-Macros$$ PREPARE INDEX WITH PAGE NUMBERS

ith Me.Hyperlinks.Add Anchor:=Me.Cells(M, 1), Address:="", SubAddress:="Start" & wSheet.Index, TextToDisplay:=wSheet.Name End If Next wSheet End Sub Thanks & Regards... cid:image001.jpg@01C85EB8.0483F790 Vivek Jain, FCA, DISA (ICAI)

$$Excel-Macros$$ Re: PREPARE INDEX WITH PAGE NUMBERS

Dear Ashish, Thanks for your reply. But I have to admit that I am a novice so far as using VBA code is concerned. So it would be very kind of you , if you could be a detailed reply on how to use the solution provided by you. Thanks & Regards... Vivek Jain, FCA, DISA (ICAI) Vivek Shant

$$Excel-Macros$$ what is the keyboard shortcut to copy entire cell

need not press F2 and then select the cell data. Thanks & Regards... cid:image001.jpg@01C85EB8.0483F790 Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari Road, A T Road, Guwahati-781001 (0361-2603895,9435019908 Fro

$$Excel-Macros$$ WARNING SIGNAL IN CASE OF ERROR

message that my balance sheet does not tally in case of any difference in assets and liabilities. Thanks & Regards... cid:image001.jpg@01C85EB8.0483F790 Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari Road, A T Road,

$$Excel-Macros$$ Re: WARNING SIGNAL IN CASE OF ERROR

Dear Ashish, Thanks for the reply. But I have no knowledge about writing macros. So it would be very kind of you if you could elaborate on the solution. Thanks & Regards... Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari

$$Excel-Macros$$ Re: WARNING SIGNAL IN CASE OF ERROR

Dear Ajay, I tried the solution provided by you. But I couldn’t do it. I am attatching the file in which I copied the code provided by you. Please have a look at it and let me know where I went wrong. Thanks & Regards.. CA Vivek Jain From: excel-macros@googlegroups

$$Excel-Macros$$ Re: WARNING SIGNAL IN CASE OF ERROR

d file. On Tue, Jun 9, 2009 at 3:10 PM, vivek jain wrote: Dear Ajay, I tried the solution provided by you. But I couldn’t do it. I am attatching the file in which I copied the code provided by you. Please have a look at it and let me know where I went wrong. Thanks & Regards..

$$Excel-Macros$$ HELP ON CHART PREPARATION

place based on % of sale ratio. Please let me know the steps to do the same . I am using Excel 2007. Thanks & Regards... cid:image001.jpg@01C85EB8.0483F790 Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari Road,

$$Excel-Macros$$ Re: HELP ON CHART PREPARATION

Pivot Table Chart. Please find attached the solution. Let me know if it helps. Regards, Andy On Thu, Jun 11, 2009 at 8:08 PM, vivek jain wrote: Dear All, I want to prepare chart for the following data:- State Place % ot Total Sales Manipur Imphal 2.57% Meghalaya

$$Excel-Macros$$ ERROR IN RUNNING MICROSOFT QUERY

ds... cid:image001.jpg@01C85EB8.0483F790 Vivek Jain, FCA, DISA (ICAI) Vivek Shantilal Jain & Co. Chartered Accountants 3010 Ram Kumar Arcade, Chatribari Road, A T Road, Guwahati-781001 (