Extracting data from consecutive rows into every "nth" row

C

Curtis Cannizz

I have two spreadsheets that I am working with, one that contains weekly data
only and one that contains daily data. I would like a shorter way than copy,
paste, edit to reference each data point that i need to extract. the data
references end up similar to this.
sheet 1 || sheet 2
a1 = '[file]sheet2'!a1
a8 = '[file]sheet2'!a2
a15 = '[file]sheet2'!a3
etc etc

I noticed that =offset() will work in cases of going from sheet 1 to sheet
2, but i am doing the inverse. going from sheet 2 to sheet 1. any ideas of
how to get that to work?
 
S

Stefi

If I understood well your problem, you need to extract every 7th row from
sheet 1 into sheet 2. Enter
=INDIRECT("sheet 1!A"&(ROW()-1)*7+1)
in sheet 2, A1 and fill it down!

Regards,
Stefi

„Curtis Cannizz†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Macro beginner help with making tables 1
Creating a Chart on form from selected data in query. 0
Auto Copy Data from one worksheet to another 1
Array code only works on selected sheet 14
Create if partial match then copy and paste data from one cell to another 1
How to delete ALL cells containing the same data 1
how do i loop thru all the worksheets in 2 files one by one 0

Top