automating data/filter /advanced filter copy

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

I have a procedure that I do manually that I would like to automate.
right now I would use the data/filter/advanced filter in excel to reduce
the following (copy to a new location on same sheet):

1
1
1
3
3
3
5
5
5
7
7
7
9
9
9
13
13
13
15
15
15
17
17
17


to:

1
3
5
7
9
13
15
17

Now I wind up copy and pasting this to another worksheet in the same
booklet for other calculations. Any way to automate this (have to do
this a number of times)? (FYI, I will also need to limit it by some
criterion too, but I think the sumproduct that others have shown me here
should do the trick for that portion)

Thanks,

Frank
 
Have you tried to use the macro recorder?

--
Don Guillett
SalesAid Software
(e-mail address removed)
I have a procedure that I do manually that I would like to automate. right now I would use the data/filter/advanced filter in excel to reduce the following (copy to a new location on same sheet):

1
1
1
3

3

3

5
5
5
7
7
7
9
9
9
13
13
13
15
15
15
17
17
17

to:

1
3
5
7
9
13
15
17

Now I wind up copy and pasting this to another worksheet in the same booklet for other calculations. Any way to automate this (have to do this a number of times)? (FYI, I will also need to limit it by some criterion too, but I think the sumproduct that others have shown me here should do the trick for that portion)

Thanks,

Frank
 
No I haven't. I'll look it up and give it a try. I guess it records
all your actions and repeats them?
 
Back
Top