How to automate a table?
Hello!
I'm not even sure if my message title is correct but let me try to explain. I have a raw data that needs to be put in a specific table format (please see attached file).
I'm wondering if there's a way to fill in the table by just putting one specific column data and it will automatically complete the table?
For example: Can I just put in a corresponding Batch Code?
Screen Shot 2023-02-13 at 6.46.17 PM.png
Perhaps if you show your expected outcome, it would help us to understand what you want? Your 2 tables are both identical (and both empty)
Also, please dont include links to files we have no access to.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you. I've updated the attached file with the expected results. Some batch code have more data (with Quality check 1, quality check return 1... etc.).
Using your 2nd table
For the Empl....
D19=INDEX('Raw data'!$F$8:$AB$20,MATCH(Chart!$D$17,'Raw data'!$A$8:$A$20,0),MATCH(Chart!B19,'Raw data'!$F$7:$AB$7,0))
copied down
Errors noted
Orange in your table has a trailing space - remove that - and check for others, too
Lemon and Banana doesnt have Employee #
The 2nd last category (Quality return check 2) has words swapped around
This formula works if each sub-table has teh same amount of columns (maybe add a dummy column where needed to make the amount equal)....
D26=INDEX('Raw data'!$B$8:$AV$20,MATCH(Chart!$D$17,'Raw data'!$A$8:$A$20,0),MATCH(D$24,'Raw data'!$B$6:$AV$6,0)-1+MATCH($B26,'Raw data'!$F$7:$J$7,0))
copied down and across
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks