I need some help doing the following:I have Office Home and Business 2010, this is the version without Access, and I want to create a small macro that is triggered by clicking a floating button that only appears for cells in certain columns that have been predetermined in the macro. I also want to create a second macro that can search the results that the first macro with create, by clicking a button that is at the top of the column where the title of the column would appear, in the first cell of the column.
The macros have to perform the following functions:
Display a form that allows a date to be picked and a free text comment to be entered. Either above or below these input fields display previous dates and comments that have been entered for the cell on that line.
Each line of the work sheet begins with a unique order number and the transaction generated need to be stored in a separate worksheet with one line for each order number, date, cell, comment combination.
This new work sheet then needs to be searched by another macro, which resides at the top of the column in the active work sheet that can return lines in the active worksheet base on the section criteria in the macro, looking at the date, comment transactions stored in the other work sheet.
Bookmarks