combine sales forecast from multiple representatives

G

Guest

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.
 
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Kinda like a database - I can’t believe others don’t need to do th 3
Calculating forecast accuracy as a percentage 2
Pivot Table as a data collection tool 1
Create formula that combines numbers from multiple workBOOKS? 1
Date formula not picking up 1st of the month (weekday) 3
Enter number (data) into cells but want to show different data 3
Available to sell 1
Excel formula????? 3

Top