I have a macro which is pulling information from a "primary" tab if the name on the secondary tab appears in the body of the primary tab. A secondary tab is called "K. Warner" so if that name appears on the primary then the info next to the name will be copied to the 2ndary tab. The primary tab has categories like "Arizona Passing" and "Arizona Rushing" ... If the name on the secondary does NOT appear in one of these categories then I would like the name to appear with just zeroes after it on the secondary (even though this info does not appear on the primary). right now info is only pasted if the name appears. a file is attached that should make this more clear. please help!!
Bookmarks