Convert Pivot table into related multiple dropdown menus
- or -
Post a project like this$$
- Posted:
- Proposals: 4
- Remote
- #1330969
- Expired
Description
Experience Level: Intermediate
Hi,
I have a pivot table with 41,000 rows. It has 5 basic columns. The first is a date, second is a time, then an ID number, followed by another ID number column and finally a fifth column in %.
I know how to create basic dropdown menus using excel's data validation tool, however this has proved too basic to use for the amount of rows I have.
Is this something you can help me with?
Scope:
Create another tab within the same excel sheet which links to the pivot table. The final excel sheet should contain 5 rows, as below, and be able to show information which is being directly taken out of the pivot table.
Date
Entry time
Entry ID number
Exit ID number
V (in %)
I have a pivot table with 41,000 rows. It has 5 basic columns. The first is a date, second is a time, then an ID number, followed by another ID number column and finally a fifth column in %.
I know how to create basic dropdown menus using excel's data validation tool, however this has proved too basic to use for the amount of rows I have.
Is this something you can help me with?
Scope:
Create another tab within the same excel sheet which links to the pivot table. The final excel sheet should contain 5 rows, as below, and be able to show information which is being directly taken out of the pivot table.
Date
Entry time
Entry ID number
Exit ID number
V (in %)
Ala H.
0% (0)Projects Completed
3
Freelancers worked with
2
Projects awarded
50%
Last project
15 Dec 2016
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies