•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Duplicate field below table
Our take
Are you struggling to efficiently duplicate a form based on a table of property information? You're not alone—many users find traditional methods cumbersome. Fortunately, with AI-native spreadsheet technology, you can streamline this process. Imagine automatically generating forms that reference your property data, minimizing repetitive tasks while maintaining clarity. In this guide, we’ll explore a practical solution to dynamically copy and reference rows in your spreadsheet, ensuring you spend less time on setup and more on what truly matters—managing your properties effectively. Let’s dive in!
Please see the wdit below.
Hi All, I am trying to create a form based on a table I have. ( I am using the word "form" loosely, could be a template)
There is a table with property information anywhere 2-20 properties, and each sheet is a property. I have the property information below the table, and I think it is the address.... To the right of the property information, I have an amount with payment amount and balance or credit due.
I created the 1st one. The persons name is in the drop-down, and the relevant fields are referenced using xlookup. The form takes about 5 rows of spac, and then I want an empty row and page/print break. Followed by the second in the table. Hopefully, it can stop based on the number of persons on the table.
Is there a quick way to do this? Otherwise, I will just copy and paste the template for each tenant?
Thanks
Edit: I have added a link. The link shows the opposite of what I want to accomplish. I have the table to the right , but I want to copy the rows A1:C6 every interval and A2 I want to reference E7:E11.
Opposite of the link (https://www.extendoffice.com/documents/excel/3661-excel-return-value-every-nth-row.html)
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- 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]
- Insert row that once data from column A to W is filled in, it moves the row down? I saw something about adding a button to manually make it shift with developer insert. That would be ok, but it seems like its conflicting with the columns I have as drop down options.Using Excel desktop app version 2606 I'm self taught with excel, I'm trying to make a sheet for tracking jobs for work. I'm not even sure if this is possible as I've seen conflicting things online. Is it possible to lock my 7th row as a input field and when I complete all columns A to W it will shift the row down? I did make tables for some of the columns to have drop downs, maybe I'm over complicating things and stuff is conflicting. I was trying to have AI walk me through some options. one was inserting a table but its not letting me. In short the row of things I want tracked, A through W. Would greatly prefer if I could keep drop down options for some of them. Biggest thing I would love to have is the first row be empty until I fill all the fields of data out, then it shifts the row down. I have a column of a "setup date" that I will sort the list by, All I want is to be able to have a input field and not have to go to the bottom of the list to add stuff every time. https://preview.redd.it/anq0vxlfxoog1.png?width=2014&format=png&auto=webp&s=93af3fff9c5f5aa34f64b111f298c2cdcc778144 submitted by /u/Firealarmfriday88 [link] [comments]
- Change contents of cells based on a drop downSo, I'm trying to generate a spreadsheet to make the forms we use in the office to issue keys. When people are given an apartment, we have a sheet with all the key numbers on it, and then they sign for it. At the moment, we've got 22 different PDFs and Word documents, and it doesn't work. So, what I want to do is this. I've built the template in Excel and created a Reference sheet which will have all the numbers in it. What I am trying to do is set it up so that when you use the Apartment number from a dropdown, it populates with all the key numbers. This sounds like it should be easy to do, but my Excel brain is broken. Advice would be much appreciated! submitted by /u/Hot_Syrup_1774 [link] [comments]
- How can I make a single selection drop down auto fill a ton of other cells?I've not used excel much so I'm in way over my head. I've watched a bunch of videos and can get one cell to fill from a drop down but it seems to only work if they're 'lined up' with each other? For example in the 1st picture below, the drop down I have I can get 5 and 10-year to autofill MSUP 1st and 2nd Coats respectively, but only if they're next to each other as shown. I may not be explaining this well, sorry in advance if I am, I pretty much just want to select one product / warranty and have it auto fill all the green. I have templates on another sheet posted below that I've been copying and pasting when I price out jobs but it's just not efficient at all. I suspect that I have to organise or format my 'templates' somehow in order to make the V or X lookup function reference it? Either way, I'm pretty lost, so any help is appreciated, thanks guys!!~\~ EDIT: ok I've managed to get the drop down list to populate the correct items for 1 product by 'tagging' but this is reliant on putting this formula in each of these highlighted cells. My problem now is these cells are 'locked' looking for data from the same area as this 1 product, but I need it to search the entire sheet. When I select the entire sheet for the 'return array' it gives a value error presumably because it's trying to pull more than 1 value and put it in a single cell from my 'tags'. I suppose I could make a sheet for each system template we have but that would be cumbersome to work on. Is there a better way to do this? Am I even making sense? haha =XLOOKUP($B$7,Sheet1!A20,Sheet1!B20) https://preview.redd.it/cfm0r533e2ng1.png?width=834&format=png&auto=webp&s=aabf27687150d1700dd5e99f406106e4f884f17b https://preview.redd.it/l2k8ory9e2ng1.png?width=908&format=png&auto=webp&s=7d0377af01f791ca49d9a0ff71866597d6ee03be https://preview.redd.it/dgm52mnbe2ng1.png?width=978&format=png&auto=webp&s=e5c636d22dc284402b5ebe60fb1da9b531ebc248 submitted by /u/MahoganyDesk [link] [comments]