$$Excel-Macros$$ Vlookup on a Data Sort range help needed

2010-05-11 Thread Zilla
What I would like is under column "D" to be able to select one store number at a time from the data sort filter. What I would like to do is have a VLookUp in cell “I8” for the range of store numbers in column "D" and have the store name appear depending on what single store is shown while using th

$$Excel-Macros$$ Help with transposing data for graph

2010-01-17 Thread Zilla
I am trying to create a graph for each store in my data sheet. I have a data sheet with a list of stores that lists the quantity that was ordered by each store for the month of December. Not all stores placed ordered on the same dates. What I would like to do is take the data from store line and c

Re: $$Excel-Macros$$ Export from word to excel

2010-01-09 Thread Zilla
I like the the first excel file you created that just imported the numbers beside (M). Is there a way to alter the excel spreadsheet to import everything from a word doc you point at and not just what is beside (M)? This would be very helpful for me. On Jan 6, 8:40 pm, Alokeshwar Tiwary wrote: >

Re: $$Excel-Macros$$ VBA Code for Locking/Unlocking excel sheet using password input form

2009-12-13 Thread Zilla
You have to be a premium member to dload that file. On Dec 11, 8:42 pm, Nandkumar kakvipure wrote: > Try Dis one > > http://rapidshare.com/files/106336650/LostPassword.Passware.Kit.Enter... > > On Fri, Dec 11, 2009 at 8:02 PM, Abhishek Jain wrote: > > > Punit, > > > What's the VBA password of you

Re: $$Excel-Macros$$ Stumped with count if's

2009-12-06 Thread Zilla
yes it does thanks for the help On Dec 5, 11:02 am, Dilip Pandey wrote: > Dear Zilla, > > Attached file would be help you to get the logics of IFs. > > Let me know if it solves your query. > > Best Regards, > -- > DILIP KUMAR PANDEY >    MBA-HR,B COM(Hons.),BCA >

$$Excel-Macros$$ Stumped with count if's

2009-11-30 Thread Zilla
I am stumped with this one I have to do for work. I have been trying to achieve the following without any luck. This is what I would like. In cell W7 If cells K7 M7 O7 = the letter d,a,n, or b count as 1 In cell L7 I would like if d a n appear in k7 show as 7 if the letter b is in K7 show as 7.5