When I get in to Tools-DATA-VALIDATION-SOURCE, and I want to introduce a formula two things happen:
1) Paste a formula from other area of the workbook is disabled, so I cannot copy and paste a formula inside this SOURCE window.
2) If I try to modify the very long formula that is currently inside of the source and I use arrows to reach out the right side of the formula that that does show, it starts to show +$X:$Y addresses automatically, damaging the formula currently inside.
En conclusion, the issue is how can I built a very long formula inside the windows Tools DATA VALIDATION SOURCE? Both points, 1 and 2, are very annoying. Can somebody point out my mistake and the right procedure to do it?
Thanks!
1) Paste a formula from other area of the workbook is disabled, so I cannot copy and paste a formula inside this SOURCE window.
2) If I try to modify the very long formula that is currently inside of the source and I use arrows to reach out the right side of the formula that that does show, it starts to show +$X:$Y addresses automatically, damaging the formula currently inside.
En conclusion, the issue is how can I built a very long formula inside the windows Tools DATA VALIDATION SOURCE? Both points, 1 and 2, are very annoying. Can somebody point out my mistake and the right procedure to do it?
Thanks!