Excel Automatically update a row in another sheet -

Excel Automatically update a row in another sheet -

i have excel workbook 3 sheets, sheet1 contains info split remanning 2 sheets.

sheet1 info updated on daily bases hence need split sheet1 , update reming 2 sheets, @ moment re-create each row sheet1 , replace corresponding row in sheet2 or sheet3 new info , each sheet contains same columns: customer_id, customer_name, customer_surname, customer_deposit, total_deposits.

this requires much manual work there way can automatically update row in sheet2 , sheet3 info sheet1.

ps. customer_id never changes maybe there way utilize t update rows....?

if utilize sheet 2 & 3 viewing info can this:

in sheet 2 set formula a1

=(sheet1!a1)

then drag cell left (copying formula) many columns want. drag higlighted cells downwards re-create formula desired cells. same on sheet 3 starting @ point want split sheet 1. update sheet 1 , sheet 2 , 3 automatically update.

excel