Archive row content to different worksheet when certain cell column is changed

Hello all,

Firstly, thanks for viewing my post.

My problem:
I have a excel workbook which consists of 3 Worksheets.
1st = master document,
2nd = where I house my text-box lists,
3rd = the Archive tab.

Currently I manually archive a row from worksheet 1 to the archive (worksheet 3) when I make a change to the version column (Column B in the Master Document worksheet). The archive tab contains rows of data (previously from Master Document that has since been updated). Data here is held in the following order: older top, newest bottom.

What I would like:
For the row in Master Document to be automatically copied into the Archive spreadsheet when I update the 'version' cell (column b). This data is to be placed in the next available space (remember newest = bottom).

I have attached my current workbook to give you an idea.

Thanks again,

Sam

You'll need to format more rows on the Archive sheet, but try this:

Please Login or Register  to view this content.

Originally Posted by jaslake

Hi s_bruno1

This Code attempts to address the issue of entering new line items in Sheet1.

Please Login or Register  to view this content.

First I would like to say thank you both for your replies.

John (Jaslake) I have tried and tested your example to which it works perfectly. Thanks very much for such a fast reply and for the working solution.

Just out of interest (and from reviewing your code) I would love to know I could learn to develop macros like this myself. Although I am a frequent user of Excel I wouldn't have a clue where to begin..!

Thanks again,

Sam