parallel identical tables in two separate sheets

[atayana]

in excel i have two sheets.
in sheet1 and sheet2 i have the same exact table of data of values and totals.
my question is how can i make it, through functions/formulas or whichever other way, so inputting data in the table in sheet1 will reflect in the same table in sheet2 and visa versa? basically parallel identical tables

assuming that top part is possible, is there a formula i can use to copy table in sheet1 to sheet2 that automatically writes codes to make the table in the two sheets parallel and identical so once again changes to date in either/or sheet is reflected in the other?

i'm new to excel, so excuse me if i made a mess of my question
thanks,
Art

[AliGW]

Welcome to the forum!

When you launch Excel, the splash screen will tell you which version you are using (2003, 2010, 2016, 365, etc) - please enter this information into your profile for the version.

In Excel, you cannot have both a formula and manual entry in a cell - it's one or the other. To do what you want, you will most likely need VBA. Would you like me to move this thread for you to the VBA sesction?

[atayana]

Welcome to the forum!

When you launch Excel, the splash screen will tell you which version you are using (2003, 2010, 2016, 365, etc) - please enter this information into your profile for the version.

In Excel, you cannot have both a formula and manual entry in a cell - it's one or the other. To do what you want, you will most likely need VBA. Would you like me to move this thread for you to the VBA sesction?

I have an older excel, i know that. Is VBA something I need to purchase or is it some sort of an add-on to Excel? And yes, moving to differemt section is fine. Thank you!