Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Best way to easily export large amount of data from Excel
I have a spreadsheet that will potentially have cells completed all the way
from A2:IK2. Each row will correspond to a separate person and will need to be able to be viewed easily and seperatly from the rest. What is the best way to set up a chart or other snapshot of all of the data entered on each row? I'd rather not have seperate worksheets for each in this spreadsheet, but rather (and hopefully) have the user just click a few options to open up this snapshot. I'm open to using either Word or PowerPoint, which ever is easiest for the user. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Best way to easily export large amount of data from Excel
Why not have one worksheet which picks up all the data from columns A
to IK, and then a cell on this sheet is used to determine which record to show? For example, user specifies the name of a person, and all the cells for that person are displayed on the sheet. Specify a different name, and a new set of data is displayed. You could do this with VLOOKUP, but probably better to have a single MATCH formula in a helper cell and then use INDEX to bring the other cells across. Hope this helps. Pete On Apr 5, 1:35*pm, hmsawyer wrote: I have a spreadsheet that will potentially have cells completed all the way from A2:IK2. *Each row will correspond to a separate person and will need to be able to be viewed easily and seperatly from the rest. *What is the best way to set up a chart or other snapshot of all of the data entered on each row? *I'd rather not have seperate worksheets for each in this spreadsheet, but rather (and hopefully) have the user just click a few options to open up this snapshot. *I'm open to using either Word or PowerPoint, which ever is easiest for the user. *Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Grouping large amount of data by day-of-week | Excel Discussion (Misc queries) | |||
Excel2007's performance over large amount of data( over 500,000 - 1M) | Excel Discussion (Misc queries) | |||
Changing large amount of Data | Excel Discussion (Misc queries) | |||
how do i save a large amount of data in a worksheet excel 4 | Excel Worksheet Functions | |||
Large amount of data for plotting | Charts and Charting in Excel |