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
Hey
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
Yes
User
06/02/2018 - 10:08
Exactly
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
Ok
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.