Forum Discussion
Is it possible to make an entire table based on values of another group of cells?
Budman361530 so yes of course you could use VBA but there are trade-offs.
in the attached I used a helper column to decide which employees to include and then a simple FILTER to show the result and 1 more trick was to use a custom number format to hide all the zeros.
Is this something close to what you want?
Hello. Thank you for the response. Yes, I am working with 365. I am trying to get my program to auto generate table B, whenever you add any data into table A. Example… Let’s say employee 5 worked 8 hrs Monday. Table B would appear automatically on another part of the sheet. Then employee 6 worked a full week. Another table would appear automatically under the first table B… etc. etc…. if you had 19 of the 25 employees table B would show 19 employees. Omitting the six that were not on that job. As I am typing this, I am thinking I could even do this as a Macro that could run after I am finished updating table A. We use table A for payroll tracking. What I am trying to do, is to make basically an invoice reporting program that will show who worked on what job, what days, and what hours each day without having to retype each guy, and their times.
Budman361530 so yes of course you could use VBA but there are trade-offs.
in the attached I used a helper column to decide which employees to include and then a simple FILTER to show the result and 1 more trick was to use a custom number format to hide all the zeros.
Is this something close to what you want?
mtarler Sorry for the slow response... YES! Your workbook appears to be exactly what I am looking for! I need to play with it, then try to understand the Voodoo Formulas that make this happen....lol...