Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 - paste special option
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 "$0.00". 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 "read only" (so I don't overwrite it each time) with the bid list...is that causing my problem? Thanks, Robert |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 - paste special option
Robert, please check out my tutorial for an order form/invoice. I believe
creating something like that will work well for you: http://www.officearticles.com/tutori...soft_excel.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com Check out: www.ExcelUserConference.com "Robert K" wrote in message ... 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 "$0.00". 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 "read only" (so I don't overwrite it each time) with the bid list...is that causing my problem? Thanks, Robert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using the paste link function in Excel 2003 | Excel Worksheet Functions | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
excel paste special should allow text | Excel Worksheet Functions | |||
Excel 2003 - the "X" to exit the application option is greyed out. | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |