clueless about do the same calculation across 600 rows

**seraphin** · 09-15-2019, 11:16 PM

[edit] please help delete this post as a solution has been found.

I need to do the following ratio calculation

row 1: heading
row 2: b2/$b$2, c2/$b$2, d2/$b$2 ..... wu2/$b$2
row 3: b3/$b$3, c3/$b$3, d3/$b$3 ..... wu3/$b$3
.....

row 600: b600/$b$600, c600/$b$600, .... wu600/$b$600

It seems that I must use VBA as any variation of fixing reference cell (e.g. $b$3, b$3, $b3 ) fail to run correctly across all 600 rows.

Google VBA codes online to do this did not find much.

Any help ?
(see attachment for the actual data)

**Kenneth Hobson** · 09-15-2019, 11:41 PM

I guess for b2 you want =b2/$b$2?

It is a simple matter to reference it on another sheet. Once you get the a few entered, a copy/paste or drag and fill will do it all. I would set calculation to manual until you get it all entered.

Otherwise, I guess you want vba to overwrite B2:WU600?