Thank You so much. It is a great start. You are gwonderful!!!. Do i have to keep the source sheet (data) in the same file as the macro? or can i seperate them and put them in different files but in a common folder ?
On Sun, Aug 7, 2011 at 10:29 PM, ashish koul <koul.ash...@gmail.com> wrote: > > try this > > we can make few changes in it > > On Sun, Aug 7, 2011 at 10:47 PM, Sara Lee <lee.sar...@gmail.com> wrote: > >> Hi Ashish >> >> i think you got me wrong. user does not have to enter new values. he will >> select one of the values from the table i sent you. >> >> excel will ask for the volume , the user will enter 1X , then the excel >> should return the rest of row information for 1X in column form ... For >> example corresponding to 1x, the savings could be 100,000, scenario no >> could be 1RR so o/p will be >> >> savings 100000 >> scenario no 1RR >> location hebron ky >> >> am i clear? >> no addition of data, just the excel should extract data from this table >> based on user inupts in the Columnar form like above >> >> >> >> ideal inputs that user is asked to enter---- 1) volume 2) no of >> locations 3) no of consolidations 4) parmeters 5) scenario >> >> outputs--- savings, damage( i will add this and other column in the table) >> >> Excel should be able to extract the output even if the user enters one of >> the inputs and none of the other four.. >> >> please advise >> >> >> On Sun, Aug 7, 2011 at 10:19 AM, ashish koul <koul.ash...@gmail.com>wrote: >> >>> hi try this >>> >>> >>> i have created a user form go to macro run it it will show the user form >>> to enter the value then you can change the >>> column names accordingly also u can ad text boxes , etc. >>> >>> use fill down option to copy the formula from above cell. >>> >>> >>> if you are not able to do it tell me >>> >>> volume - which col a, b , or c,etc >>> >>> location >>> >>> building >>> >>> if any formula need to copy from above cell " for which columns then" >>> >>> >>> >>> >>> >>> On Sun, Aug 7, 2011 at 6:20 PM, Sara Lee <lee.sar...@gmail.com> wrote: >>> >>>> hello >>>> >>>> i have the table in the below format and 4 columns as below in excel >>>> >>>> volume location builds saving >>>> >>>> >>>> >>>> Now i want the user to be prompted for three values.... which will be >>>> volume, location, builds and the excel should give the user corresponding >>>> savings and the o/p should be in *vertical format* with all the inputs. >>>> o/p should be >>>> >>>> volume: [ value entered by user] >>>> location:[ value entered by user] >>>> builds:[ value entered by user] >>>> saving: corresponding value in the table for that row of inputs >>>> >>>> is there a template or a macro or a dashboard... can you pls hlep. >>>> >>>> thanks >>>> >>>> >>>> same thing;;; above is simplified >>>> >>>> >>>> On Sun, Aug 7, 2011 at 8:27 AM, Sara Lee <lee.sar...@gmail.com> wrote: >>>> >>>>> Hi Ashish >>>>> >>>>> I am attaching a table .... which has all the inputs. i need a macro / >>>>> or a template/buttons in excel where >>>>> the user is asked to enter the following input >>>>> >>>>> Scneario NO::::: user will enter either 1 , or 2 or 3 --- any value >>>>> from column A >>>>> >>>>> once he enters the value, the o/p should be following in the below >>>>> format one below the other for whatever scenario he or she enters >>>>> >>>>> volume : excel should get the value from column d >>>>> # of location : similarly from column m >>>>> inbound consolidation: >>>>> parmeters >>>>> savings : >>>>> >>>>> >>>>> there might be other columns that i might be adding to the table, if i >>>>> have to get other columns generated in ouput, could you also please >>>>> instruct >>>>> me on how to do that >>>>> >>>>> Please advise ASAP. >>>>> >>>>> Thanks >>>>> >>>>> >>>>> >>>>> >>>>> On Mon, Aug 1, 2011 at 11:46 PM, <koul.ash...@gmail.com> wrote: >>>>> >>>>>> ** Is it in excel or access send me will let u know >>>>>> >>>>>> Sent on my BlackBerry® from Vodafone >>>>>> ------------------------------ >>>>>> *From: * Sara Lee <lee.sar...@gmail.com> >>>>>> *Date: *Mon, 1 Aug 2011 23:42:42 -0400 >>>>>> *To: *ashish koul<koul.ash...@gmail.com> >>>>>> *Subject: *Re: assistance needed; open to pay a fees >>>>>> >>>>>> Ashish >>>>>> >>>>>> Would you have time within next 9- 10 hrs.... need to link up a couple >>>>>> of tables and need to add a column in the table.....must be half an hour >>>>>> work for you... Shall i send it ? please let me know ASAP >>>>>> >>>>>> On Mon, Aug 1, 2011 at 2:01 AM, ashish koul <koul.ash...@gmail.com>wrote: >>>>>> >>>>>>> Hi Sara , >>>>>>> >>>>>>> Hope you are doing well. >>>>>>> >>>>>>> I am working full time with CSC India. Money is not an issue i would >>>>>>> like to solve any of ur query without any charges.. >>>>>>> >>>>>>> As i work full time with CSC so can't assure you to send the >>>>>>> solution at the same time. >>>>>>> >>>>>>> >>>>>>> Please feel free to send any excel query on my mail will try to solve >>>>>>> asap. >>>>>>> >>>>>>> In case if i will not be having time to solve ur problem will let u >>>>>>> know. >>>>>>> >>>>>>> Regards >>>>>>> >>>>>>> Ashish Koul >>>>>>> >>>>>>> >>>>>>> On Sun, Jul 31, 2011 at 10:42 PM, Sara Lee <lee.sar...@gmail.com>wrote: >>>>>>> >>>>>>>> Hi Ashish >>>>>>>> >>>>>>>> You had replied to my post on a macro. it worked great !!! . >>>>>>>> TThanks. I appreciate it.. i will need some repetitive help on excel >>>>>>>> and >>>>>>>> access and macro. It looks like you are expert on that. Can you help >>>>>>>> me on >>>>>>>> regular basis . I can pay you like $100 per month.... Would you have >>>>>>>> time? >>>>>>>> 90 % of them will be very small scale tasks like we did the one above >>>>>>>> on >>>>>>>> macro. Please advise. Thanks >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> *Regards* >>>>>>> * * >>>>>>> *Ashish Koul* >>>>>>> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> >>>>>>> http://akoul.posterous.com/ >>>>>>> *akoul*.wordpress.com <http://akoul.wordpress.com/> >>>>>>> My Linkedin Profile<http://in.linkedin.com/pub/ashish-koul/10/400/830> >>>>>>> >>>>>>> >>>>>>> P Before printing, think about the environment. >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>> >>> >>> >>> -- >>> *Regards* >>> * * >>> *Ashish Koul* >>> *akoul*.*blogspot*.com <http://akoul.blogspot.com/> >>> http://akoul.posterous.com/ >>> *akoul*.wordpress.com <http://akoul.wordpress.com/> >>> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> >>> >>> >>> P Before printing, think about the environment. >>> >>> >>> >> > > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > http://akoul.posterous.com/ > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > > P Before printing, think about the environment. > > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
