First Post, total newbie, will likely need some programming....
Goal, I would like to have a Secondary worksheet that displays rows from a Master Table, ONLY when data conditions are met by cell values within the Master Table? For example: When a Master Table row has incomplete data in certain cells, let's display that record on a Secondary Table with the blank data field that needs to be entered.....
The secondary worksheet then becomes the To-do list as a data entry worksheet for the "blank cells" that need to be entered. When the needed data are entered on the secondary worksheet, the row "disappears" and is no longer displayed (on the secondary worksheet) - because it's "completed" for that particular worksheet. The data however, are always contained on the Master Worksheet (table).
Yes, I understand a database approach would be optimal but only excel data tables can be supported in the workgroup environment where this would be used....thanks for your patience... (I'm posting this in the hopes there might be a generic answer/code to this function, thanks again)
Bookmarks