Intern in distress
stagiaire en galère
-
Stagiaire en galère -
Stagiaire en galère -
Hello,
Is there anyone amazing who could explain to me how to create a macro that allows me (from information extracted from a software and pasted into Excel) to perform the sorting or various small manipulations I need to do on this information?
It's not clear, my problem is actually to create a macro that takes information that comes in and is already placed into columns.
Still not clear, damn. Actually, it would be like creating a table where I don't know how many lines there will be with my macro.
I think that's a bit better ^^
If someone can help me, that would be really cool!
Thanks in advance,
Have a good day!
Intern in trouble
Is there anyone amazing who could explain to me how to create a macro that allows me (from information extracted from a software and pasted into Excel) to perform the sorting or various small manipulations I need to do on this information?
It's not clear, my problem is actually to create a macro that takes information that comes in and is already placed into columns.
Still not clear, damn. Actually, it would be like creating a table where I don't know how many lines there will be with my macro.
I think that's a bit better ^^
If someone can help me, that would be really cool!
Thanks in advance,
Have a good day!
Intern in trouble
Related links:
- Pasting while respecting the destination formatting
- Remove extra "spaces" at the beginning of the cell
- Convert a duration to years, months, and days in numbers.
- Text concatenation while preserving the text formatting
- Extend a formula down a column with data in a row
- Conversion de cellule avec le mois en chiffres en mois en lettres
3 answers
-
Hello,
Why would you want a macro to sort?
Excel does it very well on its own...
Otherwise, to perform various small tasks in "automatic mode," do you know the macro recorder?
--
Kind regards,
Franck -
Hi,
If you don't know the size of your array, you need to use a foreach loop. It doesn't require a size parameter. For the rest, I leave you in the hands of people more competent than me ^_^
--
A thank you, a +1, and a resolved always feel good and make you want to help others ;) -
Hi,
Thanks to both of you!
I've done quite a few Excel tutorials and I think it's going to work.
I'm going to try with foreach.
Have a good afternoon!
