Macro to autofilter and copy data

[mintconsult]

Hi,

Iam trying to record a macro to copy and paste a product code into the autofilter on another tab, return the details for that product and then copy and paste the data onto the original tab with the macro button. It appears that you cannot copy and paste a product code into the autofilter option - is this correct or am i missing something?

I would also like info on how you automatically open an excel file (actually a .dbf) from another location on the network and copy and paste the data into the active workbook.

Any help would be gratefully received,

Thanks, Mark

 

[texasalynn]

Hi,
It appears that you cannot copy and paste a product code into the autofilter option - is this correct or am i missing something?

What do you mean about pasting a product code? Please post a sample of your data and the expected results.