Forum Discussion
Invoice generation in Excel
I am looking for help! I am trying to create a template where my vendors can enter their raw invoice data to excel, and it gets translated to the 2nd tab invoice and I am running into the below issue:
-some data consistently is only for 30 rows but then others will have upwards of 800
How can I format this, so that despite the amount of rows of data, Excel will create additional pages/tabs to accommodate the additional lines while maintaining the printablity and final total at the end of the invoice?
Alicia-
This is certainly possible with VBA. It would greatly help the community answer your question if you would provide a non-sensitive sample file that illustrates what you are trying to accomplish. It would also be nice to have a before and after example so it's easier to test the solution for you. Basically, the more detail you give the easier it will be for an Excel Community member to assist you in your endeavor.
