Need help building formula(s) to share data between Sheets IF something is entered certain Column

%3CLINGO-SUB%20id%3D%22lingo-sub-2203071%22%20slang%3D%22en-US%22%3ENeed%20help%20building%20formula(s)%20to%20share%20data%20between%20Sheets%20IF%20something%20is%20entered%20certain%20Column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2203071%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20Sponsor%20Excel%20Workbook%2C%20on%20the%20main%20Sponsors%20is%20where%20we%20would%20ender%20Sponsor%20name%2C%20address%2C%20phone%20%23%20%2C%20email%2C%20and%20where%20and%20how%20much%20they%20would%20like%20to%20donate.%26nbsp%3B%3C%2FP%3E%3CP%3EEach%20Department%20has%20its%20own%20column%2C%20and%20therefore%20it's%20own%20Sheet.%20I%20would%20like%20it%20to%20be%20where%20we%20just%20enter%20all%20information%20on%20the%20Main%20sheet%20and%20if%20an%20amount%20is%20entered%20in%20a%20Department%20column%2C%20then%20all%20that%20Info%20is%20added%20and%20updated%20automatically%20to%20the%20corresponding%20Sheet.%26nbsp%3B%3C%2FP%3E%3CP%3EIE%3A%26nbsp%3BIF%20an%20amount%20is%20entered%20in%20Column%20M%2C%20THEN%20Name%2C%20Address%2C%20Phone%20%23%2C%20Email%2C%20and%20Amount%20donated%20is%20automatically%20added%20to%20the%20corresponding%20Colum%20M%20Worksheet.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20the%20Workbook%20I%20am%20working%20for%20reference.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2203071%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

I have a Sponsor Excel Workbook, on the main Sponsors is where we would ender Sponsor name, address, phone # , email, and where and how much they would like to donate. 

Each Department has its own column, and therefore it's own Sheet. I would like it to be where we just enter all information on the Main sheet and if an amount is entered in a Department column, then all that Info is added and updated automatically to the corresponding Sheet. 

IE: IF an amount is entered in Column M, THEN Name, Address, Phone #, Email, and Amount donated is automatically added to the corresponding Colum M Worksheet. 

 

I have attached the Workbook I am working for reference. 

0 Replies