Share via

Microsoft Forms and Excel data entry

Anonymous
2020-05-12T14:01:30+00:00

I have a large Excel spreadsheet (82,000 lines) and 32 columns. It is 32 columns so that I can take advantage of the FORM option inside Excel which has that limit. I'm sending segments of this data out to others for data entry and the FORM in Excel makes it easier.  However, it is also inflexible and has aggravating limits.

Can anyone tell me if Microsoft Forms (or any other tool) can be used instead as an overlay to help data entry to an existing dataset. I see plenty of examples of the original data entry, but I need to present a partially filled out form to data entry person who will then edit or add to other fields. 

Ideas please?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2020-05-12T17:11:43+00:00

    This will give you idea about Forms - https://support.office.com/en-us/article/overvi...

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-05-12T14:34:26+00:00

    Can you give me a little bit more information about what that entails, or show me some examples?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2020-05-12T17:29:13+00:00

    thank you, very helpful.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-05-12T14:20:18+00:00

    Hello gpinkerton

    I am V. Arya, Independent Advisor, to work with you on this issue. This will have to be created using Forms in VBA specifically for your requirements.

    Was this answer helpful?

    0 comments