LinkBack URL
About LinkBacks
Hi
I have want to create a pivot table with certain information but I want the dates (CellP4 - AP4) to be available as one
name so that it looks tidy and easy to manage. Please find spread attached.
Hi
I have want to create a pivot table with certain information but I want the dates (CellP4 - AP4) to be available as one
name so that it looks tidy and easy to manage. Please find spread attached.
Could you please explain what does the above sentence actually refers to?I want the dates (CellP4 - AP4) to be available as one
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
"dates (CellP4 - AP4) to be available as one name"
My guess is the OP wants to group the dates. I think this thread is more of PT question rather than a VBA.
It means i want the range of data Cell(P4 - AP4) to be selected under one name ie Date or something familiar.
Then why it has been assigned to separate columns?
Because its a leave availability count that must be populated on a daily bases but when I pivot the data I want the data in
one name sort of referencing all the different dates
Copy the dates and Use Paste Special and TRANSPOSE.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks