Copy data with 4 cell interval and copy range of data like vlookup with structured output

Hello everyone,

first i would like to welcome myself as a new member of the forums, I came here because if have been struggling with a project for which i have to sort trough large amounts of data. I tried researching and tackling the problem myself however unfortunately i couldnīt find the solution online, if i missed a link to a topic with similar problems please forgive my ability to search and with a link to that topic i will be able to help myself.

so the first problem is the following.
I want a macro to copy range A1:B1 to A2:B2(I got this far =), then I want the macro to add an X number of cells to its copy range, in this example lets X be 4 cells and then I want it to repeat the process, copy from cell F4:G4 to A3:B3 the next copy sequence will be K8:L8. So the difficulty for me is now: what code to use to let the copy macro automatically skip 4 cells every time it makes its copy routine.

My second problem has to do with data selection.
If it is possible I would like to copy a specific range from a large range. More specifically Iīm looking for a way to first search for a specific word like chairs, then I would like the macro to copy the cell containing the word chairs and the cell next to this. Like A1 (chairs) B1 (20) and after this paste it in a defined place A2:B2 or something. The word Chairs shows up multiple times in my dataset each time with a different amount and I would like to have a list of these amounts. lets say the range is from A1 to AA20

I tried to apply different filters and sorting techniques however due to the very random distribution of the chairs in my dataset i cannot get this to work.

thanks in advance for any help

to copy range A1:B1 to A2:B2

Please Login or Register  to view this content.

for other questions attach please a sample file with data and desired result

I think your notes are not in according with results

Hi, Daydreams,

maybe have a look at this for copying the contents beneath each other:

Please Login or Register  to view this content.

You would need to alter the range to suit for the second (as well as the offset from the starting point):

Please Login or Register  to view this content.

Ciao,
Holger