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.
Yes, please see the following link: https://1drv.ms/x/s!Att_U8QEycN7gzJevyq7vpzMwcTk?e=Qo853f
Also, I should clarify - we use this LOG as a tool, it is not meant to be for continuous record keeping and is not saved after each use, it's just the 'passthrough' for pasting date from and into our CRM and to create the transmittal letter.
Also, I should clarify - we use this LOG as a tool, it is not meant to be for continuous record keeping and is not saved after each use, it's just the 'passthrough' for pasting date from and into our CRM and to create the transmittal letter.
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.
- Thank you thank you thank you!! You have no idea how thankful I am for you, your help and your solution.
That worked PERFECTLY.
You are the best, Hans