Shape manipulation in Excel
The workbook contains five worksheets.
1 Collated Raw Data Table
2 Base Data Weighted Table
3 Adjustable Weighting Table
4 Map
5 Map 2
In worksheet 4 Map the macro script allows the user to amend weightings in Row 1 and Row 3 and the circle sizes in the map will change.
In 5 Map 2, I have relocated the table to the left hand side of the map. The macro script needs to be amended to work in 5 Map 2 as it does in 4 Map, and 4 Map needs to be deleted from the file.
This requires a small change to the script but it is beyond my capacity.
28960761example.xlsm
1 Collated Raw Data Table
2 Base Data Weighted Table
3 Adjustable Weighting Table
4 Map
5 Map 2
In worksheet 4 Map the macro script allows the user to amend weightings in Row 1 and Row 3 and the circle sizes in the map will change.
In 5 Map 2, I have relocated the table to the left hand side of the map. The macro script needs to be amended to work in 5 Map 2 as it does in 4 Map, and 4 Map needs to be deleted from the file.
This requires a small change to the script but it is beyond my capacity.
28960761example.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER