Thread
:
Find Variable
View Single Post
#
7
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
Find Variable
Why don't you post your code for comments.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"daisy2008" wrote in message
...
Ok I did as you said but it just keeps doing it for the same month I can't
change it. Do I have to record one of those for each month and just have
a
whole bunch of text boxes to click on for each month?
"Don Guillett" wrote:
The macro can be taught to do just that. It can even ask for the month
instead of putting in a cell.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"daisy2008" wrote in message
...
so I would have to do that every time I want to change the month? and
for
those using this worksheet that don't know excel that well? I was
hoping
for
something more simple I thought there would be an easier way just to
state
in
a cell what month, click a search botton and it would bring up the
report.
Is there no easier way?
Daisy
"Gary''s Student" wrote:
Use AutoFilter.
Switch-on AutoFilter on column D and select December
Copy the visible rows and paste them to Sheet3
If you want a macro to do this, just use the Recorder.
--
Gary''s Student - gsnu200821
"daisy2008" wrote:
Hello,
I really need help with this one. I need to find a variable that
will
be in
D11 sheet1 find it in sheet2 column D copy all the rows and paste it
in
sheet3.
Ex:
December in the value in cell D11
find December in column d copy all of the rows
Number Name order date Month received order number
101085 test 11/14/08 December 12
102086 joe 11/20/08 December 15
205684 Ann 10/25/08 November 9
100852 Dave 11/2/08 December 11
then paste the entire rows to sheet3 A3
Number Name order date Month received order number
101085 test 11/14/08 December 12
102086 joe 11/20/08 December 15
100852 Dave 11/2/08 December 11
Can this be done?
Thanks Daisy :)
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett