1 min readfrom 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.

submitted by /u/ExpertAd4657
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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