Extracting data from one worksheet to a new list

[Richiejjj]

Hi

I am working with someones worksheet which contains a 'template' they enter data into. The first 'template' is in a2:r30 and is then repeated after a few spaces going down the workbook.

I need to extract some of the cells data so I can analyse it. They are consistent in naming and location as they use the template.

Is there a way I can link to it and drag down the difference in cell numbers to extract the data?

Thanks

 

[Lukasier]

I am not sure what you want to achive. Could you please share some data examples or give a little more explanation?

 

[Richiejjj]

This is a mock up of the worksheet: each box is a 'template' with useful data. I want to extract the useful data into a list format (See below)

List format:

 

[Richiejjj]

any ideas?

 

[Lukasier]

Yep. It can be done with a simple loop. I can write the whole VBA code for you but I would need the exact spaces between cells.

For example
A1: Customer B1: Name of customer
C1: Current

I just need to now how many cells seperates each range.

I could do it without it, but that way will be much easier. Do you prefer VBA or formulas?

 

[Richiejjj]

Initial data points are in:

C3
C4
C5
H3
H4
H5
C8:E17
F8:F16
K4:K18

Then the pattern repeats with C3's equivalent in C23, dropping down 19 rows each time.

Thanks so much

 

[Lukasier]

That does not add up. You said that first range is in a2:r30

 

[Richiejjj]

Sorry im not sure what you mean? The sheet has cell contents in c3:k18, but I only need the items above in the table. Then all the cells drop down 19 rows for each new template, there are an increasing number over time on the worksheet.

 

[Lukasier]

What I mean is this. The cell

Cell you mentioned are not right in my opinion

 

[Richiejjj]

that was an example, i can say c3:k18 if it makes it easier? i dont need all the cells from those locations though - just the ones mentioned?