Re: $$Excel-Macros$$ Database sort (copy from one sheet to another sheet in different order)

2013-02-02 Thread David Grugeon
Continuation of reply 1) Are the names always in the same order in the input? Do they change from period to period or from region to region? 2) Are the names for the report always to be in the same order (different from the input order)? 3) Are the item descriptions for the report always to be a

Re: $$Excel-Macros$$ Database sort (copy from one sheet to another sheet in different order)

2013-02-02 Thread David Grugeon
Hi Joseph There are a number of possible approaches to this. My preference would be not to do it with VBA but with formulae. The reason is that the formulae would be easy to maintain, and easier to write than the VBA. However there are some questions for you before I can propose an exact soluti

Re: $$Excel-Macros$$ Database sort (copy from one sheet to another sheet in different order)

2013-02-02 Thread joseph . camill
Does anyone in the group does not have solution to check its row heading and column heading and paste the data. Sent on my BlackBerry® from Vodafone -Original Message- From: joseph.cam...@gmail.com Date: Fri, 1 Feb 2013 15:54:50 To: Reply-To: joseph.cam...@gmail.com Subject: Re: $$Exce

Re: $$Excel-Macros$$ undo macro

2013-02-02 Thread David Grugeon
Running any macro always clears the list of changes so that after you run the macro you cannot go back and undo changes before it ran, or the changes made by the macro. You are running the macro every time you change the active cell (selection) on the worksheet, so although the macro itself does n

Re: $$Excel-Macros$$ Macro related.

2013-02-02 Thread ashish koul
Try the attachment On Sun, Feb 3, 2013 at 10:04 AM, Ganesh Acharya wrote: > Hi, > > Can someone please help me out with the macro for below thing > > If I saved the different file in one folder for ex : - 15 excel file > > among them if i want to chose the 5 file as per my choice > > is any macr

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member Jan'13

2013-02-02 Thread NOORAIN ANSARI
Congrats Prince babu On Sun, Feb 3, 2013 at 6:03 AM, Bé Trần Văn wrote: > Prince is great, congratulations received honorary awards. > > I really appreciate your knowledge, you have voluntarily help > enthusiasts excel good deal of work. > > Thanks for your generous contribution. > >

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member Jan'13

2013-02-02 Thread Bé Trần Văn
Prince is great, congratulations received honorary awards. I really appreciate your knowledge, you have voluntarily help enthusiasts excel good deal of work. Thanks for your generous contribution. 2013/2/2, Kuldeep Singh : > Cong8...Prince. > > Regards, > Kuldeep Singh > Back Office Executive (M

$$Excel-Macros$$ Xl2000 and HID device using =myserver function

2013-02-02 Thread Cab Boose
Hi I think I may need some macros here as well. On this url there is a description of using HID devices in XL. http://www.aggsoft.com/usb-hid-logger/tutorials/usb-hid-to-excel.htm The description is: "Excel has built-in tools for getting USB HID data. All you have to do is specify the formula

$$Excel-Macros$$ Macro to split a sheet based on column

2013-02-02 Thread Amit Desai (MERU)
Dear All, Do you have a macro, which will split a sheet based on a column. Example one of the column is "city" & there are 4 cities listed in a file. So once we run the macro, it should populate 4 work sheet with the name of city. Best Regards, Amit Desai +91 98672 32534 _

Re: $$Excel-Macros$$ Re: Macro - To split each spreadsheets as a new workbook

2013-02-02 Thread Bé Trần Văn
Thank you Shekhar. Macro works well. 2013/2/2, Shekhar : > Hi Santhosh, > > Please find attached workbook and let me know if it works. > > > Thanks and regards, > Shekhar > > On Friday, 1 February 2013 23:14:56 UTC+5:30, mks...@gmail.com wrote: >> >> Hi Friends, >> >> Need a macros to split each s

Re: $$Excel-Macros$$ Help Required

2013-02-02 Thread >>Excel Beginner<
Hi Sriram, Try this "=SUBSTITUTE(A206,CHAR(160),"")" On Sat, Feb 2, 2013 at 5:31 PM, sriram ji wrote: > Dear Excel Guru, > > I want remove space after the data. Any one can suggest Excel formula for > below attached file. > > Thanks & Regards, > Sriram G > Chennai. > > > > -- > Ar

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member Jan'13

2013-02-02 Thread Kuldeep Singh
Cong8...Prince. Regards, Kuldeep Singh Back Office Executive (MIS) Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Sat

Re: $$Excel-Macros$$ Prince Kumar - Most Helpful Member Jan'13

2013-02-02 Thread rajan verma
Prince kumar dubey .. Rise of cheeta :) On Sat, Feb 2, 2013 at 12:38 AM, Born to Win wrote: > > Congratulation!! > Keep up the gud work. > > > > > > On Fri, Feb 1, 2013 at 11:31 PM, Sam Mathai Chacko wrote: > >> Excellent work again Prince. Keep up the great work. >> >> >> On Sat, Feb 2, 2013 at