This will be simple - but my brain is on overtime lol. 5 worksheets pulling info from header in "Summary". If there is info in specific cells on Summary then populate with that info. If no info in that cell on Summary, then just leave blank.
Example:
Sheet 2 is "Commercial". I want it to pull the Client, Project Description, Project Number, Equipment, Date, Enquiry Number and Prepared by from the first sheet - "Summary". If I just do an = formula - I get a 0 returned in the field on the Commercial worksheet. I just want it to be blank if there's nothing on the Summary sheet in that cell. I'm making a template at the moment.
Thanks
Bookmarks