Hi all,



I'm trying to drag cells down, but that doesn't work.
I need to fill A1 till A100 with info from J1, J4, J7, J10 etc.
How can I get this done in a fast way?

thanks in advance,

I did find a solution;
noticed that when you just type 1, 4, 7, 10,... it can be dragged perfectly
so I typed:
ABCD1, ABCD4, ABCD7, ABCD10 and dragged it down.
Find all: ABCD and replace by =J

But is there any other way?

Hello

yes there is.

If you start in row 1 enter and pull down as needed.
Adapt the J range to your needs

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks a lot

This was a solution I was looking for .
Good thing I even understand how it works so I can adjust it later for other documents

You're welcome.

If you have a moment read this page about the INDEX function . I bet you'll be astonished

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

not astonished, but it is helpful

I know that excel's possiblities are limitless, just don't have the skills myself yet for even basic things like I just asked.

nevertheless, it really is a good article thanks