Forum Discussion

UFWOLF's avatar
UFWOLF
Copper Contributor
Aug 14, 2025
Solved

EXCEL FORMULA HELP

I need help. I have attached the sheet I'm working on. I need to pull the data in column B (CLIENT) from the MAIN sheet to the respective individual sheet based on column E (PREPPER). For example, if...
admin
excel
Formulas and Functions
office 365
Office Scripts
training
  • SnowMan55's avatar
    SnowMan55
    Aug 17, 2025

    B1 seems to be the cell that contains the Prepper's name (on the Prepper-specific worksheet).  See the attached workbook for more information and more sample data.  You can use the workbook for experimentation.

UFWOLF's avatar
UFWOLF
Copper Contributor
Aug 15, 2025

Where does the B1 towards the end of the formula correspond with? Thank you!

SnowMan55's avatar
SnowMan55
Bronze Contributor
Aug 17, 2025

B1 seems to be the cell that contains the Prepper's name (on the Prepper-specific worksheet).  See the attached workbook for more information and more sample data.  You can use the workbook for experimentation.

  • UFWOLF's avatar
    UFWOLF
    Copper Contributor
    Aug 22, 2025

    Thank you so much! 

Resources