$$Excel-Macros$$ Re: A Macro needed for the task beow

2009-05-29 Thread Dave Bonallack
Hi Dave, Great name, by the way. Have a look at the attached workbook and see if I have understood you properly... Regards - Dave. Date: Wed, 27 May 2009 15:28:41 -0700 Subject: $$Excel-Macros$$ A Macro needed for the task beow From: davidstev...@gmail.com To:

$$Excel-Macros$$ Re: A Macro needed for the task beow

2009-05-29 Thread Dave
- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Dave Sent: Friday, May 29, 2009 3:58 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: A Macro needed for the task beow Thank you for your macro. I sat down and had to revise my original post

$$Excel-Macros$$ Re: A Macro needed for the task beow

2009-05-28 Thread saurabh singh
hi dave, can the user open both the workbooks(company names and workbook with company name) together or you want to keep company name workbook closed ? On Thu, May 28, 2009 at 8:32 AM, Aindril De aind...@gmail.com wrote: Hi Dave, I guess this will help you.

$$Excel-Macros$$ Re: A Macro needed for the task beow

2009-05-28 Thread Paul Schreiner
I made a couple of assumptions for test purposes. I put a sheet called Company Names in the current sheet and populated it with ID and Company Names. If you put it in another workbook, just change the Thisworkbook.Name to the appropriate name (and the sheet name Company Names to the appropriate

$$Excel-Macros$$ Re: A Macro needed for the task beow

2009-05-28 Thread Dave
Thank you for your macro. I sat down and had to revise my original post. So here goes one more time, please I am just starting to code these macros and its hard to describe a situation. So here is the revised question below. I have a spreadsheet called COMPINFO that has tabs for the 12 months

$$Excel-Macros$$ Re: A Macro needed for the task beow

2009-05-27 Thread Aindril De
Hi Dave, I guess this will help you. http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_21610927.html Please scroll down to the bottom to get the accepted solution. Regards, Andy On Thu, May 28, 2009 at 5:28 AM, Dave davidstev...@gmail.com wrote: