Hi all. I'm trying to make a spreadsheet to keep a process organized. It's a multi-step process and here is what I had in mind:
Page 1 is an overview of what things need to be done with a pull down of steps to be achieved: received, labeled, processed, sent, etc.
On the following pages I would like to have the steps broken down. For example, page 1 would be titled received and when "received" is selected from the pull-down on page 1, the item would be copied from page 1 to page 2. Does that make sense? It would be like a filing system, copying items from page 1 to other pages depending on where in the process the item currently is.
I'm not sure how to go about this. I'm completely self-taught at Excel and I've confused this teacher. LOL Anyone have any advice or can point me to a better way to describe/research what I'm trying to do?
Thanks in advance!~