Does Excel Do this?

[Whit]

I use excel to create bids for my company, that works
great. Then I have to re input the same info into a
document without pricing for the shop. Is there away that
I can get the same info that I am putting in a bid to
automaticly go into another document without certain
info.

 

[Don Guillett]

You can use a formula on one sheet to refer to another sheet
=bid!a2
or a macro
sheets("sheet2").range("a2")=sheets("bid").range("a2")

 

[Gord Dibben]

Whit

Several methods to do this.

1. Link the fields you want visible to another workbook. Send that workbook
to the shop.

2. Link the fields to another worksheet in the same workbook then use Ron de
Bruin's SENDMAIL add-in to send just the one sheet to the shop.

http://www.rondebruin.nl/sendmail.htm

3. Filter the bid sheet and copy the filtered results to another sheet or
workbook.

Gord Dibben Excel MVP

 

[SidBord]

I don't fully get the picture, but if you can use two
sheets, one for bid and the other for the function that
uses the bid data, then it's simple to reference the bid
sheet on another sheet: On the secondary sheet you just
write =Bid!A22 or something like that. That assumes that
the data on the bid sheet is always in a known cell or
cells. Then when you fill in the data on the bid sheet, it
automatically transfers to the secondary sheet.