I have a simple spreadsheet that imports data into Sheet1 and ranks it low to high with a major number category in column A and a sub category number in column B. It then has a description in Column C.
I need a simple macro that looks at Column A, B and C in Sheet 1 and whenever that data changes, it updates column A and B in Sheet 2. The trick is that Column A in Sheet 2 is actually the combination of Columns A and B in Sheet 1. The information in Sheet 1 Column C goes to Sheet 2 Column B.
Much thanks in advance. Sample Sheet attached.