Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 03-27-2023, 02:05 PM
kilroyscarnival kilroyscarnival is offline Locking several cells and columns into one unit or block Windows 10 Locking several cells and columns into one unit or block Office 2021
Expert
 
Join Date: May 2019
Posts: 362
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

One thought: Do a mail merge to Word.

It depends on how your data will be organized in Excel, but it seems to me that your blocks could Word Tables, and you could import from Excel after sorting your Excel data.

The other thing you might want to consider in Word is having a separate worksheet in your workbook using the =FILTER function, if you have Word 365 or another version that supports the FILTER function. Your second worksheet could populate based on the original table but sorted differently, or filtered on where March fees paid is 0, and so forth. Check out this video for more on what this looks like: https://www.youtube.com/watch?v=Eehk6PC0oGs
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
how to create a block text and when click on the title of block hide and unhide the block labasritas@free.fr Word 4 09-17-2017 01:17 PM
Locking cells melvin1942 Excel 6 07-18-2017 11:42 PM
Locking several cells and columns into one unit or block format changes after locking cells dlquinte Excel 2 04-21-2016 08:31 AM
Locking a signature block adrieller1 Word 1 06-08-2015 05:45 PM
Locking several cells and columns into one unit or block locking word table cells while auto-updating fields fingermouse Word 6 01-14-2015 06:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:22 PM.


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