troubleshooting Question

Find list of consecutive numbers in an excel column

Avatar of KatZoo
KatZooFlag for United States of America asked on
Programming Languages-OtherMicrosoft ExcelVisual Basic Classic
7 Comments1 Solution957 ViewsLast Modified:
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.
Rob Henson
Finance Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros