Transfer cell information into a new free cell and clean after pressing enter

Yes, this is within the realm of Excel. It will have to be completed using VBA. If you post a copy of your workbook with before and after examples, I am sure that one of our outstanding volunteer members will have a solution for you.

There is something that i don't understand..

In H2 you have this formula.

=B2-C2+D2-E2-F2-G2

Why does not this formula works ok? Can you explain a little more pls?

Originally Posted by juliangun4ev

Maybe I can't explain well

OR

Maybe i don't understand well!

So let's wait to see if someone else will be able to helps here!

Hi Juliangun4ev,

I´ve checked on your example and it can be done, Not sure if within the boundaries of formulas & functions but within macros most certainly. Thing is, without final example how the file should look like is kinda hard to figure out because of few reasons:

1) dunno the structure where in the following sheets you want the results
2) cant decide like this where to use absolute reference and where relative
3) there will be quite a lot of global variables to achieve what you´re looking for, So one might wanna ask if its necessary to clear the field straight after pushing enter button, if it werent better to make a button to clear the selection or make something else to clear the range ... would clear those global variables of the table and the file would be much faster and less messy, also it might bring up the file back to formulas&functions boundaries

I´d suggest you to make more precise example, cause like this It´s immense heap of work to catch all the possibilies and to give you some code to execute what you want....which i feel like is not necessary

EDIT: OR, just realized, you might need to use one trick I´m using (calling it myself mirroring) which is making a worksheet containing all the background dirty work hidden from the users, where you´d be keepin all those inputs whilst frontpage remains empty and clear, which would be somewhat halfway between what you´ve said above and what you´ve described as desired outcome....but still would appreciate more precise example