Tracking serial numbers

Hi there,

I want to do the following:

I have 6 sheets (U1-U6) with information and 1 tracking sheet.

When I update information in the tracking sheet I want it to automatically update the serial number in the U1-U6 sheets.

For eg: if i put the following information into the 'Tracking' sheet:

Date: 19/03/2012
Description: CEP
Serial: 123
Previous Position: U1
Current Position: U2

Then it will update the serial number in sheet U2 to 123. Hence track the number 123. The 'Tracking' sheet allows for a type of historical record so that I can track serial numbers for many years to come.

I have a lot of information with a lot of serial numbers hence I can not just link it to a specific cell.

any ideas will be most welcome

I guess this is possible with Excel, however I can't urge you strongly enough to use a database - probably access.

Relational databases are designed for this type of activity and it is trivial, Excel isn't and will unless carefully managed leave holes and inconsistencies in your data.

Using a database is scalable, fast and is designed for what you are wanting to do, much better to use a piece of software that is designed for a specific task rather than shoehorn a glorified calculator into something it isn't designed to do.

I would still like to use Excel if possible

In that case I will humbly bow out of this question and let someone answer who has experience with this

Add this code to the Tracking worksheet code module

Please Login or Register  to view this content.

sorry but how do I do that?

On the worksheet tab, right-click and select View Code.

Hi

Thanks, but I dont really want cut and paste from one sheet to the other. Ideally, I would like just the serial number to be updated ie not appended.

Thanks

So what is the previous position on the tracking sheet all about?

This is so that in the future I will be able to track the serial number. Ie I can create a history record. For eg I will be able to say CEP 123 went from U1 to U2 on this date then from U3 to U1 on that date etc. Thus I would be able to know where it was previously

can you help? please?