Share
Report
2Hi, I am trying to use the:
Send an email with options, but I will need to show some data from my excel workbook - ProjData that contains 4 different sheets. Working on the first Spreadsheet, - named "CR1 "
To show the data, I will need to use the "For a selected row" function to extract the data needed. "For a selected row" has a "Table" option, that needs us, within excel, to manually convert tables to range and back to tables each time (because we the number of rows in "ProjData" is changed). - I have rummaged through the net for a solution to this by watching this video on
How to create Excel table dynamically -
https://www.youtube.com/watch?v=Q4Q_OWEa-Jw&ab_channel=abmabm
However, due to the nature of my 4 sheets, and a bunch of other issues, it is not working for me to automatically convert [table to range] and [non-empty cells to table]
I would require some advice on this. thank you for reading
All responses (
Answers (
