RE: $$Excel-Macros$$ Need a Macro

2011-03-10 Thread Dave Bonallack
Hi, One approach is to insert a new blank sheet, call it "END" and move it to become the last sheet in the workbook. Whenever adding new sheets, make sure they sit before the "END" sheet. If your SUM formula was, for example: =SUM(Sheet2:Sheet8!A1) change it to: =SUM(Sheet2:END!A1) All sheets bet

$$Excel-Macros$$ Need a Macro

2011-03-10 Thread karlaha...@hotmail.com
I have a tab that totals all of the other tabs in the spreadsheet. I need to be able to add new tabs and have the formulas in the "totals" tab automatically update. How do I do this? -- -- Some important links for e

$$Excel-Macros$$ Help on pivot table

2011-03-10 Thread Jorge Marques
Hi, is it possible to do a pivot table of these workbook, but merging the 3 worksheets?the problem is that column C of the 3 worksheets are different and can´t be mixed if i choose for example Values of january, my first thought is like sheet4 but there i have to take the blanks manually and be car

Re: $$Excel-Macros$$ File attachement

2011-03-10 Thread ChilExcel
see attached file, I presume you need to concatenate VB module inserted into a book and paste this code, published in this forum, I do not remember author who is the creator we appreciate it! Sub Delete_Rows() Dim rng As Range, counter As Integer Set rng = Sheets(1).Range("A1") counter = 1

Re: $$Excel-Macros$$ File attachement

2011-03-10 Thread ChilExcel
you need to do? Chilexcel 2011/3/10 Cesar Delanoval > I am sending you the sample file that goes my latest post since I was not > able to attach it or upload it on the group website. > I appreciate all your help > Thanks > > -- > > --

$$Excel-Macros$$ Playing Gif files in excel

2011-03-10 Thread santosh subudhi
Hi, Can anyone help me in playing a gif file in excel I am using excel 2003 and 2007 version. I want to play a gif file in worksheet and in userform both. -- Regards Santosh santoshkumar.subu...@gmail.com -- -- S

Re: $$Excel-Macros$$ Extracting address from a file

2011-03-10 Thread CAN
I couldn't upload the sample file, but today I emailed it to group address. On Mar 10, 4:20 am, Sanjoy Nath wrote: > no sample is there. >    One thing more , for this , we can use the formula like > =indirect(Address(row,column) > > and no things like macro is necessary for all kinds of transfor

Re: $$Excel-Macros$$ File attachement

2011-03-10 Thread siti Vi
please tell me.. what is the previous / original subject of this case "FILE ATTACHMENT" as a subject is not make a sense anymore http://groups.google.com/group/excel-macros/browse_thread/thread/def081e4a88ac093 On Thu, Mar 10, 2011 at 9:49 PM, Cesar Delanoval wrote: > I am sending you the sam

$$Excel-Macros$$ Need Advise

2011-03-10 Thread Prathima R
Hi experts, I Need your valuable advise and suggesting i am about to appear for the FP&A interview very shortly ,can anyone of you suggest me interview questions link if any one you have it. Thanks alot in advance. Regards, Prathima -- --

Re: $$Excel-Macros$$ Calculate Time

2011-03-10 Thread tamas
see att. Tom On Thu, 10 Mar 2011 20:25:35 +0530, Rajesh K R wrote: Hi Ashish Thanks for the reply, I need some more change in it, Kindly check the attachment . Regards Rajesh Kainikkara On 3/8/11, ashish koul wrote: see if it helps On Mon, Mar 7, 2011 at 9:52 PM, Rajesh K R wrote: Hi E

Re: $$Excel-Macros$$ Calculate Time

2011-03-10 Thread Rajesh K R
Hi Ashish Thanks for the reply, I need some more change in it, Kindly check the attachment . Regards Rajesh Kainikkara On 3/8/11, ashish koul wrote: > see if it helps > > On Mon, Mar 7, 2011 at 9:52 PM, Rajesh K R > wrote: > >> Hi Experts , >> >> Kindly check the attached file and tell how to

$$Excel-Macros$$ Help on a simple question

2011-03-10 Thread Jorge Marques
I have a doubt dear friends, i have 3 reports i receive each month, so every month i have to to an overall report of the 3 like a database, but the format of the data isn´t equal and doesn´t allow to do a pivot table, my idea was to create 3 pivotreports (by putting in pivot format and linking the

Re: $$Excel-Macros$$ Extracting address from a file

2011-03-10 Thread Sanjoy Nath
no sample is there. One thing more , for this , we can use the formula like =indirect(Address(row,column) and no things like macro is necessary for all kinds of transformations On Wed, Mar 9, 2011 at 10:41 PM, CAN wrote: > First of all, thank you for all the help that I received so far.

Re: $$Excel-Macros$$ Help in Excel

2011-03-10 Thread Sanjoy Nath
find the file it is done On Wed, Mar 9, 2011 at 4:04 PM, Rajiv Kumar wrote: > > > -- > *Thanks & Regards > > * > *Rajiv Kumar > * > *Mawana Sugar Works, Mawana > * > *Mo.No: 09027414899* > > > -- > > -- > Some import