Hi guys,
I am working on multiple worksheets in one workbook. Worksheet a, b, c and d.
I have worksheets a, b and c that contain different values on the same column A. Nor matter I make the changes on worksheet a,b and c, the value on worksheet d will change automatically
My question is what format i need to make it works.
For example;
Worksheet a
Column A
row1 $35.00
row2 $45.00
total: 80.00
worksheet b
Column A
row1 $55.00
row1 $20.00
total: 75.00
worksheet c
Column A
row1 $100.00
row2 $10.00
total: 110.00
WORKSHEET D (SUM OF ALL WORKSHEET COLUMN)
worksheet a worksheet b worksheet c
$80.00 $75.00 $1100.00
if i change the value on worksheet a from $55.00 to $40.00 so the total on worksheet a is $60 SO ON WORKSHEET D WILL AUTOMATICALLY CHANGE THE VALUE FROM $80 TO $60. MEANING I DON'T NEED TO WORRY ABOUT THE CHANGE ON THE WORKSHEET A,B, AND C.
ANY IDEA OR ADVICE?
THANK YOU VERY MUCH FOR THOSE WHO TRY TO HELP
GOD BLESS,
I am working on multiple worksheets in one workbook. Worksheet a, b, c and d.
I have worksheets a, b and c that contain different values on the same column A. Nor matter I make the changes on worksheet a,b and c, the value on worksheet d will change automatically
My question is what format i need to make it works.
For example;
Worksheet a
Column A
row1 $35.00
row2 $45.00
total: 80.00
worksheet b
Column A
row1 $55.00
row1 $20.00
total: 75.00
worksheet c
Column A
row1 $100.00
row2 $10.00
total: 110.00
WORKSHEET D (SUM OF ALL WORKSHEET COLUMN)
worksheet a worksheet b worksheet c
$80.00 $75.00 $1100.00
if i change the value on worksheet a from $55.00 to $40.00 so the total on worksheet a is $60 SO ON WORKSHEET D WILL AUTOMATICALLY CHANGE THE VALUE FROM $80 TO $60. MEANING I DON'T NEED TO WORRY ABOUT THE CHANGE ON THE WORKSHEET A,B, AND C.
ANY IDEA OR ADVICE?
THANK YOU VERY MUCH FOR THOSE WHO TRY TO HELP
GOD BLESS,