I'm new to VBA and need your help. I am working with two worksheets. The first worksheet has a list of consecutive numbers from 1 to 40,000 in column A. Columns B through AA have data associated with the numbers in column A. The numbers in col. A identify samples we test in a lab. After a day's worth of samples has been tested, a blank row is inserted into this worksheet so that in looking for these consecutive numbers, a blank cell may be encountered. From the second worksheet (which becomes a report for a client), I have the beginning ($Q$2) and ending ($S$2) lab numbers that represent the samples submitted by a single client. To prepare the report for that client, I need to find that list of consecutive lab numbers (represented by the beginning and ending lab numbers) in col A of the 1st worksheet and copy into the 2nd worksheet associated data from some of the other columns in the 1st worksheet (for example: the data in worksheet 1, col C must be copied into worksheet2 col B). I have no code because nothing I have tried or researched has worked. This is excel 2007 with an XP Professional 2002 operating system.
Your assistance is appreciated.
If possible, could you attached a sample file?