i exported product's data (product name, options, price, etc) from my e-commerce website (as attached in 3rd excel file below)
there's a column in this excel file that contains the price data (formatted into a group of data as seen in 4th excel file below)
i want to highlight specific rows from this price column (in 3rd excel file's Column AG) and right-click.
from the right-click, it will create two new copy options.
1st copy option is pop-up a dialog window to ask me the percentage to discount/markup, after i type the value, the macro will start to process and calculates each prices from the highlighted row, and change the price based on the markup i typed (but remember to search within the formatted price and replace the necessary values only)
2nd copy option is pop-up a new window that lets me copy-paste two columns of data (quantity / price) after that i close the window, the macro function will start to detect the quantity and price from the formatted price data in column AG and replace the values from the rows that i highlighted previously