{"id":3410,"date":"2021-11-03T13:41:37","date_gmt":"2021-11-03T13:41:37","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=3410"},"modified":"2021-11-03T13:42:15","modified_gmt":"2021-11-03T13:42:15","slug":"enter-value-in-cell-move-to-next-cell-without-enter-or-tab","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/enter-value-in-cell-move-to-next-cell-without-enter-or-tab\/18743.html","title":{"rendered":"Enter Value In Cell, Move To Next Cell Without Enter Or Tab"},"content":{"rendered":"<p>Hi Guys,<br \/>\nHave been looking to find the answer to this, but am getting no-where. Here is what I am trying to do.<\/p>\n<p>I have a column of cells, from C1 to C9<br \/>\nI enter a value of between 0 and 9 in C1<br \/>\nWithout hitting (Enter) or (Tab), we automatically jump to C2<br \/>\nI enter a value of between 0 and 9 in C2<br \/>\nWithout hitting (Enter) or (Tab), we automatically jump to C3<\/p>\n<p>and so on until the last value is entered into C9<\/p>\n<p>I then click on a Forms Button and the information in C1 &#8211; C9 is pasted to another worksheet,<br \/>\nand the information in C1 &#8211; C9 is cleared ready, for the next lot of values to be entered.<\/p>\n<p>Has any one got any ideas of how to go about this?<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":7},"question-category":[53],"question_tags":[],"class_list":["post-3410","question","type-question","status-publish","hentry","question-category-office"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/3410","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=3410"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=3410"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=3410"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=3410"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}