Print range

[kevcar40]

Hi
I have a worksheet(sheet1) containing data relating to holidays
in column A i have the Week number that corresponds with the date in Column B

What i would like to do is :-
Enter a week number in a Cell ie 6
on the click of a button i would like to print the range the relates to week 6
or any other week i select


thanks

kevin

 

[Don Guillett]

Hi
I have a worksheet(sheet1) containing data relating to holidays
in column A i have the Week number that corresponds with the date in Column B

What i would like to do is :-
Enter a week number in a Cell  ie 6
on the click of a button i would like to print the range the relates to week 6
or any other week i select

thanks

kevin

What you want is a macro that uses
data>filter>autofiter>filter on the weeknum column>print>unfilter. You
could make it completely automatic by using a worksheet_change event
in the sheet module.

 

[kevcar40]

thank you Don
will give it a go now

 

[Don Guillett]

thank you Don
will give it a go now

Let us see your final macro code