Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 12-05-2019, 05:19 AM
ArviLaanemets ArviLaanemets is offline Generate Excel data list from complex matrix Windows 8 Generate Excel data list from complex matrix Office 2016
Expert
 
Join Date: May 2017
Posts: 960
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Design your app as database. This way you don't need to design it anew whenever new courses, majors, or major levels are added. And you also will have the possibility to add other reports without any base design changes in future.


Attached is an example. There are some hidden columns on sheets, and a hidden sheet needed to get Tables on report sheet without row gaps.


When you need a table like in your example, then this will be another report.
Attached Files
File Type: xlsx CourseSelection.xlsx (44.4 KB, 11 views)
Reply With Quote
 

Tags
list view, matrix



Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto populate form (data from excel) in Word based on drop down list selection (data from excel) wvlls Word VBA 1 03-22-2019 02:29 PM
Generate Excel data list from complex matrix Extract a matrix of another matrix defined by selected rows marked with an x Tommy7571 Excel 19 03-20-2019 08:39 AM
VBA or Macros to generate List asante_za Excel Programming 1 09-29-2017 09:51 AM
Generate Excel data list from complex matrix 2nd matrix gives a resut that doesnīt match numbers in the 1st matrix Diver Excel 25 02-22-2017 04:39 PM
Generate Excel data list from complex matrix trasforming word list in Excel matrix abury Word VBA 1 02-15-2016 03:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:58 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