Hello
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 directly

CodePudding user response:

Dim x as integer


For 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