i have this small (is it?) problem: in Sheet1 I have in column A,
starting with A3 weekdays names (mon, tue, wed, .., fri, sat, sun),
that means i have 7 rows. In the next 30 columns, on the row 1 I have,
1,2,3 to 30(starting from cell B1, ending AE1). The row 2 contains the
name of weekdays from monday to sunday, repeating till the end of
those 30 columns. In the column AF(starting with AF3) i have numbers,
in order: AF3=2,AF4=1, AF5=0, AF6=2,AF7=1,AF8=0,AF9=1. I have to
distribute these numbers in the blank cells between column A and
column AF random after this example: for row 3 i have to put random
value 1 in every cell that has above it "mon" so that the sum of the
values in the range B3:AE3 to be equal with the value "2" from the
cell AF3. Do you think you can help me?
Thank you!