Hello All,
I have a spreadsheet that I would like to automate, but don’t know what formulas, macros, etc. to use to make it happen, or if it is even possible. I figured that some VBA or macros would be needed, that why I posted this here. A manual, end result copy is attached.
Any help to steer me in the right direction would be greatly appreciated.
The function order is as follows:
1. Delete the first row of the RawDataSM sheet to enable sorting.
2. Custom sort the sheet for 1. (Column) F/P/Q – (Order) Fabricated, Purchased, Quoted;
(Column) Shape – (Order) Rectangular, Rect-Round, Round
3. Find and copy Fabricated Rectangular and Fabricated Rect-Round data to new Rectangular sheet
4. Find and copy Fabricated and Purchased Round data to new Round sheet
5. Auto-Sum (Total) the FabCost , Adj Shop Hrs and Adj Field Hrs columns on the Rectangular Sheet
6. Auto-Sum (Total) the FabCost, Purchase Cost, Adj Shop Hrs and Adj Field Hrs columns on the Round Sheet
None of the other columns are really necessary, but it was easier to copy and paste that way.
If this is not possible, please let me know. You Excel Gurus were the only ones I knew that could tell me.
Thanks again for your help.
Bookmarks