keithchikumbirike
New Member
- Joined
- Sep 6, 2021
- Messages
- 1
- Office Version
- 2010
- Platform
- Windows
- Web
Good day everyone.
My question is how can I importrange from one sheet to another while expanding and stacking the result (imported range) according to items belonging in each named range.
I have a workbook in which I record my client's orders for chocolate hampers. Each hamper has specific items and for each hamper, there is a named range of the items it contains; these names ranges are in the worksheet titled (Hamper contents list).
In a separate sheet, titled (Client purchases), I record my client's name and his/her hamper of choice and quantity.
The focus of my question is the last worksheet I'll mention, the (Item master list). In this sheet ill like to bring the records from the Client purchases sheet but have the list automatically expanded as the client purchases list is updated.
The result should be the same with the client purchases list except this time instead of just writing the hamper option against the client name, all the contents of the client's hampers are listed so that we can tell which items each client is purchasing.
Below are 2 pictures showing Point A - where I am starting from
and Point B - an example of what I want to achieve.
So for the picture - Point B above, I simply used an indirect function... I don't know how to perpetuate the function along the column to automatically add the next purchased hamper and its list of contents.
Here is an editable link to the Google sheet version of the file:
https://docs.google.com/spreadsheets/d/1waUXTozSpPfoGjv6vvqWRDgjxBeP7I89QMZALWYGt0Q/edit?usp=sharing
I have also attached the spreadsheet file as well.
Many thanks for your help in advance.
My question is how can I importrange from one sheet to another while expanding and stacking the result (imported range) according to items belonging in each named range.
I have a workbook in which I record my client's orders for chocolate hampers. Each hamper has specific items and for each hamper, there is a named range of the items it contains; these names ranges are in the worksheet titled (Hamper contents list).
In a separate sheet, titled (Client purchases), I record my client's name and his/her hamper of choice and quantity.
The focus of my question is the last worksheet I'll mention, the (Item master list). In this sheet ill like to bring the records from the Client purchases sheet but have the list automatically expanded as the client purchases list is updated.
The result should be the same with the client purchases list except this time instead of just writing the hamper option against the client name, all the contents of the client's hampers are listed so that we can tell which items each client is purchasing.
Below are 2 pictures showing Point A - where I am starting from
and Point B - an example of what I want to achieve.
So for the picture - Point B above, I simply used an indirect function... I don't know how to perpetuate the function along the column to automatically add the next purchased hamper and its list of contents.
Here is an editable link to the Google sheet version of the file:
https://docs.google.com/spreadsheets/d/1waUXTozSpPfoGjv6vvqWRDgjxBeP7I89QMZALWYGt0Q/edit?usp=sharing
I have also attached the spreadsheet file as well.
Many thanks for your help in advance.
