I assume I would need a macro, but I am wanting to have a button where-by the user clicks to create another 100 rows and in-turn, continue the formula's that reside within the columns and rows above, down...
Anyone help with this?
I assume I would need a macro, but I am wanting to have a button where-by the user clicks to create another 100 rows and in-turn, continue the formula's that reside within the columns and rows above, down...
Anyone help with this?
Well, it would highly depend on the exact details of your form.
For starters, I'd probably convert your data range to a table. (Select Data, Insert->Table)
This will automatically repeat all formulas when you move to the next line. If you attach a sample, I could write a macro that accommodates your exact needs beyond that.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Hey Daffofil11 - When I am on lunch, I will do exactly that
Thanks very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks