Please see below, I want to achieve when the left mouse button click on the fixed column (such as: A) in any line of cell (such as: A2), are fixed in another cell (such as: F1) in the first line (2) some of the data, and according to edit A good display format,

Please help me understand,
Thank you all!
CodePudding user response:

CodePudding user response:
A formula to brush down and not have to directlyCodePudding user response:
Dim x as integerFor x=1 to n
Range (" f1 ")=range (" a "& amp; X). The text & amp; ", do you have "& amp; Range (" c "& amp; X). The text & amp; "Yuan, consumed" & amp; Range (" d "& amp; X). The text & amp; "Yuan and the remaining" & amp; Range (" e "& amp; X). The text
Next