Simonrepro
asked on
Adding some code to sort data into macro
The attached spread sheet has a macro which takes data from worksheet 'Stock' and presents the results in Worksheet 'Value'. I would like four things done to this macro please.
1. When Macro is run sort data 1-999 in the column with the heading 'Category'
2. The cell B13 in the 'Value' worksheet keeps appearing in bold I would like it to not be in bold.
3. The heading 'Value' in worksheet 'Value' to be bold please.
4. Could the two headings 'Category & Value' both be postioned to the right of the cell they are in.
Any help greatly appreciated
Monthly-Stock-Valuation.xls
1. When Macro is run sort data 1-999 in the column with the heading 'Category'
2. The cell B13 in the 'Value' worksheet keeps appearing in bold I would like it to not be in bold.
3. The heading 'Value' in worksheet 'Value' to be bold please.
4. Could the two headings 'Category & Value' both be postioned to the right of the cell they are in.
Any help greatly appreciated
Monthly-Stock-Valuation.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No probs, thx for the grade :)
ASKER