NoSparks - Thanks for your help on this project. One question I need answered. I looked at your coding on the unhide rows etc. and need to know what can be changed to allow rows with data to remain visible in each sheet. Before, I had written formula to transfer relevant data from Procurement Log to either the 23370 or 26062 page, depending on what was selected in column H on the Procurement Log. The data is there, but is not visible until I open the filter. Before, this data was automatically populated and visible when I hit the UPDATE button, but now it does not show anything. Is it something in the code you wrote that I can fix. I need the data on all sheets to be seen without having to open the filter, if there is data on that worksheet.. Someone could bypass info on the respective table if they don't remember to open the filter.

This should be last question to you on this, as the only thing not working on the spreadsheet.

Thanks,