{"id":8241,"date":"2021-11-28T02:10:13","date_gmt":"2021-11-28T02:10:13","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&#038;p=8241"},"modified":"2021-11-28T02:10:33","modified_gmt":"2021-11-28T02:10:33","slug":"solved-auto-insert-new-row-on-different-worksheet","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/office\/auto-insert-new-row-on-different-worksheet\/20151.html","title":{"rendered":"Solved Auto Insert New Row On Different Worksheet"},"content":{"rendered":"<p>I have a spreadsheet with 10 worksheets on it, 1 for each supplier with the same standard layout on each:<br \/>\nColumn A: Product Code<br \/>\nColumn B: Product Name<br \/>\nColumn C: Cost Price<br \/>\nColumn D: Sales Prices<\/p>\n<p>I use these individual spreadsheets to import my products to sage. It would make life a lot easier if I had 1 worksheet in this same file with all the information from the others so that I would only have to import 1 file e.g. every time i add a row of information to either one of those 10 supplier sheets it adds a new row with the same information into the master sheet. How would i do 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":5},"question-category":[53],"question_tags":[],"class_list":["post-8241","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\/8241","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=8241"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=8241"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=8241"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=8241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}