I would like to create a form in which i can submit data to populate in a
spreadsheet. Then using the form as also an interface to filter the data that
i populated in the spreadsheet.

Basically what I am trying to do is create a research learnings library.
From all the different research that we have accumulated on a list of topics
- want to house it in one place with an identifier of what was positive
vs.negative feedback.

So on a later date or if another user wants to filter the spread sheet
either by negative feedback or by topic - all research will display.

Hopefully I am making sense.

Welcome to the group!

That's a bit of a tall order so I'll suggest trying to bite off some small
chunks to start.

First, check out Excel's native Data--Form. If that's not suitable (it's
pretty primitive), then check out www.contextures.com. There is a good
tutorial there for building user forms that can add sequential data to a
sheet.

Hope that helps,

Smitty

"Faiza" wrote:

I would like to create a form in which i can submit data to populate in a
spreadsheet. Then using the form as also an interface to filter the data that
i populated in the spreadsheet.

Basically what I am trying to do is create a research learnings library.
From all the different research that we have accumulated on a list of topics
- want to house it in one place with an identifier of what was positive
vs.negative feedback.

So on a later date or if another user wants to filter the spread sheet
either by negative feedback or by topic - all research will display.

Hopefully I am making sense.