I have an attached workbook with sheets named All Data, MI, & CF. (Disregard the tab labelled Data; it will ultimately be hidden.) In the sheet named All Items, there is a table column labelled Lab Group ID which offers three drop-down choices: MI, CF, & MI/CF. (MI/CF means that the row applies to both MI and CF.) IF MI is selected, and when the row is filled, that row will copy into the first available row in the MI sheet; if CF is selected, and when that row is filled, that row will copy into the first available row in the CF sheet; if MI/CF is selected, and when that row is filled, that row will copy into the first available row of BOTH MI & CF sheets. It will transfer to the two sheets. Row 1 will have table headers, so that is to be excluded. I shall make the MI & CF sheets into tables, too. The sheet All Data will be updated throughout the year, so there will be no ending row for it.


I have searched numerous online fora and tutorials to no avail. I have minimal VBA knowledge at best. I need the VBA to automatically run, or always run. (The user wouldn’t have to select anything; Excel would automatically do it.)
I have attached the workbook. I’ll elucidate anything further if need be. I’ll buy you tacos! I just really need help. I want to learn the coding, but this was thrown onto me unexpectedly, & now management is hassling me for a result.

Attached Files

Inventory Book (In Revision).xlsx (23.6 KB, 11 views)