amateur1902
03-10-2008, 02:36 AM
Hello everyone,
I would like to know the following,
What formula do i need to perform the folowing actions.
When i've got column A It happens that my data is misplaced in different rows. I would like to have a formula that searches down column A10 and finds the first filled row. When it finds the first filled row, then it has to select al of the filled columns downwards. This way i can make it possible to cut and paste the row into A10. Now my row always starts from A10.
But i never know where the first column is going to be filled.
I hope this question is clear to you all,
Thanks
http://www.mrexcel.com/forum/images/misc/progress.gif
I would like to know the following,
What formula do i need to perform the folowing actions.
When i've got column A It happens that my data is misplaced in different rows. I would like to have a formula that searches down column A10 and finds the first filled row. When it finds the first filled row, then it has to select al of the filled columns downwards. This way i can make it possible to cut and paste the row into A10. Now my row always starts from A10.
But i never know where the first column is going to be filled.
I hope this question is clear to you all,
Thanks
http://www.mrexcel.com/forum/images/misc/progress.gif