Hi all, I have a worksheet (sheet1) that contains multiple columns of data taken from an input form. I am looking for a formula or vba code that will allow the user to enter a week number into cell c3 on sheet2 and return all ID's from sheet1 (column A) that correspond to the inputted week number. These ID's are to be returned in cell C7 down on sheet2.
I am currently using a filter formula however this doesn't allow for sorts to be used on the data.
Thanks for your help in advance.
Sheet1
Sheet2
I am currently using a filter formula however this doesn't allow for sorts to be used on the data.
Thanks for your help in advance.
Sheet1
Sheet2