Hi guys!
I have to create sheet for Items and i have 90 Items. Is there any way to auto create sheets with item name as per List in Sheet 1.
Hi guys!
I have to create sheet for Items and i have 90 Items. Is there any way to auto create sheets with item name as per List in Sheet 1.
Create pivot table from listed names.
Use that list in Report Filter (named List in this example).
In Option Tab, under Option menu choose Show Report filter pages (See picture)
Untitled.jpg
When prompted choose that List field to create sheets with each name.
If you want and you create some Pivot table fields they will be transfered there too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks