Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Drag and Drop won't let me go up in tens?!
In order to work out exactly where I'm going wrong, I'm going to explain
exactly what I'm doing so somebody might be able to help me! Sorry if it seems boring, but I need to work this out to help my 3rd year university project! I have data in sheet 4 and in every tenth row, I have data that I want to put into sheet 5. In Sheet 5 A5 (the first cell I want to write anything in), I have written =Sheet4!40 . The row below that, I have then written =Sheet4!50 . I want the formula to then go up in tens, as in =Sheet4!70 , =Sheet4!80 but instead it always puts the wrong thing in. I have written the correct formula up to A13 so that I have ten bits of correct data, but this hasn't helped. Please help! I need to work this out ASAP! Thank you. Georgyxx |
#2
|
|||
|
|||
Georgy,
In A5 on sheet 5, use =INDIRECT("Sheet4!A"&ROW(A4)*10) and copy down -- HTH RP (remove nothere from the email address if mailing direct) "Georgyneedshelp" wrote in message ... In order to work out exactly where I'm going wrong, I'm going to explain exactly what I'm doing so somebody might be able to help me! Sorry if it seems boring, but I need to work this out to help my 3rd year university project! I have data in sheet 4 and in every tenth row, I have data that I want to put into sheet 5. In Sheet 5 A5 (the first cell I want to write anything in), I have written =Sheet4!40 . The row below that, I have then written =Sheet4!50 . I want the formula to then go up in tens, as in =Sheet4!70 , =Sheet4!80 but instead it always puts the wrong thing in. I have written the correct formula up to A13 so that I have ten bits of correct data, but this hasn't helped. Please help! I need to work this out ASAP! Thank you. Georgyxx |
#3
|
|||
|
|||
On row 5 the formula =INDIRECT("Sheet1!B"&((ROW()-4)*10)) will access cell B10 from Sheet1, and each 10th row as you drag down. Georgyneedshelp Wrote: In order to work out exactly where I'm going wrong, I'm going to explain exactly what I'm doing so somebody might be able to help me! Sorry if it seems boring, but I need to work this out to help my 3rd year university project! I have data in sheet 4 and in every tenth row, I have data that I want to put into sheet 5. In Sheet 5 A5 (the first cell I want to write anything in), I have written =Sheet4!40 . The row below that, I have then written =Sheet4!50 . I want the formula to then go up in tens, as in =Sheet4!70 , =Sheet4!80 but instead it always puts the wrong thing in. I have written the correct formula up to A13 so that I have ten bits of correct data, but this hasn't helped. Thank you. Georgyxx -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=476184 |
#4
|
|||
|
|||
THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! You are angels. Will be using you
again soon! "Georgyneedshelp" wrote: In order to work out exactly where I'm going wrong, I'm going to explain exactly what I'm doing so somebody might be able to help me! Sorry if it seems boring, but I need to work this out to help my 3rd year university project! I have data in sheet 4 and in every tenth row, I have data that I want to put into sheet 5. In Sheet 5 A5 (the first cell I want to write anything in), I have written =Sheet4!40 . The row below that, I have then written =Sheet4!50 . I want the formula to then go up in tens, as in =Sheet4!70 , =Sheet4!80 but instead it always puts the wrong thing in. I have written the correct formula up to A13 so that I have ten bits of correct data, but this hasn't helped. Please help! I need to work this out ASAP! Thank you. Georgyxx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disabling Drag And Drop Referencing | New Users to Excel | |||
Prevent Drag & Drop | Excel Discussion (Misc queries) | |||
Help please simple drop and drag I can't make work | Excel Worksheet Functions | |||
cell drop and drag | Excel Worksheet Functions | |||
drag and drop to get a lot of wordarts? | Excel Discussion (Misc queries) |