Automate IE Or Chrome With Sendkeys?

[Lewzerrrr]

Hi,

I have a list of data, for short's sake A1:A10, what I've been previously doing is the following combination, CTRL C, ALT TAB, CTRL V, ALT TAB, DOWN ARROW, CTRL C, ALT TAB, CTRL T, CTRL V, ALT TAB, DOWN ARROW, CTRL C, ALT TAB, CTRL T, CTRL V.. this can go on for over 100 rows which is quite mundane.

I've tried to use sendkeys with Chrome but failing plentiful

Is it possible to run a loop where it will open a new IE window, run through a list of 10 rows, pasting each value into a new tab and then repeating into a new IE window and next 10 rows?

Thanks,