Extracting dynamic data

[inky]

is the following possible with vba?

i'm performing a cashflow calculation for close to 300 products. the elements used in the calculation vary between products so i would like to have a table detailing the nature of all items required for each product (table 1). once this is calculated, i need to apply a tax rate which again is different depending on the product (table 2). is it possible to extract data by cross-referencing tables 1 and table 2 in a calculation?

also, i need to save year-to-date data. can a worksheet be used to store this data, such that the next months results are added to the next available row in the worksheet and totalled?

thanks in advance

[Greg M]

Hi Inky,

Neither requirement sounds like a major problem to implement. Can you give us some more details & if possible a sample workbook?

Regards,

Greg M

[inky]

we haven't created the workbooks yet. still developing the calculations.

we also want to be able to extract data "ad-hoc" eg display just the product information for one product or a group of related products based on defined groupings etc. is this possible?