Using macros to subset master database

Nathalie · May 23rd, 2002, 02:17 PM

I am using the autofilter to subset my master database, except that certain columns are no longer needed in subset. I am not allowed to delete the columns while filter is on and if i try to hide them, they still show up when i copy and paste relevant info! Any suggestions, am i approaching this wrong?
thanks

wob · May 23rd, 2002, 02:23 PM

this might not be what you need but would sorting the data (and use options, sort left to right) help at all?

lenze · May 23rd, 2002, 02:29 PM

You might try using MS Query. You can specify which columns you retrieve and limit the data rows by using criteria and parameters. I suggest working without the wizard for more flexibility. Here is a link that might be useful.

http://tushar-mehta.com/index.html?h...cel/intro.html

[ This Message was edited by: lenze on 2002-05-23 13:30 ]

Nathalie · May 24th, 2002, 06:04 AM

Thanks for the suggestions, lenze once again u have helped me out! I'll try using a query.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 02:17 PM	#1
Nathalie New Member Join Date: May 2002 Posts: 48	I am using the autofilter to subset my master database, except that certain columns are no longer needed in subset. I am not allowed to delete the columns while filter is on and if i try to hide them, they still show up when i copy and paste relevant info! Any suggestions, am i approaching this wrong? thanks

May 23rd, 2002, 02:23 PM	#2
wob Board Regular Join Date: May 2002 Location: Milton Keynes - UK Posts: 95	this might not be what you need but would sorting the data (and use options, sort left to right) help at all?

May 23rd, 2002, 02:29 PM	#3
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	You might try using MS Query. You can specify which columns you retrieve and limit the data rows by using criteria and parameters. I suggest working without the wizard for more flexibility. Here is a link that might be useful. http://tushar-mehta.com/index.html?h...cel/intro.html [ This Message was edited by: lenze on 2002-05-23 13:30 ]

May 24th, 2002, 06:04 AM	#4
Nathalie New Member Join Date: May 2002 Posts: 48	Thanks for the suggestions, lenze once again u have helped me out! I'll try using a query.