Hi,
I have one Excel with several tabs, I would like to import the name of one tab in column and Cell F61 from each tab in another column. Is this possible?
Any help on this would be much appreciated.
Thanks,
Laura
Hey Laura,
Let me know if the steps below help.
1. Open the batch.yxmd file. You also need to have the batchreadsheets.yxmc (that is the macro file) in the same folder location so that you do not have to change any of the mapping. You do not need to open the macro.
2. Update the Input Data tool with your file. If prompted to select a sheet, select "list of sheet names"
3. Click on the macro. Make sure that the field "FileName" is mapped in the configuration panel.
4. Hit Run! You should get the results you're looking for.
If you have any other questions, feel free to send me a private message and we can get this worked out offline.
Thanks and good luck!
I realized that you were asking for cell F61, not C61. I fixed the workflow/macro and edited the post above. Download those files and give it another run.
Thanks!
Hi @furlonla you can use a batch macro to do this. I have attached an example that should work. It will take some adjusting to make it dynamic but will work for your "C61" request.
Workflow above, macro innards below.
Make sure that you point the control parameter at the field called "FileName"
Thank you for looking into this. Could you please upload the in .yxmd format please, and not as the entire workflow. Think I need to update!
