I have an excel with 2 sheets.
First sheet is table with customer names, company id, phone numbers etc.
Second sheet is a form which is using the data from sheet 1. Data are automatically updated on the sheet 2 based on first (filtered) line from the sheet 1. I am using company ID.
There ate around 300 lines in that table (sheet 1) and what I do now is to filter out one customer, go to sheet 2 and press ctrl+p and repeat that 300x to print all my customers to form and I want to automate this if possible?