Oct 01 2021 07:16 AM
Oct 01 2021 07:16 AM
I have been searching this and not even sure if it is possible. I have a table of 25 employees. I would like to duplicate the same table but omitting empty ones on another part of the sheet assuming data is entered in a specific group of cells. Example below…
Let’s say I enter data in Employee 5, 7, and 8 where the red circles are. I would like to have it auto populate table 5, 7, and 8 only on another part of the page.
Original table ....
Oct 01 2021 11:19 AM
Oct 01 2021 01:52 PM
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.
Oct 01 2021 03:28 PMSolution
@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?
Oct 06 2021 10:11 AM
@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...
Oct 06 2021 04:14 PM
Why not automate the invoicing instead and skip the automatic table, where you enter the employee number or a translation thereof and the invoice will automatically populate the Line item based on the week number on the date of the invoice?
Jan 15 2022 10:01 PM
Got side tracked on another project, and coming back to this. I don't think your auto invoicing would work for my application, but can you show me an example of what you are talking about? As for the formula you helped me with, it works well. However, how can I get rid of "#N/A in unused fields? I tried to use "If", Xlookup, Iferror... noting seems to work correctly.
Jan 15 2022 10:09 PM
i don't remember helping you with the formula, it was Mr Tarler who did help you
Jan 16 2022 11:01 AM