Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

General discussion


Using excel to store information automatically

By jphillips ·
OK, I am at a loss. I have limited excel experience and i am trying to accomplish something that i dont even know excel is capable of doing.

I am trying to create a log-in program for test samples in my lab. the samples are normally tested at different dates and they must all have unique, consecutive numbers. for example, if i have 5 samples from this job, they could be numbered 1000-1004. the next five that come in (say 6 of them) will be labeled 1005-1010. we currently hand write the project numbers and ID numbers in a book, but i want to eliminate that due to the errors and lack of efficiency.

SO... i would like to tell excel how many samples i have and when each one of them are to be tested (in days) based on the date cast.
example: 5 samples, cast on 3/24, test one at 7 days, 2 at 28 days and hold one for later testing. At this point (this is where i am stuck) i need excel to look into the next sheet, see the first available (empty) cell and paste the information there and return the corresponding numbers... does this sound crazy?

any help is greatly appreciated.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

You need a macro

by bschaettle In reply to Using excel to store info ...

It's quite possible to do this in Excel, but it would involve writing a macro to do all the steps you want. Based on your experience level, I would classify this as "not do-able."

Related Discussions

Related Forums