Forum Discussion
Albert Scudder
Jun 11, 2017Copper Contributor
Transfering data from one tab to anoter
Hello Everyone I have data in a Excel Worksheet that I populate into another tab of the same worksheet to create a graph of the data. I have a large number of data points in the tab so I cut and pas...
- Jun 13, 2017
Hello Everyone
With a little help from my son I figured out a solution. Utilizing the data tab and Data Validation tool. I named the cell and then I allow the List added the source column and created a drop down of that column.
Wyn Hopkins
Jun 12, 2017MVP
Hi Albert, can you clarify what you mean by slide show?
Albert Scudder
Jun 12, 2017Copper Contributor
I would like to go down the list of data in Tab 1 as quickly as possible. If I could go through the list with one click
- SergeiBaklanJun 13, 2017Diamond Contributor
If the only purpose of moving data from one tab to another is to build the graph on subset of data, why don't build it on full set and use any kind of filtering (e.g. slicers) to show proper graphs?
- Albert ScudderJun 13, 2017Copper ContributorThe data comes from an Excel Add-on so I only truly need to move the ticker to Tab 2. So if there was a way to move the tickers from Tab one to Tab two without either cutting or pasting or printing the list
- Wyn HopkinsJun 13, 2017MVPOr a Pivot chart?
- Albert ScudderJun 13, 2017Copper ContributorThe data comes from an Excel Add-on so I only truly need to move the ticker to Tab 2. So if there was a way to move the tickers from Tab one to Tab two without either cutting or pasting or printing the list