View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joel joel is offline
external usenet poster
 
Posts: 9,101
Default resources & rates importation into MS Project

Look at worksheet menu Data - Validation. You can restrict the type of data
that can be entered into a cell.

"Maurice" wrote:

Greetings:
This question has been submitted in prior postings with no responsive reply.
There is supposed to be a way for someone with excel to insert data
pertaining to the rates of workers as well as equipment. From this, MS
project can calculate the 'spend' rate for any person/ equipment.
Apparently, such data [which can possibly include overtime and other charges
for each worker and/or equipment] must be entered into the spreadsheet in a
certain way not apparent to excel novice. Exportation of data to a
spreadsheet is not a problem... It is the importation. Much thanks for any
guidance