EXCEL Dinamica Tabs

O

OssieMac

Hi,

Don't understand your question. Can you post a sample of the data plus a
sample of what you want it to look like after manipulation.
 
R

Roger Govier

Hi

I am assuming that Dinamica Tabs are Pivot Tables in the UK/US versions of
Excel.

If that is the case, then highlight any Date value on the table>right
click>Group and Show Detail>Group>Months>OK
Note that all items within the Date filed must be true Excel dates and not
text representations of dates, and there must be no blank cells within the
range, otherwise Excel will display a message saying it Cannot Group by that
item.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting and filtering text 0
Countdown macro - display settings 2
Excel file won't save to iCloud on Mac 0
como encuentro un valor de una tabla dinamica con buscarv? 3
Sum multiple worksheets and summary tab that would sum and count by rep name 0
Consolidation Table from Different Excel Tabs with Different Format 1
Sum multiple worksheets and summary tab that would sum and count by rep name 0
How to change date format to 7 working days a week in ms project 2010? 0

Top