Share via

Fillable form and tables

Anonymous
2025-04-05T14:52:25+00:00

I have created a fillable form and when hit the submit button the information is then added to a table on a different worksheet. Now I would like to extract certain parts of the table information and having trouble, when a new line is inserted the formulas need to be added to.the new lines. I have tried using macros to help but no success. Is there a way to extract and use the new information without actually having to manually add the formulas each time?¹

Microsoft 365 and Office | Excel | For home | Android

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-04-06T06:22:21+00:00

    Hi Michael,

    Welcome to Microsoft Community.

    Based on your description, using VBA clipboard commands to perform a complete copy with formatting should achieve what you need. Could you please share a screenshot of your workbook? This would help me tailor the code to your actual setup.

    Also, I noticed you posted this question in Android section (Microsoft 365 and Office / Excel / For home / Android). Please note that VBA is only supported on desktop applications (Mac & Windows) and cannot run on mobile devices (iOS, Android, or iPad). Moreover, for such advanced custom functionalities, if VBA is not an option, the only alternative would be to leverage Power Automate with a Microsoft 365 Business subscription license to implement automated workflows.

    Please share more context/details so I can help you find a better direction, and I'm looking forward to your reply!

    Best Regards,

    Thomas C - MSFT | Microsoft Community Support Specialist

    0 comments