I attached here 1overall data, here i want to spread sheets separately by region wise, i have attached sample output in 2nd sheet and 3rd sheet, like wise i want seperate excel sheet from the attached excel.
I attached here 1overall data, here i want to spread sheets separately by region wise, i have attached sample output in 2nd sheet and 3rd sheet, like wise i want seperate excel sheet from the attached excel.
Try
A2Formula:Please Login or Register to view this content.
Paste the same formula in other sheets as well
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
See attached file, where I have set this up for you.
All you need to do is to copy one of the existing sheets (e.g. Baksa) by CTRL-dragging the tab, then rename the new sheet to whichever region you like.
It might be better to just have one sheet and to have a drop-down in cell W1 where you can select the region of interest.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks