All solutions How to CreatePIVOT TABLE Expert Solution – How to Create a Pivot Table

Excel - How to Create a Pivot Table - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

How to create a excel in a cell same as pivot table
Solved by S. B. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 06/02/2018 - 10:01
Excelchat Expert 06/02/2018 - 10:01
Hello, welcome to excel got it pro
Excelchat Expert 06/02/2018 - 10:01
I will assist you regarding your problem.
Excelchat Expert 06/02/2018 - 10:01
So what is it you want actually?
User 06/02/2018 - 10:02
You see when you create a pivot table
User 06/02/2018 - 10:02
you double click on a cell
User 06/02/2018 - 10:02
you get all the details
User 06/02/2018 - 10:02
I want the same thing in a excel cell
Excelchat Expert 06/02/2018 - 10:03
I'm not sure what you are referring to.
User 06/02/2018 - 10:03
I am not able to write anything on excel
User 06/02/2018 - 10:04
if I would be able to show you
Excelchat Expert 06/02/2018 - 10:04
please click on the edit document button.
Excelchat Expert 06/02/2018 - 10:04
Then you will be able to write on it.
User 06/02/2018 - 10:06
Now see
User 06/02/2018 - 10:06
If I want to give detail reason that why is the timing so, I would double click on it
User 06/02/2018 - 10:07
To open the sheet of that particular person on that given day and time
User 06/02/2018 - 10:07
Now did you understand?
Excelchat Expert 06/02/2018 - 10:08
You want to double click on a cell and if there is a sheet assigned to that cell's value, redirect to that cell automatically?
User 06/02/2018 - 10:08
User 06/02/2018 - 10:08
User 06/02/2018 - 10:09
But there is no sheet attached
User 06/02/2018 - 10:09
I want to open a new one for the same
Excelchat Expert 06/02/2018 - 10:09
Okay, it would require excel VBA and currently we don't support VBA problems. I hope you understand that.
User 06/02/2018 - 10:09
User 06/02/2018 - 10:10
Do you have any another way for the same
Excelchat Expert 06/02/2018 - 10:10
I'm sorry for the inconvenience but there is no other way. Formulas cannot perform that functionality.
User 06/02/2018 - 10:10
Alright then thanks
User 06/02/2018 - 10:11
You have magical day
Excelchat Expert 06/02/2018 - 10:11
Thanks for your patience. We hope to launch VBA support soon.
Excelchat Expert 06/02/2018 - 10:11
You too have a great day!

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to
Trusted by people who work at, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc