Hi guys,

I have a code that copies data between multiple sheets dependant on the value in a certain cell.

All of my sheets hide all of the rows except for any row that has data in it.

the code currently copy and pastes the data into the corresponding sheet depending on the value, HOWEVER it doesn't unhide the row.

Could you guys possibly add this in, so that the row of information that is copied into the new sheet is then switched to "un=hide"? I tried doing a .entirerow.hide=FALSE however this didn't work.

Strangely this "un-hide" function has been working for some of the sheets without the code being in, but it is inconsisstent.

Here is the code:

Please Login or Register  to view this content.