Hello,
I am looking to create two separate buttons using VBA and have not been able to successfully write a working code for either.
I am trying to have both these buttons edit every Excel file in the same folder as the excel workbook containing the button and every sheet within each Excel workbook.
1. For the first button I am hoping to add data to three columns within a given range of a workbook and to have this data displayed on the next available line. To clarify, each sheet in each workbook has the same Bill of materials template on it, and each bill of material has a revision log within range Q3:U10 (three data columns made larger by merging cells). Each bill of material may have a different number of revisions, so I was hoping the user could be prompted to enter the data for the 3 columns (rev,date,description), and the information will be added to the next available line of each worksheet's revision log. The other buttons I have so far are in a separate workbook and alter all files contained within the same file folder.
2. Similarly I was hoping to create another button which when pressed would prompt the user to input a part number (Located in column A) and then type a note which would be displayed in the part number's corresponding notes column (column AB). Just like button 1, I was hoping to have this is in separate workbook which would then alter every sheet of every workbook located within the same file folder.
I realize this is a complicated series of questions. I appreciate any help or any reference information!
Thank you
I am looking to create two separate buttons using VBA and have not been able to successfully write a working code for either.
I am trying to have both these buttons edit every Excel file in the same folder as the excel workbook containing the button and every sheet within each Excel workbook.
1. For the first button I am hoping to add data to three columns within a given range of a workbook and to have this data displayed on the next available line. To clarify, each sheet in each workbook has the same Bill of materials template on it, and each bill of material has a revision log within range Q3:U10 (three data columns made larger by merging cells). Each bill of material may have a different number of revisions, so I was hoping the user could be prompted to enter the data for the 3 columns (rev,date,description), and the information will be added to the next available line of each worksheet's revision log. The other buttons I have so far are in a separate workbook and alter all files contained within the same file folder.
2. Similarly I was hoping to create another button which when pressed would prompt the user to input a part number (Located in column A) and then type a note which would be displayed in the part number's corresponding notes column (column AB). Just like button 1, I was hoping to have this is in separate workbook which would then alter every sheet of every workbook located within the same file folder.
I realize this is a complicated series of questions. I appreciate any help or any reference information!
Thank you
