This topic has been archived. It cannot be replied.
-
枫下家园 / 电脑用户 / 怎样把Excel中Sheet3中Auto Filter的结果(唯一)自动赋值到Sheet1里Range("A1:H1")?或者怎样在Sheet1里做Sheet3里数据的Auto filter?不用auto filter 用VBA也行,关键是怎样把Sheet3里的数据list, sort 出来。先谢了。
-goodgoodstudying(daydayup);
2003-2-17
{78}
(#1047109@0)
-
Can you elaborate a bit more? an example will help us understand the issue.
-schen(欲语还休);
2003-2-18
(#1047475@0)
-
Thanks. Here comes the examle,
-goodgoodstudying(daydayup);
2003-2-18
{1083}
(#1047937@0)
-
Try out the following code;
-maile(FinchEast);
2003-2-18
{1780}
(#1048051@0)
-
Thank you, Maile. I'm trying on your codes. Will let you know if I figure it out.
-goodgoodstudying(daydayup);
2003-2-18
(#1049126@0)
-
It works great ! However, I still need something that can list and select. List box, combobox, or whatever.I can't ask my boss to input the "product name", "Color", and so on. In case he mis-spells a word...The whole idea is to make the analysis easy.
-goodgoodstudying(daydayup);
2003-2-18
{150}
(#1049174@0)
-
If you can make sure the result will be only 1 row then the rest will be easy. You just copy the second row in sheet3 to sheet1 using part of the code you previously developed.
-schen(欲语还休);
2003-2-19
(#1049505@0)
-
set the auto filters on and let your boss select from the filters. However, the best way is to make a window form for your boss to interact and you use VBA to move data around.
-schen(欲语还休);
2003-2-19
(#1049515@0)
-
That will cost you an arm and a leg.It takes a bit time. I will look into it and post here sometime.
-maile(FinchEast);
2003-2-20
{64}
(#1051981@0)
-
Great thanks! I'm looking forward to your codes. By the way, do you think using database is better than just Excel? I've no experience on Database at all.
-goodgoodstudying(daydayup);
2003-2-20
(#1053086@0)