Thread: Find date and copy range based on that date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
avzundert avzundert is offline
external usenet poster
  
Posts: 1
Default Find date and copy range based on that date

Hi,

I'd like to have a VBA routine who does the following:

- Look in a cell what date is stored in it.
- Find that date in a very large column 'A'.
- Select the found date in column 'A' together with the next 5 column
and 5 rows down.
- Copy this range to another location.

Please, respond

--
avzunder
-----------------------------------------------------------------------
avzundert's Profile: http://www.excelforum.com/member.php...fo&userid=1680
View this thread: http://www.excelforum.com/showthread.php?threadid=32017

Reply With QuoteReply With Quote