Forum Discussion
Creating Forms from Spreadsheet List
Hello, I have a two sheet excel document - sheet one is multiple rows of data in a list form, sheet two I need to create one page forms of exact template where I insert a cells from sheet one. I...
logicalplease Where is the third page? Are the pages aligned horizontally? Every page is 4 columns to the right of the previous page? If so, take a look at the attached file.
Sheet2 has formulas starting in B7 and copied across. The formula is different in each row, because it returns text from a different column in Sheet1.
Copy the formulas across as far as required to get to the data in row 96 (my sample does not have that many rows in Sheet1).
Then you can copy all the columns and use Paste Special > Values to replace the formulas with the text that they returned. This will get rid of all the formulas that are in the empty columns.
Let me know if that works for you.