Re: $$Excel-Macros$$ trying to delete cells that match search criteria

2010-06-10 Thread molinari
Err, the link doesn't show up completely in this e-mail. It is the Test_DeleteByNumberName file in the list of uploaded files. On Jun 9, 12:25 pm, molinari wrote: > Thanks a lot, Deepak. > > Here's the > file:http://groups.google.com/group/excel-macros/web/Test_DeleteByNumberNa... > > (I'm und

Re: $$Excel-Macros$$ trying to delete cells that match search criteria

2010-06-09 Thread molinari
Thanks a lot, Deepak. Here's the file: http://groups.google.com/group/excel-macros/web/Test_DeleteByNumberName.xls (I'm under an NDA, so I had to strip it of any meaningful information, but there are report numbers there for illustration). Two of the reports have the same "Number", called "In Fo

Re: $$Excel-Macros$$ trying to delete cells that match search criteria

2010-06-08 Thread Deepak Rai
Hi, Give me a sample file I will solve this for you. Regards, Deepak On Tue, Jun 8, 2010 at 8:35 PM, molinari wrote: > I have a list of reports to be printed out Monday - Friday, where each > worksheet is Monday, Tuesday, Wednesday, Thursday, or Friday. I made > another worksheet to list repo

$$Excel-Macros$$ trying to delete cells that match search criteria

2010-06-08 Thread molinari
I have a list of reports to be printed out Monday - Friday, where each worksheet is Monday, Tuesday, Wednesday, Thursday, or Friday. I made another worksheet to list reports that we no longer need (by their report number). I want the macro to go through the worksheet and delete the rows that corres