Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-16-2019, 05:43 PM
taholmes160 taholmes160 is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2019
Location: Lester Ohio
Posts: 3
taholmes160 is on a distinguished road
Default Grouping Lines by Project number on a separate page

HI FOlks:



IM working on a time tracking worksheet, for a new freelancing hobby, I want to be able to

(a) select project names from a combo or list box
(b) enter date, start / end times, description of work for each line
(c) on a separate sheet, the entries grouped by project number

IM not sure even what what I am trying to do is called, so I'm not totally sure how to go looking for answers, but I could sure use some pointers or examples
Attached Files
File Type: xlsx Time Tracking Notebook Example.xlsx (10.2 KB, 3 views)
Reply With Quote
  #2  
Old 04-17-2019, 12:42 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 426
ArviLaanemets will become famous soon enough
Default

Instead of grouping, use reports with selectable conditions. A couple of examples are in attached file.

Columns colored grey are meant to be hidden.

Columns on sheets Activities and Projects colored beige are calculated. The color is to warn user not to enter anything.
Attached Files
File Type: xlsx Notebook Example.xlsx (26.9 KB, 3 views)
Reply With Quote
  #3  
Old 04-17-2019, 03:57 AM
taholmes160 taholmes160 is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2019
Location: Lester Ohio
Posts: 3
taholmes160 is on a distinguished road
Default

Cool -- thanks -- I'll tear into this when I get home tonight, but the quick first glance before I leave for work looks awesome

TIM
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to count words in a text, arrange them in separate lines and put the grammar class ? Marcway Word 6 12-14-2018 04:25 PM
Lines separate paragraphs in Print Layout view FKerr Word 5 08-13-2015 11:45 AM
Customizing number of lines per page Word Rox Word 1 04-05-2015 07:28 PM
Separate lines in an Excel cell - possible? If so, how? mtcn Excel 5 12-12-2014 01:06 PM
Number of lines on page problem JamesT Word 0 08-27-2009 04:52 PM


All times are GMT -7. The time now is 09:10 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft