Hello,
Is there VBA that can be assigned to the shape "Search Invoice" on the Invoice Template sheet? Cell O4 should have a drop down list of all previous invoices to select from. Once the Invoice in question is entered in cell O4 click on the shape to run the code.
Thank you for your help
I should have mentioned that the code will fill in the invoice from both the Invoice List and Invoice Items sheets. I also have data validation list in the cell to choose from previous invoices.
Thank you
Last edited by billy60; 04-01-2023 at 03:53 AM.
Begin by unmerging the cells in D18:F27. You should avoid merging cells because they almost always cause problems for macros. Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your "Invoice Template" sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make a selection in cell O4. You don't need the button.
Please Login or Register to view this content.
Last edited by Mumps1; 04-01-2023 at 11:13 AM.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Thank you very much for your help.
You are very welcome.
I ran into issues after doing a few searches. Maybe the merged cells aren't the problem. I do need them for perhaps multiple messages to the customer.
I updated the Invoice Template sheet so that there aren't merged cells. I needed to save the info there so I added code to the List code so there are separate lines for each D30:D34. These are saved fine now.
I will now need a way to retrieve all of this information for the search previous invoices.
Can this be done?
Re: I do need them for perhaps multiple messages to the customer
Mumps mentioned it in his post. Here are a few articles to read.
https://edu.gcfglobal.org/en/excel-t...rging-cells/1/
https://theexcelclub.com/stop-do-not...hy-with-fixes/
https://www.perfectxl.com/excel-tool...t-merge-cells/
Experience trumps academics every day of the week and twice on Sunday.
You still had merged cells in D18:F27. I have unmerged them and it works properly. Try the attached file.
I'm not sure what you mean by this statement. Please explain in detail referring to specific cells, rows, columns and sheets using a few examples from your data.I will now need a way to retrieve all of this information for the search previous invoices.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks