Home |
Search |
Today's Posts |
#1
|
|||
|
|||
looping question
I've used a few looping type macros until now with no problems. However, I'm completely stumped when i need to get excel to count things for me I have 5 row of data in each column (for example). I want to get all the data to be in column A each set below the next. so I need to refer to B1:B5 and move it to A6:A10. Then repeat to move C1:C5 to A11:A15 etc..etc... I need to move all 5 rows in each case regardless of content (number letter, blank etc..) I just come up against a brick wall when it comes to all this i=i+1 stuff, refering to ranges and telling excel to move the destination cells down column A each step. any help would be gratefully received. It may be me but I thought there would be more info about loops. even the books i have don't cover this sort of looping very comprehensively. Luke -- luke ------------------------------------------------------------------------ luke's Profile: http://www.excelforum.com/member.php...o&userid=21401 View this thread: http://www.excelforum.com/showthread...hreadid=375917 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
formula question | Excel Worksheet Functions | |||
Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Link Question | Excel Worksheet Functions |