Forum Discussion
Storage refill problem
Please check attached file
1. next to the actual data table you shared , i have created a pivot table that lists a summary by item number. if you need to have location clik on that small +(plus) sign next to the name
you can modify the pivot table as you need, but it is a easy to use tool. this should address your printing issue from 600 rows.
2. The name field in the data is a look up from a table in tab "Item Master" you can add more items to this. in sheet 1 you enter item Nr, formula fetches name from this table. you seem to have more than one location for each item, hence you may not be able to fetch Location based on item number.
Hope this help. let me know how it goes.
If you need any further help , i will be glad to help, but please upload a sample excel file with some realistic sample data
Thank you for the fast reply. And thank you for helping me.
Sorry about my explanation, there was alot of google translate involved..
But this worked much better than the things I had in mind and the guys at work loved it.
Thank you so much!