Re: $$Excel-Macros$$ reference vlookup sheets

2011-12-23 Thread LearnExcel
THANKS GUYS this works great is there a way to set this up on VBA On Dec 22, 1:07 pm, "Excel_Lover" wrote: > See the attached File > > Rajan. > > > > > > > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > > On Behalf Of dguillett1 > Sent

Re: $$Excel-Macros$$ List all Excel Workbooks

2011-12-23 Thread dguillett1
OK. Respond to this and let me know. Don Guillett SalesAid Software dguille...@gmail.com From: Cab Boose Sent: Friday, December 23, 2011 3:58 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ List all Excel Workbooks Hi Don That would be great. I am on 2000 at the moment but

Re: $$Excel-Macros$$ List all Excel Workbooks

2011-12-23 Thread Cab Boose
Hi Don That would be great. I am on 2000 at the moment but should be upgrading to 2003 in a few days. Regards Charlie Harris On Sat, Dec 24, 2011 at 2:40 AM, dguillett1 wrote: > Charlie, what is your excel version. I have one for xl2003 not updated > for xl2007>, that searches all of m

RE: $$Excel-Macros$$ Repeat Vehicles in Workshops

2011-12-23 Thread Amit Desai (MERU)
This does not give me what I need. I need similar formula in the way I have done in other sheet... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ASHISH BHALARA Sent: 23 December 2011 15:19 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re

Re: $$Excel-Macros$$ List all Excel Workbooks

2011-12-23 Thread dguillett1
Charlie, what is your excel version. I have one for xl2003 not updated for xl2007>, that searches all of my c drive and makes a list of 4000+ files quickly. You could change to F:\ and it will search that one with sub folders files name Date Size Full file Name CabooseAddressVBA1 12