Hi, my first post so bare with me!
I have a master sheet of a budget for my self build project. I have allocated cost codes to my master cells i.e. First Fix is FF.
I know the formula =name of sheet!name of cell
however, I have several cells across numerous sheets that pertain to certain cost codes.
The other sheets in my workbook are named Furnishings, Building Materials, Exterior, tools, Contractors etc. Say I have named lighting in one of my sheets, I have put my Budget, Cost and VAT then Cost Code. How do I link each item that is labelled FF, across all sheets to the master sheet? E.g.
Sheet 1 = Building Materials:
Item Budget Cost VAT Cost Code
Lights £100 £85 £15 FF
Flooring £2000 £2300 £320 PC
Glazing £3000 £4200 £714 WWT
Sheet 2 = Exterior
ITEM BUDGET COST VAT COST CODE
Fencing SF
Driveway SF
Gazebo C
Sheet 3 = Master Sheet:
STAGE Budget Cost VAT Cost Code
Preliminary Costs PC
Foundations F
Wall Plate Level WPL
Wind and Water Tight WWT
First Fix FF
Plastering P
Second Fix SF
Completion C
Bookmarks