Print range

  • Thread starter Thread starter kevcar40
  • Start date Start date
K

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
 
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
Click to expand...

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.
 
Back
Top