Hi all,
I feel like this is an easy issue, but can't seem to figure it out. In short, I have a workbook to populate a form based off a table of data points. One form = one row in my data. My workbook has 3 tabs, one is a mass data entry, one is a filtered data entry, and 3 is the form. I want to copy the form tab x number of times based on how many rows show in the filtered data entry tab.
For example, if my filtered tab has 4 rows of entry, i need my "Template" tab to copy 4 times. I'm then using an offset formula on each new copied tab to pull the the correct row of data from the table.
Thanks
I feel like this is an easy issue, but can't seem to figure it out. In short, I have a workbook to populate a form based off a table of data points. One form = one row in my data. My workbook has 3 tabs, one is a mass data entry, one is a filtered data entry, and 3 is the form. I want to copy the form tab x number of times based on how many rows show in the filtered data entry tab.
For example, if my filtered tab has 4 rows of entry, i need my "Template" tab to copy 4 times. I'm then using an offset formula on each new copied tab to pull the the correct row of data from the table.
Thanks