Hey Excel people,
Let's imagine I currently have five different excel sheets in one workbook, each for a different type of a fence i.e. Fence Type 1, Fence Type 2 etc.
I'd like to have just one Master sheet where the basic info could be stored and any data that's shared across the different types of fences, like delivery and installation costs would be the same.
I'd like to have a button or a drop list where I select which type of fence it is and have excel auto populate cells for me, both text and numbersm, or bring whole areas over.
Is this something excel can do without having to go into Macros as those are ALWAYS a pain in the ..
Thanks,
Bookmarks