Transfer row entries onto another spreadsheet/form

[Closed]
Report
Posts
1
Registration date
Tuesday October 15, 2013
Status
Member
Last seen
October 15, 2013
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
Hi

Can anyone help...

I am trying to link information from one spreadsheet onto a form my office are using. At present they make an entry into a spreadsheet one row at a time and the information they input into the row (4 columns) they then re-input into a second spreadsheet, an internal form. I have put the spreadsheet and form onto one file (sheet1 and sheet2). Is there any way this can be done automatically, seems mad to repeat this process. The desination cells to the internal form would be different from the original spreadsheet:

By this I mean
Sheet1 Column A goes into Sheet2 Column G Row8
Sheet1 Column C goes into Sheet2 Column F Row14
Sheet1 Column F goes into Sheet2 Column B Row20
Sheet1 Column H goes into Sheet2 Column F Row16

Any clever ideas?

1 reply

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Hi Jogrant,

Is it an idea to take the last entries of the first sheet and paste them to their specific locations on the second sheet whenever the second sheet is activated?

Best regards,
Trowa