List of customers with products ordered

Hello,
I have two excel sheets. One is a sheet (called "bike sales") that has different customers in the top row, below there are 4 columns with the 4 different products we sell. In the first column there are the weeknumbers. So for each week I can see what product a certain customer has ordered. (I have added a sample, our normal list is much bigger)
I want to create an orderlist for a certain week. So when I fill in e.g. weeknumber 14 that the sheet creates a list of the customers with the products that they have ordered in that week.

Is it possible? Or do I need to change something on the setup of my sheet?

I had solved it with macro's but that is not working for us internally in the company.

Any help is welcome, or perhaps you can point out a post where they already answered this as I cannot find it.

Regards Chris

You didn't show us exactly how you want the output to look... so a guess:

=HSTACK(TOCOL('bike sales'!B1:T1,3),DROP(WRAPROWS(FILTER('bike sales'!B4:U56,'bike sales'!A4:A56='customer list'!B1),5),,-1))

Alternatively if you want ONLY those customers who palced an order that week:

Formula:

Please Login or Register  to view this content.

NOTE: in both cases, the data range is set as'bike sales'!B4:U56. You need to extend it to column U, to make the data blocks uniformly sized, compensating for the blank column you have introduced (for some reason) between each customer).

Administrative Note:

Welcome to the forum.

Please be aware of our cross-posting rule for the future. Cross-posts are allowed but you MUST provide a link to your posts on other sites.

Please see Forum Rule #7 about cross-posting. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

Thanks.

Thanks for the kind words. You're welcome!

There really is no need. It only took me 5 minutes to provide you with both answers.

However, if you wish, just put a Euro or two in the next charity collector's tin that you see.