$$Excel-Macros$$ Re: FORMULA FOR EXCELL SHEET

You are always welcome...!! suggestion:- Please do not write all Caps while writing any email. Thanks. -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Fri, Mar 12, 2010 at 3:44 PM,

RE: $$Excel-Macros$$ Create Multiple copies of the same file and rename as per a list

Hi The attached has a macro for saving 10 books according to names in the list on Sheet1. The Workbooks are saved to the default location, but that can be changed. Not sure if it's what you want, but maybe it's a start. Regards - Dave. Date: Thu, 11 Mar 2010 02:11:47 -0800 Subject: Re:

Re: $$Excel-Macros$$ Re: Finding a diff b/w two time

You're welcome Harry. :-) On Thu, Mar 11, 2010 at 11:34 PM, Harpreet Singh Gujral harpreetguj...@gmail.com wrote: AJ, Thanks, this is exactly what i was looking for Thanks Harry On Mar 7, 10:53 pm, Abhishek Jain abhishek@gmail.com wrote: Dear Harpreet, Check the sample file

Re: $$Excel-Macros$$ Macro to filter dates using Userform1 printing

Mel, I did something similar to this (not sorting but filtering) for another project. If you put a sample file of yours, I can help. Best, AJ On Thu, Mar 11, 2010 at 10:22 PM, Mel mel.pilg...@agr.gc.ca wrote: I have a speadsheet that has 5 columns. (Headings are in row 2 and are: Cell

$$Excel-Macros$$ Re: Fetching Data from All Sheets to Summary Sheet - Very Urgent

Dear Ayush, Thanks. I thought of this but in Summary sheet I would have to manually select (or type) the range of each sheet in Vlookup formula. Also I would have to make a combined column in each sheet. Like I said there are around 66 sheets and writing vlookup and make an additional column in

Re: $$Excel-Macros$$ Create Multiple copies of the same file and rename as per a list

Parag, Please elaborate what data you want to pick and where ? Suggestion: Please post new queries by creating new email. Best regards, AJ On Fri, Mar 12, 2010 at 5:51 PM, Parag paragdafal2...@gmail.com wrote: Hi, im attaching 2 file can anyone help me to conditional vlookup, i want to

Re: $$Excel-Macros$$ XLS 2003 to 2007 Concerns

We had very few. The biggest was that they dropped FileSearch. which is used to search the filesystem for files matching specific criteria. Instead, we had to write our own version of FileSearch using the Filesystem object and the Folders and Files collections. other than that, and the fact that

Re: $$Excel-Macros$$ pivot table help for pos

Hello Dear, I have already viewed your problem. please respond that what you want in pivot column and in pivot row. Please reply so that we can prepare exact pivot. Hope It Will Help Happy To Help :) Shyam On Fri, Mar 12, 2010 at 5:25 PM, satya narayana snarayana@gmail.comwrote:

Re: $$Excel-Macros$$ Fwd: Fetching Data from All Sheets to Summary Sheet - Very Urgent

Hello Dear Great Solution,Really appriciate the team work. Happy to Help :) Shyam On Fri, Mar 12, 2010 at 10:43 AM, Abhishek Jain abhishek@gmail.comwrote: -- Forwarded message -- From: Abhishek Jain abhishek@gmail.com Date: Fri, Mar 12, 2010 at 10:42 AM

Re: $$Excel-Macros$$ Re: Fetching Data from All Sheets to Summary Sheet - Very Urgent

Hello Dear Try To concatenate using operator. If u want to concatenate a1 and b1 then try to use =a1/b1 Hope It Will Help Happy To Help :) Shyam On Fri, Mar 12, 2010 at 11:21 AM, Abhishek Jain abhishek@gmail.comwrote: Dear Ayush, Thanks. I thought of this but in Summary sheet

$$Excel-Macros$$ Uncertain number of input for VBA function

Hello, how can I have uncertain number of input for VBA function? Example, in SUM function, you may put in any numbers of cells reference or values == =SUM(D7,D11,D8,F16). In this case, 4 inputs. How can I set this up in VBA function? --