Microsoft Office Forums Grouping Lines by Project number on a separate page

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-16-2019, 05:43 PM
taholmes160 taholmes160 is offline Grouping Lines by Project number on a separate page Windows 10 Grouping Lines by Project number on a separate page Office 2016
Novice
Grouping Lines by Project number on a separate page
 
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 online now Grouping Lines by Project number on a separate page Windows 8 Grouping Lines by Project number on a separate page Office 2016
Expert
 
Join Date: May 2017
Posts: 455
ArviLaanemets will become famous soon enoughArviLaanemets 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 Grouping Lines by Project number on a separate page Windows 10 Grouping Lines by Project number on a separate page Office 2016
Novice
Grouping Lines by Project number on a separate page
 
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
Grouping Lines by Project number on a separate page Lines separate paragraphs in Print Layout view FKerr Word 5 08-13-2015 11:45 AM
Grouping Lines by Project number on a separate page 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 05:28 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft