So, I have two sheets in the same workbook. One that looks nice for users to add details (first name, last name, email address etc.) and another that takes that info and puts it into a non-formatted style so it's ready to be exported into a simple CSV to import into a bit of software. It does other stuff like creates usernames etc too.
Anyway, I've managed to take the a cell reference from the first sheet into the second sheet by using the below formula;
This works fine if on my second sheet, I drag down the formula to fill as many rows as I can be bothered to drag down to.
Seen as I don't know how many rows the user is going to fill in on Sheet1, my question is how do I mirror the rows from Sheet1 regardless if they fill in 3 rows, or say 150?
Or is dragging the formula down for miles on the second sheet, the only way? It seems a little messy, is all.
Thanks!
Anyway, I've managed to take the a cell reference from the first sheet into the second sheet by using the below formula;
Code:
=PROPER('Sheet1'!B11)Seen as I don't know how many rows the user is going to fill in on Sheet1, my question is how do I mirror the rows from Sheet1 regardless if they fill in 3 rows, or say 150?
Or is dragging the formula down for miles on the second sheet, the only way? It seems a little messy, is all.Thanks!
