software

I have 2 spreadsheets: 1 that I use for materials prices and 1 that I use to
calculate a bid. When I cut and paste (special) from my price list into the
bid list everything works OK. I've noticed that even if I insert rows or
columns in my price list, the values in my bid list stay correct. I protect
the bid list so it is easier to enter the measurments, etc. to calculate the
bid.

My problem is that when I pull up the spreadsheet again after I've moved any
cells in my price list, most of the bid numbers will read quot;$0.00quot;. It
appears that the formula for that cell will now read any changes I've made to
the position of the price list cells, even though it works fine when I test
it....any ideas?

I select sheet protection and file quot;read onlyquot; (so I don't overwrite it each
time) with the bid list...is that causing my problem?

Thanks,
Robert

Robert, please check out my tutorial for an order form/invoice. I believe
creating something like that will work well for you:
www.officearticles.com/tutori...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out: www.ExcelUserConference.com

quot;Robert Kquot; gt; wrote in message
...
gt;I have 2 spreadsheets: 1 that I use for materials prices and 1 that I use
gt;to
gt; calculate a bid. When I cut and paste (special) from my price list into
gt; the
gt; bid list everything works OK. I've noticed that even if I insert rows or
gt; columns in my price list, the values in my bid list stay correct. I
gt; protect
gt; the bid list so it is easier to enter the measurments, etc. to calculate
gt; the
gt; bid.
gt;
gt; My problem is that when I pull up the spreadsheet again after I've moved
gt; any
gt; cells in my price list, most of the bid numbers will read quot;$0.00quot;. It
gt; appears that the formula for that cell will now read any changes I've made
gt; to
gt; the position of the price list cells, even though it works fine when I
gt; test
gt; it....any ideas?
gt;
gt; I select sheet protection and file quot;read onlyquot; (so I don't overwrite it
gt; each
gt; time) with the bid list...is that causing my problem?
gt;
gt; Thanks,
gt; Robert