VBA question

gerryg80

Hi Folks,

Im pretty new to VBA with excel and was wondering if some one could point me in the right direction.

I've got a workbook with 2 sheets, lets say A and B.

B contains customer details
A contains customer orders.

I need to extract details from A based on each custome in B.

Its pretty straight forward im just a bit stuck on how to do it in VBA.

I think the code should look something like the following.

Select into TableB all records in B,
Select into TableA all records in A

For each record in TableB loop,
clear custdetails
Select into custorders all records in A
Where TableB-custID equals tableA->custID.
perform action with custdetails
end loop

any help appreciated.

Thanks

henryporter

I'm not quite following what you're trying to do here - you want to loop through table B to find corresponding records in table A and do what with the results?

gerryg80

henryporter wrote: »

I'm not quite following what you're trying to do here - you want to loop through table B to find corresponding records in table A and do what with the results?

Thanks for the reply

with the results, i intend on creating a new spreadsheet and automatically email the results to the customer. (this bit i have sorted/working).

amen

use a database instead of excel:D

BostonB

amen wrote: »

use a database instead of excel:D

+1

Dunno why you are doing this in Excel.

gerryg80

BostonB wrote: »

+1

Dunno why you are doing this in Excel.

thanks for the advice, ill take it under consideration

BostonB

Maybe you've a reason that you've not mentioned here.