I am trying to set up an Ullage Chart for my job. I have a Template to use but instead of doing a Data input for 14 columns I want to set up a formula that will work for the whole chart. A partial example would be Column B (input a number in B1) and it subtracts from V1 and gives me the answer in C1. I need a formula that will work for inputting numbers in the following Columns B, E, H, K, N, Q, T Subtracting from Column V1 and it auto inputs into columns C, F, I, L, O, R, U.....

I will be inputting a total of 450 charts and really need to minimize the time spent data inputting into it.



I have a screenshot of the chart but I do not have permission to add attachment

Isn't it as simple as

C1: V1-B1
F1: V1-E1
I1: V1-H1
L1: V1-K1
O1: V1-N1
R1: V1-Q1
U1: V1-T1

> I have a screenshot of the chart but I do not have permission to add attachment

That's going to rather handicap providing an answer. The screen capture would be nice though.