Forum Discussion
macro to select lignes
Hey guys please i Want to select those lignes and copy then to another worksheet using macro but the length it's variable any ideas please
There's a little bit of ambiguity in your request. By "lignes" do you mean the column in the worksheet with that heading, OR do you mean lines, all of the lines--four at present--but sometimes more, sometimes fewer?
You might well be able to do this, especially if you're talking lines, with the FILTER function. No macro needed. It does require a relatively new version of Excel.
