[wordandexcelsofun]

I have a table thats actually a header with a QTY let's say table 1 C4

then i have another table that has some qty as well lets call that one table 2 A1 A2 A3

I want to be able to change the table 1 C4 to any number let's say 55

I want A1 to be C4 x 1
I want A2 to be C4 x 3
I want A3 to be C4 x 6

i tried to bookmark table 1 C4 but i need to change the qty all the time and have it update a1 a2 a3