I have a workbook with 7 sheets. The master input page "Prices". When I input the data in the cell (C3) in the row, I need a macro that will input that data in the appropriate sheet (example:Store 3) and the next blank cell in a specific row (example: Vases). Hope I've explained this issue, The same for each of the new input.
Also, can I have the copied data be a different color based on criteria (High, Low, Average)?
I've spent way more time than I'd like to admit without success.
BTW: I am on PC Windows 10 using Excel 2016. Thanks in advance for any help on this.