database from questionnaire

[Gasman]

but i don't have a clue of java script though

Nor did I a few years back, but learnt the basics for what I needed to do. Of course I have forgotten it all now and it was a hard slog anyway.
You could just copy manually when you have a completed sheet?

 

[stefanocps]

the sheet is in progress..that module is a quetionnaire that will be updated daily moe or less..

 

[Gasman]

the sheet is in progress..that module is a quetionnaire that will be updated daily moe or less..

So just collect the days data and copy to another sheet/workbook and use that?
So in fact if you had another workbook with all your formulae etc, and an empty sheet that those formulae refer to, you could copy the sheet and paste into the second workbook?

 

[stefanocps]

it is too complicated..this must be used from operator..they just need to fill the questionnaire, and when they need go to the sheet and make their filtering to get datas they want

 

[Gasman]

it is too complicated..this must be used from operator..they just need to fill the questionnaire, and when they need go to the sheet and make their filtering to get datas they want

Well if they cannot perform a simple copy and paste there is no hope for them

 

[stefanocps]

Well if they cannot perform a simple copy and paste there is no hope for them

come on..this is not the point, there are some need that must be accomplished

 

[Gasman]

come on..this is not the point, there are some need that must be accomplished

You either do everything for them, which you have admitted you cannot do, or you make it as easy as possible for them.
If I was your operator, I would have no issue copying a ramge, as long as you showed me how to do it, if I did not know.

I once created a database for my last place of work, to calculate and report on commisions.
When I was going on holiday I had to show a colleague what was needed to be done. there was a manual as well.
After showing him how it worked, he commented 'that seems simple enough'
I responded with 'You do not know how much hard work went into getting it to look that simple'

I have asked before, Why can you not just use what was entered in the form and filter on that?
You are just replacing one value with another to indicate what that value was?