Macro to autofilter and copy data

mintconsult

New Member
Joined
Oct 8, 2009
Messages
5
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
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,447
Messages
5,642,209
Members
417,262
Latest member
andrewd1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top