I have a drop down list on the first sheet "WetCheck" which pulls from a list of job #s. Based on the job # selected, other fields on the sheet populate information by pulling from a separate sheet "Master List". There are about 150 jobs.
I need a macro to run through the list, selecting each job # and then printing the worksheet template, for every job #. Please make the macro run for every active job, for up to 250 rows.
Printing to PDF is preferred.
Hi,
I am good at excel and macros... I can create vba. Please see my experience list in the freelancer.
I will create vba to meet your requirement with all the conditions satisfied.
Looking forward for your reply to start the work on immediately.
Hi there - My name is Paris.
I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA.
In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. I can start working on the project immediately and complete the job within some hours.
Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees.
Regards
Hello,
I've done numerous auto-reporting tools by combining Access, Outlook, Excel ... I can help you with the problem you have.
Looking forward to working with you.
Kind Regards
I already worked on a project for an insurance firm where I automated the process of getting data in specific format using macro code in VBA.
I will create a macro which button in the excel which when clicked will generate the printout with the data in a format as required and will give the instruction sheet where a non VBA person will be able to edit fro future needs.