I'm not sure that makes sense but I have a log sheet which I have in a format for print but would also like to tabulate certain cells. To be exact I want

sheet2, cell A1 to = sheet1 C30 then
sheet2, cell A2 to = sheet1 C72
sheet2, cell A3 to = sheet1 C114
sheet2, cell A4 to = sheet1 C156
etc.

Obviously I can do this manually but there's going to be a lot of values that are copied over so it'd take a long time.

Can anyone help here?

TIA

 

look up the INDIRECT and ADDRESS functions, using the two together should make it work. co-worker had to do this same thing a few weeks ago.

 

Where is Excel2Excel? Is that his screen name? PM him; he rocks at Excel.

 

[QUOTE=rustywave,Jul 14 2008, 05:28 AM] look up the INDIRECT and ADDRESS functions, using the two together should make it work.