Would creating a column in the far left of the raw data called "ID" and have a unique ID for each entry help?
You then could make that ID the "Row labels", and any columns you wanted to have displayed can be put in the "Column Labels".
I might not be understanding you correctly, but I think that should work.
Please click the * icon below if I have helped.
I see what you are saying but the problem with that is the report (that provides the raw data) produces around 2500 rows per report. I want the user to just be able to copy and paste the whole excel sheet into the Data sheet without having to enter anything else. Then have the Results sheet show only certain columns (14-15 of the total 67 columns) and only show the rows with values that match the filters/searches at top.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks