Move Row Up To Top Of Sheet

[willwoll100]

Hi all

I wish to write some code to enable a row that has data inputted into a cell and once the data has been inputted the full row will move back to the top of the sheet.

So as per attached worksheet if you input data into cell B4 (Other data will eventually be pulled into cell range C4:F4) how can I get the full row to move up to row 3? The inputted data will always have to move up to row 3. Also is it possible to lock cells B4, G4 and H4 once the data has been inputted into B4?

I'm new to excel programming although I have done a little C++, I've tried to do a search but have become slighly lost.

Kind Regards

Will

[royUK]

There's no attachment, try zipping it.

[willwoll100]

Sorted it, not the main problem but the attached file.

Cheers

[royUK]

I can't really see what you need to do.

Why have you got all those Serial Numbers entered?

[willwoll100]

The serial numbers are a fixed set of numbers and are there to be tied in with the computer number (product number), the computer number in turn when inputted calls in data in cells C to F.

So when there's a number inputted into the computer column data is drawn into the corresponding cells in columns C to F (this isn't set up yet). The date is then filled in as well as the operators initials and any comments. When all this data is inputted I'd like that row to move up and insert in row 3. So when the next data is inputted in row 5 that row will also be inserted into row 3 and so on.

Basically I'd like to have the latest data inputted to be at the top of the sheet once all the cells have been filled in and if they can all be locked off that would also be a benefit.

If things are still unclear then I'll try and post a pic showing what I mean.

Thanks Again Roy

Will

[royUK]

I think you are making it more difficult by having thiose serial numbers inputted already. How would you want to trigger the change - when the comment is entered? You also need to check all data is entered.

[willwoll100]

Yeah the row would have to move up once the comments column was filled in but now you mention it the guys that are filling them in may not bother with the comments column so this would also have to be flagged up that some data was missing before the file could be either saved or closed.

I'm not sure as to how having a fixed set of sequential numbers in column A would cause any additional problems, I may be being very niave here!!!

Cheers Again

[royUK]

I just think it would be much simpler to have an input row or sheet that would be written to the database on completion, similar to the Contacts Form example here

http://www.excel-it.com/vba_examples.htm