Form & Data Entry set-up

  • Thread starter Thread starter rei04
  • Start date Start date
R

rei04

I need help on how to create the following:

20 Account names across the top
30-50 Product line down the left

All Accounts & Product Line for the following months of:
September
October
November

1. I need to create a Form (pop up screen in excel) that can simplif
data entry (in quantities) for each cell.
2. I can't figure out a way to separate the months without using tabs.
3. Various people will enter data from separate locations.

**I will then crunch information using a PivotTable. (Unless there i
an easier way)

Example:

________Account 1| Account 1 Goal| Account 2| Account 2 Goal|
Product 1
Product 2
Product
 

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


Back
Top