Hi there i hope someone can help!! i have two spreadsheets, one sheet has the info in that needs updating frequently, the second sheet is where i would like the information to go if there is a value in a cell if there is no value then i would like the row to hide. i have two macros which if i manually go in and run each one it works but i would like it to run automatically, is this possible? i must add that the information goes from one sheet to the other but i would blank cells in C column for that particular row to be hidden until a value is added then i would like them to unhide.
Bookmarks