 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / February 2007Using Subtotaled Data
I have many rows of daily data by employee. For example, at the minimum, there will be 2 rows of data per employee by day for over 5000 employees. I have sorted by employee by day and then executed subtotals by employee and by day. My question: I would like to transfer just the employee's daily total to a new sheet. When I collapse the view from the subtotals and copy, it brings all the data (even the hidden) with it. Is there a way to just keep the data I need from the subtotal function?  SignatureAmy Amy Collapse the data to the subtotals Use F5 (Go To) | Special... | select Visible cells only Ctrl-c (Copy) Choose another sheet Ctrl-v (Paste) Regards Trevor >I have many rows of daily data by employee. For example, at the minimum, > there will be 2 rows of data per employee by day for over 5000 employees. [quoted text clipped - 10 lines] > from > the subtotal function? After you have selected data in the collapsed area, press the F5 key, click on the Special button, and select Visible Cells Only, then Copy > I have many rows of daily data by employee. For example, at the minimum, > there will be 2 rows of data per employee by day for over 5000 employees. I [quoted text clipped - 6 lines] > (even the hidden) with it. Is there a way to just keep the data I need from > the subtotal function? If you are going to do this frequently, and it sounds like you are, you can add an icon to the toolbar to select just the visible cells. Right click on the toolbar, select Customize from the popup menu, then click on the Commands tab. In the left panel select "Edit" In the right panel scroll down until yu see the text "Select Visible Cells" Drag that icon up and drop it ON A TOOLBAR - NOT ON AN EMPTY AREA Close the dialog > I have many rows of daily data by employee. For example, at the minimum, > there will be 2 rows of data per employee by day for over 5000 employees. I [quoted text clipped - 6 lines] > (even the hidden) with it. Is there a way to just keep the data I need from > the subtotal function? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.