$$Excel-Macros$$ Find value in Active Cell in another sheet(s) & delete

2011-06-03 Thread sswcharlie
Hi Part of a another code - I want to find the value(text) in active cell (value changes often) in workbook (except current WS and one other worksheet 'home") and delete. Could be more than one instance. Thanks Charlie -- --

$$Excel-Macros$$ Hyperlink for Sheet in a Cell - changes

2011-06-03 Thread sswcharlie
Hi Is it possible to have say a cell with hyperlink to sheet (that is ok) but also if the name in that cell changes it stays as a hyperlink to a another sheet. eg if A1 has 'Sheet2' hyperlinked, and then A1 changes to 'sheet3' will the hyperlink change to sheet 3 ? Thanks Charlie -- --

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - May'11

2011-06-03 Thread jmothilal
Congratulations! , J.Mothilal, Vellore On Fri, Jun 3, 2011 at 4:04 PM, SANJAY SONI wrote: > Dear Ashish G, > > Congratulations on a great success. It is really appreciable for winning > consecutive 6 times as "MOST HELPFUL MEMBER". > > * > Best Regards, > * > *Sanjay ** > * > ** > *From:* Ayus

Re: $$Excel-Macros$$ Formula Needed to Extract Data

2011-06-03 Thread ashish koul
see if it helps On Wed, Jun 1, 2011 at 7:07 PM, John A. Smith wrote: > Need help please extracting specific data from an Excel spreadsheet into an > Excel report. > > The arrangement of the data isn't always in the same order as shown in the > attached sample. > > Thank you again for your kind he

Re: $$Excel-Macros$$ Excel File icon changed.. wanted to retrive

2011-06-03 Thread Kiran Kancharla
Hi Anil, Follow the below steps. Open the file click the below following steps File > Properties -> Summary -> and Uncheck the "Save Preview Picture" Regards, Kiran On Fri, Jun 3, 2011 at 3:18 PM, Anil Bhange < anil.bha...@tatacommunications.com> wrote: > Hi members, > > > > My

Re: $$Excel-Macros$$ Dynamic file name and sum

2011-06-03 Thread Skanda
Vasant, I will try this out and let you know. Thanks for the quick around. On Fri, Jun 3, 2011 at 1:12 AM, Vasant wrote: > There are many approaches of doing it. > > I have listed two here.. > > Pass the month and year as parameters to the - 'UpdateFormula' subroutine. > You can pass the para

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - May'11

2011-06-03 Thread Kal xcel
once again congratulation ashish...keep it up Kalyan On Fri, Jun 3, 2011 at 3:54 PM, NOORAIN ANSARI wrote: > Congrate Sir ji...lage raho... > > > On Thu, Jun 2, 2011 at 10:29 PM, Ayush Jain wrote: > >> Hello Everyone, >> >> Ashish Koul has been selected as 'Most Helpful Member' for the

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - May'11

2011-06-03 Thread SANJAY SONI
Dear Ashish G,   Congratulations on a great success. It is really appreciable for winning consecutive 6 times as "MOST HELPFUL MEMBER". Sanjay From: Ayush Jain To: excel-macros Sent: Thursday, 2 June 2011 10:29 PM Subject: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - May'11 Hello Ev

$$Excel-Macros$$ Excel File icon changed.. wanted to retrive

2011-06-03 Thread Anil Bhange
Hi members, My excel file icon got changed and shows the internal data instead of standard excel image [cid:image001.jpg@01CC2201.6DA84E00] [cid:image002.jpg@01CC2201.6DA84E00] I wanted the standard excel image as my file view and not th

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - May'11

2011-06-03 Thread Manoj kumar
Congrats Ashish, keep it up. Best, Manoj Kumar On Thu, Jun 2, 2011 at 10:29 PM, Ayush Jain wrote: > Hello Everyone, > > Ashish Koul has been selected as 'Most Helpful Member' for the month of > May'11 > He has posted 67 posts in May 2011 and helped many people through his > expertise. He has

Re: $$Excel-Macros$$ Dynamic file name and sum

2011-06-03 Thread Vasant
There are many approaches of doing it. I have listed two here.. Pass the month and year as parameters to the - 'UpdateFormula' subroutine. You can pass the parameters either through a worksheet change event or a userform. 'Trigger on worksheet change event in Memo sheet (all the workbooks has t

Re: $$Excel-Macros$$ Ashish Koul : Most Helpful Member - May'11

2011-06-03 Thread NOORAIN ANSARI
Congrate Sir ji...lage raho... On Thu, Jun 2, 2011 at 10:29 PM, Ayush Jain wrote: > Hello Everyone, > > Ashish Koul has been selected as 'Most Helpful Member' for the month of > May'11 > He has posted 67 posts in May 2011 and helped many people through his > expertise. He has been consisten