Excel help please ?

[Snow-Munki]

Hi,

I have a spreadsheet with data in D14 / F14 / H14 / J14 and so on. So all on the same row but just every other column.

What is the best way to get this as a list of data so on a different sheet the data is just in A1 / A2 / A3 / A4

Hope that makes sense ?

Thanks,

 

[Philyaris]

Open the sheet you need to import the data into,go to cell A1 then type this to bring the cell data over:
='[Book2 test.xls]Sheet1'!$A$5

replace book2.xls with the name of the worksheet you are looking up from,
replace sheet1 with the name of the workbook you are looking up from,
replace A$5 with D$14 etc.

The easiest way is have both sheets open,go to cell A1 in second sheet, type the = into the cell then go to first sheet highlight the reqd cell and press enter which will put the info into second sheet.

Phil

 

[Snow-Munki]

thanks, but in the original spreadsheet the data goes on for a while ( like 50 entries ! )

Must be a easy way to 'drag' the data down so it knows to choose D14 / F14 / H14 / J14

 

[Bill Door]

If you set up column A with values from 1 to 50 (or however many you need) in a new sheet, you can enter the below forumula in cell B1 then copy it down as many rows as you require:

=OFFSET(Sheet1'!$D$14,0,2*A3-2,1,1)

You could also do it using transpose, but this would result in every other row of your data being '0'

 

[Sweey]

Nevermind. I've finally understood what you're trying to do and now I have to get back to work

 

[Snow-Munki]

phew ! got it working in the end, thanks for your help !!