Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old Yesterday, 12:32 AM
ArviLaanemets ArviLaanemets is offline Due Date Summary based on multi-sheet spreadsheet Windows 8 Due Date Summary based on multi-sheet spreadsheet Office 2016
Expert
 
Join Date: May 2017
Posts: 545
ArviLaanemets is a jewel in the roughArviLaanemets is a jewel in the roughArviLaanemets is a jewel in the rough
Default

Moving columns around is really simple when using defined Tables!

Select whole column (click on column label at top of page, eg. G for DueDate column);
Holding down Shift key, place mouse cursor over either of column left or right borders (crossed arrows are displayed), press down left key, and drag the column to new location (formula(s) in moved column remain unchanged);
Release mouse key and Shift key.



To add new column (e.g. SentForReview), simply insert a new column into wanted position, and then edit column header. After that:
1. you can enter formula into new column, when this is meant for this column;
2. you can enter values into new column, when this is meant for this column;
3. you can edit existing formulas in other columns to take into account added column.

I moved DueDate and added SentForReview columns. And I edited formulas in other columns so they can cope with empty rows in Table.
Attached Files
File Type: xlsx DueDate-test (1).xlsx (32.5 KB, 2 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summriez all worksheet in summary work sheet MILADREZAEE Excel 7 05-21-2018 05:01 AM
How to calculate summary progress date time on summary tasks Logotip Project 0 05-16-2017 01:18 AM
Due Date Summary based on multi-sheet spreadsheet Creating a dynamic summary sheet FenelonPaul Excel 5 09-23-2015 07:11 AM
Due Date Summary based on multi-sheet spreadsheet Can a Data Source be one sheet in a multi-sheet Workbook nfotx Mail Merge 1 07-01-2015 12:55 AM
Due Date Summary based on multi-sheet spreadsheet Construct a summary sheet by summing up from one or more than one sheet. PRADEEPB270 Excel 1 11-04-2011 03:46 AM


All times are GMT -7. The time now is 11:03 AM.


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