how to enter vaues at the same time in two sheets..

[djmag]

hi,

hope you are all good, i have been trying to make efficiency sheet and i entered data every day and after having print i remove my previous data and enter new data and so on..

i would like to keep my all the records what i entered yesterday and today and so on.. i want to keep all the records so that i can fetch easily in future...
i have attached the efficiency sheet please have a look and if you can help would be really appreciate that..

best regards
djmag

[Shello]

hi
Do you want ot copy\ append Input sheet data to next sheet for future reference ?

[dilipandey]

Hi djmag,

So you would like to enter data in "Input" sheet and then same would appear on "sheet1" correct?
and next day you want to follow the above process for next DATE but you don't want your previous data to be disappeared.



Regards,
DILIPandey
<click on below * if this helps>

[djmag]

hi SHELLO..

yes i want to copy from INPUT to SHEET1 just for future reference.. but i enter new data every day.. so i wanna keep my previous day record..

[djmag]

Hi djmag,

So you would like to enter data in "Input" sheet and then same would appear on "sheet1" correct?
and next day you want to follow the above process for next DATE but you don't want your previous data to be disappeared.



Regards,
DILIPandey
<click on below * if this helps>

hi there,

You got me.. Exactly ....

[djmag]

Hi djmag,

So you would like to enter data in "Input" sheet and then same would appear on "sheet1" correct?
and next day you want to follow the above process for next DATE but you don't want your previous data to be disappeared.



Regards,
DILIPandey
<click on below * if this helps>

Should i expect some help please ?

[Shello]

Please check if this helps .....
Enable the macro and dont change the sheet names...test1.xlsm

[djmag]

Please check if this helps .....
Enable the macro and dont change the sheet names...Attachment 222110

THankyou so much for your help indeed, one more question is that possible to do this without VB? as its risky

[dilipandey]

If you don't want VB, then you can work basis dates. you can lookup and file up your results in sheet1 but again.. once data is entered, you need to drag down formulas and do copy paste special values on the previous formulas. So I believe macro (vb) is good to go. thx


Regards,
DILIPandey
<click on below * if this helps>

[djmag]

If you don't want VB, then you can work basis dates. you can lookup and file up your results in sheet1 but again.. once data is entered, you need to drag down formulas and do copy paste special values on the previous formulas. So I believe macro (vb) is good to go. thx


Regards,
DILIPandey
<click on below * if this helps>

yh i do prefer that but i am not macro users.. i am trying to understand the way "SHELLO" did exactly..

[djmag]

yh i do prefer that but i am not macro users.. i am trying to understand the way "SHELLO" did exactly..