Lucy has attended:
Excel Advanced course
Pivot Table
How can I create new tables (standard table rather than pivot table) using specific text in a column? i.e. a new table in each new sheet showing all of the relevent information based on "county" for example.
RE: Pivot Table
Hello Lucy
Thank you for your question and welcome to the forum.
Can you please explain what you would like to be able to do in a bit more detail - I'm unclear what you are asking.
Thank you.
Kind regards
Amanda
RE: Pivot Table
Dear Lucy
Thank you for attending Excel 2007 Advanced course!! I hope you enjoyed the course and benefited from it.
What I can suggest you to achieve your result is to create a pivot table.
For example you can have the Region( or county in your case) as the Row headings.
May be Qtr as your column headings and if you have products have them on teh right hand side of the Row headings.
Once you have done that you should be able to see the Grand totals.
Normally when you double-click on the region total on the Grand total you should be able to observe that the whole data for that region (or County) gets pasted in a new sheet. You can simply rename that worksheet to the county name.
I think this will be much more simpler than using any other feature!!
If you are not clear about the above instructions then please let me know how your data is arranged and may be I can provide you the instruction according to the data that you have.
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT
