hello
need some help from the vba gurus.
i believe the task is simple but i may be wrong.
i have over 55 worksheets (in my attached sample, i have shown only 4) district sheets that contain metrics.
in my "consolidate" sheet, based on the drop down in cell D3, i would like for the macro to only consolidate (copy/paste) the data from that particular week. cell D3 = time frame.
this, i would like the macro to only copy/paste and dump the data into the consolidate sheet for all "active" or unhidden sheets for the selected time frame. the time frame are listed in column B of each district worksheet.
please help...thx u in advance.
**i have copy/pasted manually** from one worksheet to show an example in the attached.
Bookmarks