Dears ,
I need your help please if in this issue, I am currently working in production planning , I have the worksheet example attached, the sheet shows you a weekly calendar, i am finding an issue in having the information to be referenced in a tabular view where i can use this information as a pivot table, if you open the work sheet, you will find week numbers of every month , squared slots, manual input of information such as customer name, product name, batch size,etc.(information that i use to plan production. as mentioned before and shown in my attachment, i have mutiple lines and i need the sheet name to be also reflected so i can have relevant informationo
please help me out in this .
Bookmarks