•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How can I duplicate a table based in a list from another table.
I need to duplicate a
How can I duplicate the template base on the number of tenants i have.
I have a table with a list of tenants that i need to populate each one of these forms for. Some tables have a few and others have 50+ tenants. Is there a way to duplicate this that would be faster than Ctrl + C and Ctrl + V?
If you look below you will see a table with tenants and info, below that i have another template that I need to fill out based on the tenants information.
(Table)
tenant unit # sq ft RE Tax Tax Stop
Alpha 1 500 25 10
Beta 2 1200 60 30
charlie 3 700 35 15
(Form i need to complete)
tenant name unit #
tax amount 25 stop 10 total due 15 Thanks.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#rows.com
#cloud-based spreadsheet applications
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#no-code spreadsheet solutions
#Excel alternatives
#duplicate
#tenants
#table
#populate
#template
#unit #
#tenant name
#forms
#sq ft
#RE Tax
#Tax Stop