Iam not an expert using code just learning with a excel vba for beguinners but honestly I don't know how to star trying to create a two buttons:
One is to allocate the box number in a certain position in a line
Second is to remove or delete the records once the boxes are sold to live that space open.
Then, what I want is to copy the values from column H in the "PIVOT" tab to teh "MAP" tab starting at C7. (The locations starts from G1-1 to E8-18). Also I have a column A in the "MAP" tab called restrictions, if the line contains the letter W the values from column H can be stored if not they have to be stored in location "E", whatever the location it is. (What I am thinking is to have the box number located just below the location location)
This is what I have in mind, of course if somebody have a better idea please let me know. If anyone can help me with this two buttons I would be more than grateful.
