Forum Discussion
Solved
Auto insert rows into worksheet from table in another worksheet
Hello, I have the attached spreadsheet. The Log worksheet is our 'working' worksheet and it pulls data by selecting the (+) button then (in) or (out) arrow - folder is selected and any files or e...
Thanks. If you have Excel 2021 or 365, enter the following formula in C13:
=INDEX(Trans,SEQUENCE(ROWS(Trans)),{3,4,6,7,8,9})Excel will do the rest for you.
If you have an older version, select C13:H13, enter the following formula and confirm it with Ctrl+Shift+Enter, then fill down as far as you want:
=IFERROR(INDEX(Trans,ROWS($C$13:$C13),{3,4,6,7,8,9}),"")I have included both in the attached version, in two different sheets.
Here is the link - thanks so much
https://1drv.ms/x/s!Att_U8QEycN7gzFYNDKLYbDmAvTr?e=BWMNk7
Thanks. Can you tell us how you want to select a record (row) from the LOG sheet from which you want to retrieve data to the Transmittal Letter sheet?
- Hi Hans,
I would like the data to insert automatically, no trigger other than the rows being created in the LOG worksheet. Worst case, if that cannot happen, can we have a button that 'loads' the data?> I would like the data to insert automatically
Do you mean that you want one transmittal letter for each row on the LOG sheet?
- I apologize. No, I would like all the lines that are created on the LOG, to automatically be on one transmittal letter.