If these rows are all going to the same output worksheet, in the same order they're found on the input worksheet, there is no need (or point) in processing them one at a time; simply specify the range you're interested in, then cut & paste the lot in one go. It's also far more efficient that way.
Quote:
|
I was just told to create a macro in excel, and this is a very important part of it. I have never used VBA before, nor do I intend to as soon as this is done.
|
Perhaps, then, whoever told you to do this should show you how... Besides, if it's a one-time requirement, it would be far quicker to do manually than it would take for anyone to write, test & debug the code - for which access to a workbook containing actual worksheet names & representative data is vital.