bundy5150's blog

multiple results changing a single cell

Story so far. In a work book have several dozen calculations based on a single cell lets call it C5

In a second workbook I have 5 columns of data with multiple rows derived from the value in C5

Column 1 in the second book has the value C5, How can I utilize the one workbook to use diffent values for subsequent columns in the second workbook

Workbook #1

C5 = 300

b10 = c5 *100
b11 = c5 /3.1415926
b12 = etc

Workbook #2

A1 A2 A3 A4

Syndicate content