How do I set up my workbook to transfer information automatically from on
work to the next depending on what is inputted in one cell.

What I'm trying to do-
I have a set of rows with vertical information (contractor name, contact,
contact phone number, ect.) in a worksheet (Bid Information) and I want that
information to transfer to a new worksheet (Bids Sent) according to what I
insert in the column labeled sent, on the Bid Information worksheet. I want
to be able to put a "y" and have the information in that row sent to the next
worksheet labeled "Bids Sent" and from the "Bids Sent" worksheet have a
column labeled "Won/ Lost" and have the information in the rows with a "W"
sent to the "Won" worksheet and the rows with "L" sent to the "Lost"
worksheet.

Thanks for any help you can give me. I don't know where to start so looking
in the help book doesn't really help- so even giveing me a place to start in
the help book is great!

Thanks!!

I can help with this but it will take some time to explain it. There are
several ways this can be done with trapping cell inputs, using control
buttons, database functions, etc. Also consideration will required to
duplicate records, and editing records.

Send me a sample workbook of what you want to see and I will code it for
you. It will be easier then typing out everything in this forum.

santolla @ shaw.ca

"Chrissie" wrote:

How do I set up my workbook to transfer information automatically from on
work to the next depending on what is inputted in one cell.

What I'm trying to do-
I have a set of rows with vertical information (contractor name, contact,
contact phone number, ect.) in a worksheet (Bid Information) and I want that
information to transfer to a new worksheet (Bids Sent) according to what I
insert in the column labeled sent, on the Bid Information worksheet. I want
to be able to put a "y" and have the information in that row sent to the next
worksheet labeled "Bids Sent" and from the "Bids Sent" worksheet have a
column labeled "Won/ Lost" and have the information in the rows with a "W"
sent to the "Won" worksheet and the rows with "L" sent to the "Lost"
worksheet.

Thanks for any help you can give me. I don't know where to start so looking
in the help book doesn't really help- so even giveing me a place to start in
the help book is great!

Thanks!!