you would need to make separate sheets for the reps and then cut & paste
their updates and have a single sheet that would summarize the individual
sheets. you might also want to check out spreadsheet consolidation solutions
that use a database (like boardwalktech)

"kcip" wrote:

how to combine data from multiple sales representatives forecast worksheets
in excel. want a single comprehensive excel sheet that summarizes the data
from each individual sales representatives forecasting excel worksheet.