newyorknix
New Member
- Joined
- Aug 28, 2011
- Messages
- 16
Hi,
I have 100 rows of data which contains sales order details.
For example each row contains order id, date, buyer address, item, quantity, price in cells.
I have a sales order excel template. Now I need to import these details to the template and print accordingly.
So finally 100 rows will be printed to 100 invoices.
Is it possible? Can I somehow import this data to an excel template and print out automatically?
I did searched with some keywords but don't know where to start. Solution would be macros I guess.
This is a repetitive task for me and it is very time consuming to do manually.
Any help would be appreciated.
Thanks in advance!
I have 100 rows of data which contains sales order details.
For example each row contains order id, date, buyer address, item, quantity, price in cells.
I have a sales order excel template. Now I need to import these details to the template and print accordingly.
So finally 100 rows will be printed to 100 invoices.
Is it possible? Can I somehow import this data to an excel template and print out automatically?
I did searched with some keywords but don't know where to start. Solution would be macros I guess.
This is a repetitive task for me and it is very time consuming to do manually.
Any help would be appreciated.
Thanks in advance!