DDS - PBi Inventory Dash Board

Hi, I work in the motor dealership retail environment and would like to create a dashboard for our new and used vehicle inventory. I have two excel files one for new vehicles and one for used vehicles. 1. The files will be saved on my C Drive. 2. The branch column (A) needs a table created for a dealership name (Call them Dealership A, Dealership B etc.) 3. Branch & Stock # must be joined to create a unique ID [login to view URL] (Column B) - N must be changed to New and U to Used 5. Age (Column G) - I want ageing "buckets" as follows a) 1 - 30 Days b) 31 - 60 Days c) 61 - 90 Days d) 91 - 120 Days e) 121 - 150 Days f) 151 - 180 Days g) > 181 Days Cheers Daryl