View original (French)

Intern in distress

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

3 réponses

Réponse 1 / 3
pijaku Posted messages 13513 Registration date   Status Modérateur Last intervention   2 771
 
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
0
Réponse 2 / 3
laurent74000 Posted messages 613 Status Membre 81
 
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 ;)
0
Réponse 3 / 3
Stagiaire en galère
 
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!
0