did you try on the worksheet i have attached...
Yes as I yet wrote :
According to initial attachment,
a demonstration creating worksheet if needed
i tried to run but it gives back error " invalid keword me".
As you can take a glance to
Me in VBA inner help …
I suggest you must well read and apply the direction I wrote, again :
paste this code to the Data worksheet module
I am ok if we add another sheet permanently FTEs....but another issues like it should give me FTEs numbers "Yes" according to week i select in Summay sheet..Thanks
First, the worksheet don't need to be permanent
with my «
demonstration creating worksheet if needed » ! …
Second, don't you see the light with this beginner level demonstration ?!
As you can already achieve this without any code
just using an Excel basics feature : an advanced filter !
Enter in E4 cell of Summary worksheet the criteria (avoid any typo)
and update the code for the criteria range of
AdvancedFilter method
as you can read in VBA inner help.
Third, as a reminder : the initial post must be crystal clear, accurate &
complete with an attachment reflecting exactly the real workbook.
As the better initial post & attachment, the better & quicker solution …
You changed the need during the thread, maybe it's the reason why
Alan didn't answer anymore.
And on my side, I always first answer to initial post when I have time …