Unfortunately, that solution does not work. I will not be the user of this
tool. I am building it for someone else. And they will not be able to run SQL.

Thanks for responding though.

"RB Smissaert" wrote:

If this was a database problem, I could simply use an SQL SELECT statement

Well, you can run SQL on sheet ranges! Do a Google and you will be up and
running quickly.
Bear in mind that it is best to close the workbook before running the SQL as
otherwise there can be a memory leak.

RBS


"amitexcel" wrote in message
...
A seemingly simple problem for VBA


Hi,

I am trying to solve the following problem using Excel VBA.

I have two EXCEL worksheets. Each sheet contains data of the following
type.

Account number, amounts for Jan, Feb, March etc

There are about 100 accounts on each worksheet.

There are about 20 accounts that are common to both worksheets.

I have identified which those account numbers are.

Now I need to separate the data (rows) for these account numbers from each
sheet and put it on a third sheet.

So, I need to extract about 20 rows from each sheet and put them on a
third
sheet, based on the account numbers I have identified.

I need to be able to do this repeatedly, when data and account numbers
keep
changing. I have figured out a way to identify these common account
numbers.
Now I need to figure out how to extract them from each sheet using VBA.

If this was a database problem, I could simply use an SQL SELECT
statement.
But I am not so good with VBA.

Thanks to all who respond.


.