I need to use conditional formatting/formulas to import cells of a certain value from multiple worksheets, into a new worksheet. I don't think(?) macro is an option as this is viewed and updated multiple times daily by multiple users/PC's and needs to be live as well as maintain old entries. I would like for ONLY the cells which qualify to be imported, as opposed to showing up blank or as #VALUE, but it seems this might not be possible without a macro. Incorporating an automatic hide would be excellent if this is possible. Sorry, relatively new to this...
I need the cells (membership number, C13) from "New Members" and "Current Members" that contain the qualifier "Service Booked" (J13) to be imported into "Service Tracker" worksheet. I have used the following formula to get the information from "New Members" into "Service Tracker" successfully, but when I try to nest the formula incorporating the "Current Members" worksheet, I'm not successful.
Can someone help me see how to successfully incorporate the second worksheet to this formula/go about this a better way in terms of formula composition, and if possible how to skip importing unneeded cells/import in white font/auto hide unneeded cells in this same formula?
I know this would be easier with a macro, but correct me if I'm wrong, I think I'm stuck with formulas? TIA!
Copy Info From Multiple Worksheets to New Worksheet, No Macro