I have a blank template the user will fill out. This template can have 1 completed row or 10+ rows of data. I would like to be able to click a button that will then populate a sales invoice automatically. I would need the sales invoice to only populate with the rows selected. Either (A) I need to have the macro require the user to select the row(s) desired to add to the sales invoice and then populate or (B) have a column that allows the user to check a box or something before clicking the macro button which will then look for the check boxes and only populate that rows data.
I am more than OK with you offering a better solution to this. I really do not know how to do this....I can do this no problem with one invoice per one client (each tab is named a client) however I could have different projects throughout the year for the same client and would only want to show an invoice for project 3 for example not 1 and 2.
I will be doing v lookups to pull the other data in the row, so all I am looking for is to find/select/checkmark/etc. something in column B, and paste in column AA
Is something like this even possible??